8. Lael wants a quick way to look up students by their Student ID. In cell Q3, nest the existing VLOOKUP function in an IFERROR function. If the VLOOKUP function returns an error result, the text Invalid Student ID should display.
8. Lael wants a quick way to look up students by their Student ID. In cell Q3, nest the existing VLOOKUP function in an IFERROR function. If the VLOOKUP function returns an error result, the text Invalid Student ID should display.
Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
Related questions
Question
How to do those questions in Excel and show the right formulas with no errors to make sure that works?
![x
File
D
e
H
AutoSave off
Undo
08
Home
8W20999
100RR20
TW75774
71 25220
2004361
238757
68170
76M89375
5963900
Youth
'R CR2505
YASK
20160811
21 046785
22 075/81
23 VT3590
24186247
Paste
1 Student ID - Name
Name
2 G62018
Kay Colbert
3 149134
4W99035
5 V42056
G
159828
7 F72411
25 90060
20
A
PUNAN
27 U68627
78 Y88831
29 P23373
30 H59454
35
34
3t
21 ANNAR
[32]
36
SY
20
39
401
42
Clipboard
Insert
4
X
G
B
Michael Cracies
Brandon Miles
Michael Alvarez
vix x ✓ fx
B
les Smith
Retty Garza
Leroy Pirele
Waren Stewart
>
Stacy Wiggins
Dilly Hald
Draw
Margaret Crur
Chester Kuc
Chaugen Littell
Florence Miller
Kimberly Gerace
Romar Goble
Jucelyn Allen
Ron Marse
Roberta Tri
NP EX19 /aJeffreyWang 2
Calibri
BI IU--
Age
24
25
mes Rusnak
Suranne Lawrence
Shannorturner
Emory Littin
wana Li
Florella Cauthen
Beverly Herry
Ly Russell
A Sifford
Stephanie Papa
Wallace Rivel
21
22
19
24
Page Layout
Post-Secondary Years
18
18
24
21
23
18
19
21
20
22
22
20
21
19
17
24
18
25
21
18
23
10
24
14
25
D
Documentation
Font
Formulas
a
6
7
2
Base Rate
3
4
2
6
10
11
6
3
5
0
1
3
B
4
4
A
3
1
1
11
5
6
0
5
1
4
3
7
→
A A
A 二三四五
16.50
10.50
15.75
15.75
15.75
-50
26.50
17.50
++
15.00
16.50
13.35
16 50
Data
C
G
Class Finance Certified
3022 Yes
15.00
15:25
15.75
17.50
15.75
15.73
15.75
==
2023 Tes
2022 Yes
2012 Yes
2004 No
2025 Y
2022 Yes
2025 No
2025 Yo
2022 No
2650
13.25
17.50
15.25
16.30
Review
2023
2004 No
==
2020 Y
2025 Yes
2021 Yas
15.15
35.75
13.00
16.30
16.50 20122 YOU
15:00
2025 Nu
2023 Y
2025 Yes
2023 Yes
2025 Yes
2022 Yes
2022 Y
2025 No
21122 Yes
2025 Ves
2014 No
2025 Yes
2022 No
2009
28 Yes
View Help
Alignment
Grad Student
Yes
Yes
No
No
No
Yes
Yes
Na
Yes
Nat
No
No
KA
No
Na
Yes
NO
No
No
Nu
No
No
No
Yory
Yer
No
No
No
Yata
No
Yx
You
1
ab Wrap Text
Student Representatives Academic Groups
Merge & Center
Flected
No
Yes
Yes
No
Yes
No
No
No
Yer
No
No
Nu
No
Na
No
No
Yes,
No
No
Ye
Yes
No
Yes
You
No
No
Yes
No
Search (Alt+Q)
Nu
Y
t
+
Qualified Driver
Yes
Yes
No
The
No
Nu
Yes
Yer
No
BINI
Yes
No
No
No
No
No
Yes
Nu
No
No
No
www
No
No
Yes
Yes
No
NC
Nu
4
Ye
Ne
Yes
General
$
Yes
Yes
You
Yes
No
Yes
۲۰۰
No
Yes
K
Leadership Training - Mentor
B
Yes
Yes
No
Yes
Yes
Var
Yes
Yes
Yes
Yes
Yes
Yes
Yes
No
Yes
Yes
No
Yes
Var
Yes
Yes
Nu
Ya
%98908
A
Number
Yes
Yes
Yes
No
Yes
Yes
No
Yes
۲۰۰
S
Yes
No
No
You
Yes
VI
Yes
Yes
No
Yey
No
No
T
No:
Yes
Yes
No
۲۰۰۰
No
Var
Yes
No
Yes
Is
Conditional Format as Cell
Table Styles
Formatting
N
Officer Qualified Column-
Yes
Elected
Llected
Yes
Elected
Yes
Yes
No
Clected
Na
Yes
No
Yes
Yes
Yes
YES
Elected
Yos
Na
Elected
Elected
NI:
Ni
Elected
Elected
NO
Yes
Declen
Yes
No
Elected
Academic Pivutlable All Groups All Groups Pivot...
Styles
+
2
2
1
2
1
2
2
1
2
1
2
1
1
1
2
2
2
1
1
1
1
1
2
2
1
2
1
2
1
2
0
EX
DE
Insert Delete Format
24
P
Student ID
Student Name
Cell:
Elected Students
All Students
Postsecondary Years
Base Rate
G62918
Kay Colbert
Σ
30
0
JEFFREY WANG
15
AutoSum v
Fill
Clear
Total Students Average Post-Secondary Years
JW
Editing
27
Sort & Find &
Filter Select "
PComments
1
15.25
15.75
D
EN
Analyze
Data
Analysis
+
T
5
15.5
11
Share
8
17.5
x](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2Fb7b9bc12-9bec-475d-bc99-e13d2a9b76e2%2F7a76ae1f-b0bf-4b76-8eab-b0939dfe0f64%2F3zogtx9e_processed.jpeg&w=3840&q=75)
Transcribed Image Text:x
File
D
e
H
AutoSave off
Undo
08
Home
8W20999
100RR20
TW75774
71 25220
2004361
238757
68170
76M89375
5963900
Youth
'R CR2505
YASK
20160811
21 046785
22 075/81
23 VT3590
24186247
Paste
1 Student ID - Name
Name
2 G62018
Kay Colbert
3 149134
4W99035
5 V42056
G
159828
7 F72411
25 90060
20
A
PUNAN
27 U68627
78 Y88831
29 P23373
30 H59454
35
34
3t
21 ANNAR
[32]
36
SY
20
39
401
42
Clipboard
Insert
4
X
G
B
Michael Cracies
Brandon Miles
Michael Alvarez
vix x ✓ fx
B
les Smith
Retty Garza
Leroy Pirele
Waren Stewart
>
Stacy Wiggins
Dilly Hald
Draw
Margaret Crur
Chester Kuc
Chaugen Littell
Florence Miller
Kimberly Gerace
Romar Goble
Jucelyn Allen
Ron Marse
Roberta Tri
NP EX19 /aJeffreyWang 2
Calibri
BI IU--
Age
24
25
mes Rusnak
Suranne Lawrence
Shannorturner
Emory Littin
wana Li
Florella Cauthen
Beverly Herry
Ly Russell
A Sifford
Stephanie Papa
Wallace Rivel
21
22
19
24
Page Layout
Post-Secondary Years
18
18
24
21
23
18
19
21
20
22
22
20
21
19
17
24
18
25
21
18
23
10
24
14
25
D
Documentation
Font
Formulas
a
6
7
2
Base Rate
3
4
2
6
10
11
6
3
5
0
1
3
B
4
4
A
3
1
1
11
5
6
0
5
1
4
3
7
→
A A
A 二三四五
16.50
10.50
15.75
15.75
15.75
-50
26.50
17.50
++
15.00
16.50
13.35
16 50
Data
C
G
Class Finance Certified
3022 Yes
15.00
15:25
15.75
17.50
15.75
15.73
15.75
==
2023 Tes
2022 Yes
2012 Yes
2004 No
2025 Y
2022 Yes
2025 No
2025 Yo
2022 No
2650
13.25
17.50
15.25
16.30
Review
2023
2004 No
==
2020 Y
2025 Yes
2021 Yas
15.15
35.75
13.00
16.30
16.50 20122 YOU
15:00
2025 Nu
2023 Y
2025 Yes
2023 Yes
2025 Yes
2022 Yes
2022 Y
2025 No
21122 Yes
2025 Ves
2014 No
2025 Yes
2022 No
2009
28 Yes
View Help
Alignment
Grad Student
Yes
Yes
No
No
No
Yes
Yes
Na
Yes
Nat
No
No
KA
No
Na
Yes
NO
No
No
Nu
No
No
No
Yory
Yer
No
No
No
Yata
No
Yx
You
1
ab Wrap Text
Student Representatives Academic Groups
Merge & Center
Flected
No
Yes
Yes
No
Yes
No
No
No
Yer
No
No
Nu
No
Na
No
No
Yes,
No
No
Ye
Yes
No
Yes
You
No
No
Yes
No
Search (Alt+Q)
Nu
Y
t
+
Qualified Driver
Yes
Yes
No
The
No
Nu
Yes
Yer
No
BINI
Yes
No
No
No
No
No
Yes
Nu
No
No
No
www
No
No
Yes
Yes
No
NC
Nu
4
Ye
Ne
Yes
General
$
Yes
Yes
You
Yes
No
Yes
۲۰۰
No
Yes
K
Leadership Training - Mentor
B
Yes
Yes
No
Yes
Yes
Var
Yes
Yes
Yes
Yes
Yes
Yes
Yes
No
Yes
Yes
No
Yes
Var
Yes
Yes
Nu
Ya
%98908
A
Number
Yes
Yes
Yes
No
Yes
Yes
No
Yes
۲۰۰
S
Yes
No
No
You
Yes
VI
Yes
Yes
No
Yey
No
No
T
No:
Yes
Yes
No
۲۰۰۰
No
Var
Yes
No
Yes
Is
Conditional Format as Cell
Table Styles
Formatting
N
Officer Qualified Column-
Yes
Elected
Llected
Yes
Elected
Yes
Yes
No
Clected
Na
Yes
No
Yes
Yes
Yes
YES
Elected
Yos
Na
Elected
Elected
NI:
Ni
Elected
Elected
NO
Yes
Declen
Yes
No
Elected
Academic Pivutlable All Groups All Groups Pivot...
Styles
+
2
2
1
2
1
2
2
1
2
1
2
1
1
1
2
2
2
1
1
1
1
1
2
2
1
2
1
2
1
2
0
EX
DE
Insert Delete Format
24
P
Student ID
Student Name
Cell:
Elected Students
All Students
Postsecondary Years
Base Rate
G62918
Kay Colbert
Σ
30
0
JEFFREY WANG
15
AutoSum v
Fill
Clear
Total Students Average Post-Secondary Years
JW
Editing
27
Sort & Find &
Filter Select "
PComments
1
15.25
15.75
D
EN
Analyze
Data
Analysis
+
T
5
15.5
11
Share
8
17.5
x
Transcribed Image Text:Review View Help
File Home Insert Drawi Design Layout References Mailings
PROTECTED VIEW Be careful-files from the Internet car contain viruses. Unless you need to edit, it's safer to stay in Protected View.
8.
9.
Enable Editing
Lael wants a quick way to look up students by their Student ID.
In cell Q3, nest the existing VLOOKUP function in an IFERROR function. If the VLOOKUP
function returns an error result, the text Invalid Student ID should display.
11.
Lael wants to determine several totals and averages for active students.
In cell Q8, enter a formula using the COUNTIF function and structured references to
count the number of students who have been elected to offices in student organizations.
10. In cell R8, enter a formula using the AVERAGEIF function and structured references to
determine the average number of post-secondary years for students who have been
elected.
In cell R9, enter a formula using the AVERAGE function and structured references to
determine the average number of years of post-secondary education of all students as
shown in the Post-Secondary Years column.
Comments
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 2 images
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.Recommended textbooks for you
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education