Question: Download the file Training from class website. Copy the data into the fourth sheet of your homework workbook. In cell B 2 6 put the

Download the file Training from class website. Copy the data into the fourth sheet of your homework workbook. In cell B26 put the (underlined) heading ID Number, and in cell C26 put the (underlined) heading quiz 5. After the user enters an ID number into cell B27, cell C27 should display that students 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 quiz1 quiz 2 quiz3 quiz4 quiz 516006 Aaron Noah 998995748116002 Avila Sophia 818578949116013=VLOOKUP(C2,$I$2:$J$6,2,TRUE)Home
Insert
Draw
Page Layout Formulas
Comments
Share
\table[[N13,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,,,,,,,,,,]]
 Download the file Training from class website. Copy the data into

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!