Homework Help is Here – Start Your Trial Now!
Engineering
Computer Science
8. 9. 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. 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.

8. 9. 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. 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.

COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
1st Edition
ISBN:9780357392676
Author:FREUND, Steven
Publisher:FREUND, Steven
Chapter8: Working With Trendlines, Pivottables, Pivotcharts, And Slicers
Section: Chapter Questions
Problem 9EYW
See similar textbooks
icon
Related questions
Question
Need help to do those questions of Excel and give the right formulas as soon as possible.
8 Instructions_NP_EX19_7a Protected View Saved to this PC ✓ File Home Insert Draw Design Layout References Mailings Review View Help PROTECTED VIEW Be careful-files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View, 8. W AutoSave 9. O Search (Alt+Q) 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. 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. 11. 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. 12. CENGAGE New Perspectives Excel 2019 | Module 7: SAM Project la Switch to the Academic Groups worksheet. In cell A14, use the INDEX function and structured references to display the value in the first row and first column of the AcademicGroups table. JEFFR F
Transcribed Image Text:8 Instructions_NP_EX19_7a Protected View Saved to this PC ✓ File Home Insert Draw Design Layout References Mailings Review View Help PROTECTED VIEW Be careful-files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View, 8. W AutoSave 9. O Search (Alt+Q) 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. 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. 11. 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. 12. CENGAGE New Perspectives Excel 2019 | Module 7: SAM Project la Switch to the Academic Groups worksheet. In cell A14, use the INDEX function and structured references to display the value in the first row and first column of the AcademicGroups table. JEFFR F
File Home Insert Draw Page Layout 5. X A- e Undo L2 1 Student ID 2 G62918 349234 4 W99055 5 V42056 ST59826 3 172412 2 W20999 90186/0 10 W/5774 11 N25270 12 094861 13CA7578 14 868170 T5 Muy575 1069900 17 06030 TC82505 1079858 20160811 153 134 3.6 37 39 Paste 21 456783 22 075281 20 V/506 24 L86917 25 W90060 C 26 P406 27 U88627 20 YKK831 29 P83178 30853454 31 A60088 32 40 41 MA Clipboard VIX Name Kay Colbert К Michael Gover Brandon Miles Michael Alvare Гу Ready Ida Smith Betty Garce Leroy Pukle Warren Stewart Stacy Wiggins Uilly Herald amm Calibri Margaret Cruz Chester Kees Claudette litteil Flor Miller B Kimberly Gera Roman Gabilo Jocelyn Allen Ron Morse Roberta Ervin ames Rusnak Suzanne Lawrence Shannontiner Imry Little Laura Li Horetta Cauthen Deverly Berry Stephanie Paps Wallace Rivera Lry Russell Aron Sifford IU. 24 25 21 22 19 24 .. 28 18 24 21 23 18 10 21 26 22 22 fx =IF(AND(C2>= 21, D2 >= 3), "Yes", "No") 0 F Age Post-Secondary Years Rase Rate Class Finance Certified-Grad Student - h Grad Student 2022 Yes 16.50 1650 2025 Yes 15.75 15.75 20 21 12 24 18 25 211 18 3.3 14 2 29 19 25 Documentation 11 Font Accessibility: Investigate Formulas Data Review View G 6 7 3 4 2 6 10 0 v b R 5 U 7 1 3 8 4 A 2 3 1 2 0 5 6 0 5 1 9 1 A A A 7 15.75 16.50 17.50 15.00 16.50 25.75 15.50 15.00 15:25 15.75 17.900 15.75 13.75 15.75 5 13./4 15.25 15.75 15.00 16.50 16 50 == 2012 Yes 2023 Yes 2024 No 2025 Yes 2022 Yus 2076 No 2025 Yea 15.00 16.50 15.25 17.50 15.25 16. 2022 No 2028 Yes 2024 No 2020 Y 2003 Yes 2023 Yes 2014 Yes 1022 Yes 2009 Yes 2025 No 222 Yes Student Representatives 2025 Y 2024 No XOR Yes 2022 Yus 2025 No 2023 Yes 20028 Yes 2005 Yes 2022 Nu 2023 三国 G Alignment Yes Yes No No Ni Yes Yes No Y No No No No No Yes No No Now No NO No No Yes Yes Help No No No No You N Tes ab Wrap Text H O Table Design Merge Center Elected No Yes Yes No ۲۰۰ No No No You No No Na No No No Nu Yes No No Yes You N Yes Yes 14 No Yes No No Yes Qualified Driver Yes Yes No No No Y Yes No Yes No 7 No No No No Yes Ni No Nu No No Yo No Yes Yes Nu Na No Yes No Yes General $ % 9 508 8 K Leadership Training Ycs Yes Yes Ni> Yes No Yus Yes Yes No Yes Yes Yes Yes www YA Yes Yes Y Yes No ... Yes No Yes Yes Yes No M Number ۲۰۰ L Mentor Yes Yes L You No Yes Yes No Yes YPS Yes Nex P No Yes Yes Yo Yer No Y. No No Ni Y Yes No Yes NO Tak NI Yer F # Conditional Format as Cell Formatting Table Styles Styles M Officer Qualified Yes Llected Elected Yes Elected Yes ۷۰۰۰ MA No Electedl Ni Yes Nu Yes ۷۰۰۰ Yes Yes Clected Yes NI: Clert Elected Nu Fested Clerted No Yes Elected Yes No Elected Academic Groups | Academic PivotTable | All Groups All Groups Pivot... 1 N Columa1 2 2 1 2 1 2 2 1 2 1 2 1 1 1 2 2 1 1 1 2 2 2 1 2 0 X Insert Delete Format P Student ID Student Name Elected Students All Students Cells Pastsecondary Years Base Hate C62918 Kay Colbert Σ Autosum Fill- Clear Editing R F Total Students Average Post-Secondary Years Y Sort & Find & Filter Select a G E 15.25 Comments 4 S 2 15.75 (D) MM Analyze Data Analysis T 5 16.5 U 8 17.5 Share 67% 1:16 PM 11/30/2022
Transcribed Image Text:File Home Insert Draw Page Layout 5. X A- e Undo L2 1 Student ID 2 G62918 349234 4 W99055 5 V42056 ST59826 3 172412 2 W20999 90186/0 10 W/5774 11 N25270 12 094861 13CA7578 14 868170 T5 Muy575 1069900 17 06030 TC82505 1079858 20160811 153 134 3.6 37 39 Paste 21 456783 22 075281 20 V/506 24 L86917 25 W90060 C 26 P406 27 U88627 20 YKK831 29 P83178 30853454 31 A60088 32 40 41 MA Clipboard VIX Name Kay Colbert К Michael Gover Brandon Miles Michael Alvare Гу Ready Ida Smith Betty Garce Leroy Pukle Warren Stewart Stacy Wiggins Uilly Herald amm Calibri Margaret Cruz Chester Kees Claudette litteil Flor Miller B Kimberly Gera Roman Gabilo Jocelyn Allen Ron Morse Roberta Ervin ames Rusnak Suzanne Lawrence Shannontiner Imry Little Laura Li Horetta Cauthen Deverly Berry Stephanie Paps Wallace Rivera Lry Russell Aron Sifford IU. 24 25 21 22 19 24 .. 28 18 24 21 23 18 10 21 26 22 22 fx =IF(AND(C2>= 21, D2 >= 3), "Yes", "No") 0 F Age Post-Secondary Years Rase Rate Class Finance Certified-Grad Student - h Grad Student 2022 Yes 16.50 1650 2025 Yes 15.75 15.75 20 21 12 24 18 25 211 18 3.3 14 2 29 19 25 Documentation 11 Font Accessibility: Investigate Formulas Data Review View G 6 7 3 4 2 6 10 0 v b R 5 U 7 1 3 8 4 A 2 3 1 2 0 5 6 0 5 1 9 1 A A A 7 15.75 16.50 17.50 15.00 16.50 25.75 15.50 15.00 15:25 15.75 17.900 15.75 13.75 15.75 5 13./4 15.25 15.75 15.00 16.50 16 50 == 2012 Yes 2023 Yes 2024 No 2025 Yes 2022 Yus 2076 No 2025 Yea 15.00 16.50 15.25 17.50 15.25 16. 2022 No 2028 Yes 2024 No 2020 Y 2003 Yes 2023 Yes 2014 Yes 1022 Yes 2009 Yes 2025 No 222 Yes Student Representatives 2025 Y 2024 No XOR Yes 2022 Yus 2025 No 2023 Yes 20028 Yes 2005 Yes 2022 Nu 2023 三国 G Alignment Yes Yes No No Ni Yes Yes No Y No No No No No Yes No No Now No NO No No Yes Yes Help No No No No You N Tes ab Wrap Text H O Table Design Merge Center Elected No Yes Yes No ۲۰۰ No No No You No No Na No No No Nu Yes No No Yes You N Yes Yes 14 No Yes No No Yes Qualified Driver Yes Yes No No No Y Yes No Yes No 7 No No No No Yes Ni No Nu No No Yo No Yes Yes Nu Na No Yes No Yes General $ % 9 508 8 K Leadership Training Ycs Yes Yes Ni> Yes No Yus Yes Yes No Yes Yes Yes Yes www YA Yes Yes Y Yes No ... Yes No Yes Yes Yes No M Number ۲۰۰ L Mentor Yes Yes L You No Yes Yes No Yes YPS Yes Nex P No Yes Yes Yo Yer No Y. No No Ni Y Yes No Yes NO Tak NI Yer F # Conditional Format as Cell Formatting Table Styles Styles M Officer Qualified Yes Llected Elected Yes Elected Yes ۷۰۰۰ MA No Electedl Ni Yes Nu Yes ۷۰۰۰ Yes Yes Clected Yes NI: Clert Elected Nu Fested Clerted No Yes Elected Yes No Elected Academic Groups | Academic PivotTable | All Groups All Groups Pivot... 1 N Columa1 2 2 1 2 1 2 2 1 2 1 2 1 1 1 2 2 1 1 1 2 2 2 1 2 0 X Insert Delete Format P Student ID Student Name Elected Students All Students Cells Pastsecondary Years Base Hate C62918 Kay Colbert Σ Autosum Fill- Clear Editing R F Total Students Average Post-Secondary Years Y Sort & Find & Filter Select a G E 15.25 Comments 4 S 2 15.75 (D) MM Analyze Data Analysis T 5 16.5 U 8 17.5 Share 67% 1:16 PM 11/30/2022
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 3 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Knowledge Booster
Topological Sort
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.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
Computer Science
ISBN:
9780357392676
Author:
FREUND, Steven
Publisher:
CENGAGE L
New Perspectives on HTML5, CSS3, and JavaScript
New Perspectives on HTML5, CSS3, and JavaScript
Computer Science
ISBN:
9781305503922
Author:
Patrick M. Carey
Publisher:
Cengage Learning
Programming with Microsoft Visual Basic 2017
Programming with Microsoft Visual Basic 2017
Computer Science
ISBN:
9781337102124
Author:
Diane Zak
Publisher:
Cengage Learning
Np Ms Office 365/Excel 2016 I Ntermed
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage
SEE MORE TEXTBOOKS