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 6 Question 6 of 15 Next Question 2 points Save Answer In K14 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 is sold by Northern Volkswagen and is assembled in Puebla insert the number 1, otherwise the cell should be blank Copy the function down to the other cells in the column. In cell K13 use the appropriate function to count the number of results Format comma style, O decimal Moving to another question will save this response. C 81 D Question 6 of 15 ENG UK 133 PM 7/26/2022 8 H QUIZ 7 VEHICLE FLE Search (Alt+Q) Insert Page Layout Formulas Data Review View Help Mohammed Sabit Eman Q Comments Arial Narrow 12 AA # General Delete- - BIU- A S % A Conditional Format as Cell Formatting Table Styles- For Alignment Number Format Cells - Fiber Sort & Find & Select- Analyse Data Eding Analys Autsave Home X Unds F12 Chipboard A B D G AA Vehicle pe BB Model yea 20 2012 801 ww N 2014 P 2015 2016 2 Vode MSRP 504 99735 25.06 2000 913 27383 30467 014 25.0% 2530 22382 501 25.05 22.569 900 1500 304 1647 504 7477 22013 12 503 27.041 223293 20 504 21621 2001 2017 21044 2005 504 866 5077 MOKE 200 503 257791 WORZNO VI 510 SOR 2674999 20.332 201 310 TURS ELECTRON 20 922 505 515 22. Sheet! Brany Arty Good to ge 7V7 Ranaff and on OLD " 1441 800 10 197 C P a OD Colo Assembly I E C G 9 A T A ENG 15 PM UK 7/21/2022 age Layout Formulas Data Review View Help al Nanow 12 A A == Insert P General Delete 3- $ % Conditional Format as Cell Formatting Table Styles- Format Font Alignment Number Styles Celh H AA Vehicle type Tota Corola TY Tegra Can WW 1 ST 2 Comments Share KOH Sort & Find & Filter Select Analyze Data Editing Analysis M N Vehicle Infe P ation i R T U 2 AA AS Ad the skdown BB Model yea Engine DO Colou EE Assembly Plant Dealer 2011 Cat 500.00 Car 2500CC Hed P Toyota Cey Metalic Bed ON Name Weven Toura Highand Toyota Sales Rep Na 609 502 23 2013 IGR Dueldo CayVolvagen 503 MX 2014 Pabla Nomen Velvagen 504 330 R 2015 211 2016 513 Mar 2 5 6 9 10 11 12 go Q a 121 A + ENG 15 PM UK 7/26/20