1. - To the right of the large table, Lael has made a quick way to look up a student's name by their Student ID number. To make sure that the cell always displays a meaningful message, nest the existing function in another function to display Invalid Student ID if the VLOOKUP function returns an error result.
2. Lael wants to determine several totals and averages for active students. In the appropriate cell, enter a function and structured references to count the total number of students if they have been elected to offices in student organizations.

moondmm-a-wms 1o 11 12 13 1-1 15 1s 1? 113 19 2o 21 22 23 2-1 25 2s 2? 23 213 an 31 32 33 3-1 35 as 3? 33 33 10 11 12 13 1-1 15 1s 1? 113 13 an 51 52 53 G Finance Berti: Glad Stud: Electi Qualified Elli: Leadership Train Mental: Ullicer Uualil: Co: Yes Yes No Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes No Yes No Yes Yes Yes Yes No No No Yes Yes Yes No No Yes No No No Yes Yes Yes No Yes Yes Yes Yes Yes Yes No Yes Yes Yes Yes No No No No No No Yes Yes Yes Yes Yes Yes Yes Yes No No No No No Yes Yes Yes No No Yes Yes Yes Yes No No No No No No Yes Yes No No No No No Yes Yes No No No Yes Yes Yes Yes Yes No Yes Yes Yes Yes Yes No No No Yes Yes Yes Yes No Yes No Yes Yes Yes Yes No No No Yes No Yes No No No No No Yes Yes Yes No Yes No No No Yes Yes No Yes Yes Yes No Yes No No No No No No Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes No No No No No No Yes Yes No No Yes Yes Yes Yes Yes No Yes No No No Yes Yes Yes No Yes Yes Yes Yes No No No No No No Yes Yes Yes Yes Yes Yes Yes Yes Student Name Elected Students Postsecandary Year Base Rate