AIS

88 o Excel_Final_Practice (1) w ExcelisP BE HD-UNUD EMPTE RUL FUTURE Practice Question City Used Cars sells pro-wancars. The business is managed by the owner - Mein Smith Fim buys cars at auction and sells them at a profit from his car and in Sydney, Australia. Ile employe three sales staff. Jom koeps a record of cars that are sold. He realise that there is a lot of valuable information in these records that could he used to run the business more effectively and has asked for help with setting up a simple spreadsheet model City Used Car Profit worksheet Celer Sale FF wer s . S 2 UNE 24 LAN gan Beton LO HO 18 1 200 13 05 2013 14 I V SIA . 2013 15 O 11 WP SC Be Free Category 1 TI NV 12.30 ER S. S NUT 01 Is 14 21 RE . . II ALAS 11 1 . ST 50 15 140.00 Is MO Refer to the City Used Car Profit worksheet illustrated above, when answering the following questions Question 1 (6 marks) At cells 14 to D16 the Sale Price for cach car sold is displayed. Write the formula to look up the Sale Price for cach car sold from the Vehicle Purchase Price table (A20-C32). D4- D16 Question 2 (4 marks)