Download the file $$Training$$ from class website. Copy the data into the fourth sheet of your homework workbook. In cell B$26$ put the $($underlined$)$ heading $$ID Number$,$ and in cell C$26$ put the $($underlined$)$ heading $$quiz $5.$ After the user enters an ID number into cell B$27,$ cell C$27$ should display that student$$s score on quiz $5.($An invalid ID number should not display a score.$)$ Hint: Use the VLOOKUP function. "Training"Employee Training Scores ID Last Name First Name quiz$1$ quiz $2$ quiz$3$ quiz$4$ quiz $516006$ Aaron Noah $998995748116002$ Avila Sophia $818578949116013=$VLOOKUP$($C$2,$$I$$2$:$J$$6,2,$TRUE$)$Home

Insert

Draw

Page Layout Formulas

Comments

Share

$\backslash$table$[[$N$13,xvv,fx,,,,,,,],[,$A$,$B$,$C$,$D$,$E$,F,$G$,$H$,1,],[1,$Employee Training Scores$],[2],[3,$ID$,$Last Name,First Name,Exam $1,$Exam $2,$Exam $3,$Exam $4,$Exam $5,,],[4,16006,$Aaron,Noah,$99,89,95,74,81,,],[5,16002,$Avila,Sophia,$81,85,78,94,91,,$Last Nam$],[6,16013,$Bergeron,Ethan,$70,96,89,77,88,,$Aaron$],[7,16003,$Cooper,Alexander,$74,92,62,91,86,,$Avila$],[8,16008,$Cota,Liam,$88,91,73,82,73,,$Bergero$],[9,16004,$Douglass,Emma,$79,81,94,81,77,,$Cooper$],[10,16015,$Fox,Mia,$74,99,85,71,68,,$Cota$],[11,16011,$Gaffney,Jacob,$90,96,93,96,92,,$Douglas$],[12,16005,$Griffis,Isabella,$94,73,96,82,98,,$Fox$],[13,16007,$Hay,Benjamin,$79,62,81,70,72,,$Gaffney$],[14,16009,$Knowles,Harper,$92,97,96,62,80,,$Griffis$],[15,16019,$Laird,Charlotte,$93,70,72,71,100,,$Hay$],[16,16020,$Loomis,Ava,$67,87,93,84,67,,$Knowles$],[17,16012,$Poe,Saburo,$71,94,84,81,63,,$Laird$],[18,16014,$Saenz,Sachi,$73,92,76,66,60,,$Loomis$],[19,16016,$Ulrich,Zack,$95,82,66,91,73,,$Poe$],[20,16001,$Wing,Batette,$71,92,61,75,83,,$Saenz$],[21,16018,$Wynne,Qadir,$97,67,72,68,65,,$Ulrich$],[22,16017,$Yoo,Lachina,$79,74,82,83,82,,$Wing$],[23,16010,$Zeller,Naida,$82,67,62,76,97,,$Wynne$],[24,,,,,,,,,,$Yoo$],[25,,,,,,,,,,$Zeller$],[26,,,,,,,,,,],[27,,,,,,,,,,],[28,,,,,,,,,,],[29,,,,,,,,,,],[30,,,,,,,,,,],[31,,,,,,,,,,],[32,,,,,,,,,,],[33,,,,,,,,,,],[34,,,,,,,,,,],[35,,,,,,,,,,],[36,,,,,,,,,,]]$