Multiple Attempts not allowed. This test can only be taken once. Force Completion This test can be saved and resumed later. Your answers are saved automatically. Question Completion Status: Moving to another question will save this response. Question 4 Question 4 of 15 2 points Save Answer In 114 Use the VIN # code breakdown provided at the top of the worksheet as a guide to create appropriate nested functions to complete the following If the vehicle model year is 2011 insert the Sales Price, otherwise the cell should be blank Copy the function down to the other cells in the column In cell 113 use the appropriate function to calculate the total from the results Format comma style, O decimal Moving to another question will save this response ws/assessment/take/takejsp?course assessment id 459625,18kcourse id 664946 18content id 13541175,1&question,num 4x0&toggle state-qShowstepnull 0 a e 4 O G 81 Question 4 of 15 ING 10 900 LIK 132 PM 7/26/2022 Autosave on H QUIZ 7 VEHICLE FILE Search (Alt+ Home Insert Page Layout Data Formulas Review View Help X Arial Namow 12 AA 8 General - Paste BIU- A Clobod 5 Fant Alignment 312 xvf D Number " M Vehicle typ D Model yeall 2011 VIN code Sales Price 2013 9231 776 28067 2501 2004 V HEATHS 342 27.11 30004 20 201 500 2250) 2014 30 201901 25200 104 504 20077 22.013] 500 2945 223931 504 FIRST 309 504 660771 3051 25.82 2007 510 20081 504 2023 950 24954 200 1572] 501 913 2517 Sheet! Ready Acornibly Good Raff and an 40 2 + 201 2014: 201 201 O S Conditional Format as Cell Formatting Table Styles Styles 6 R 13 Mohammed Sabit Ennan Comments Sort & Find & Delete Format - Fiber Cel Editing Select- Analyt Date Analysis 1 15 P ENG LIN Comments Share Sort & Find & Filter-Select- Analyse Data Editing Analysis Insert Delete 3- Conditional Format as Cell Formatting Table Styles Format Alignment 5 Number 5 Styles Cells ge Layout Formulas Data Review View Help al Nenow -12 A A E = P 23 General M P 9 T U AA AS AA Vehicle type BB Model year CO ota Corola 2011 Engine IGT 100000 ation h mber (VINI fica akdown DO Colour EE UPT Assembly Plant Toysty Dealer TY 205 Name Weenlase nighandgeta Sales Hep Na 601 602 13 2013 02 Desel 2000 CA Dualded 503 wwen www.J 14 2014 Puebla 504 S 2015 910 201 311 Mrg 813 IN-E-A- Fort 2 16 a a e " 12 S 12 D 21 + ENG UK 90f 15PM 7/26/2022