solved: – To the right of the large table, Lael has made a quick way to…
– To the right of the large table, Lael has made a quick way to…- 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.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.Image transcription textmoondmm-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 3310 11 12 13 1-1 15 1s 1? 113 13 an 51 52 53 G Finance Berti: Glad Stud: Electi? Qualified Elli: Leadership TrainMental: Ullicer Uualil: Co: Yes Yes No Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes No Yes … Show more… Show more BusinessManagementProject Management BAM 11791531