QUESTION :-In N14: 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 was sold in 2014 by sales rep Rashid, Ming, John or Allison insert the Sales Price, otherwise the cell should be blank. Copy the function down to the other cells in the column.

In cell N13 use the appropriate function to calculate the total from the results. Format comma style, 0 decimal.

AutoSave OH QUIZ 7 VEHICLE FILE Search (Alt+a) A Mohammed Ayaan Moazzambussen Shaikh MA File Home Insert Page Layout Formulas Data Review View Help Comments Share - Arial Narrow 12 Autosum = = = A 9 Wrap Text II 2? O Paste D BIU Analyze A Merge Center Insert Dalche Format $ %) Conditional Format as Cell Formatting Table Styles Styles Sort Find Filter Select Clear Unda Cupboard Font 5 Alignmen Number Cells Editing Analysis M14 G H J 1 M S T V w AA BB Model year 1 2 3 4 5 6 7 7 8 9 10 11 TC TY VG VJ Vehicle type Toyola Corolla Toyota Camry VW Golf VW Jetta 11 12 13 14 15 16 2011 2012 2013 2014 2015 2016 N N 0 p R Vehicle Information Number (VIN) Breakdown CC Engine DD Colour G1 Gas 1800 CC 20 Red G2 Gas 2500 CC 21 Metallic Red D2 Diesel 2000 CC 22 White 23 Metallic White 24 Blue 25 Metallic Blue EE JP ON GR MX Assembly Plant Toyola Cily Cambridge Dusseldorf Puebla Dealer T1 T2 V1 V2 Name Weslem Toyola Highland Toyota City Volkswagen Northern Volkswagen 12 7 8 9 9 10 11 12 1. 5,019,437 2 2,203,145 13 14 15 3 4 5 6 1,470,372 932,593 746,750 3,485,383 18837 18837 25021 30467 25036 25311 25,067 27,768 22,761 25,311 16 17 22781 18 25,190 19 20 21 22 23 18417 27477 22013 Edit Sheet1 Accessibility: Good to go 22C Cloudy H ENG US Sri D) 12:57 AM 2022-04-03