In N14 : Use the VIN # code breakdown provided at the top of the…

Question Answered step-by-step In N14 : Use the VIN # code breakdown provided at the top of the… In N14: Use the VIN # code breakdown provided at the top of the worksheet as a guide to creating 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 the cell, N13 uses the appropriate function to calculate the total from the results.  Image transcription textQUIZ 7 SMS310 STUDENT FILE 2021.xIsx – Ex Damanpreet Singh File Home Insert Page Layout FormulasData Review View Help ? Tell me what you want to do $ Share do Cut EB Copy Arial Narrow – 12 – A”A” ab Wrap Text General Norma Bad Good Neutral EX AutoSum ~ A AY O BO Paste Fill – Fo… Show more… Show more  Business Management Human Resource Management BUSINESS SMS310 Share QuestionEmailCopy link Comments (0)