Homework Help is Here – Start Your Trial Now!
Engineering
Computer Science
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
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
See similar textbooks
icon
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
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
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
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
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 2 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Knowledge Booster
Types of trees
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
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)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education
SEE MORE TEXTBOOKS