1. The worksheet Q4 contains a list of model, year, and price for each of a series of cars.

a. Set up a formula to extract the model and year of the car. (3 marks)

b. Set up formulas that enable you to enter the model and year of a car and return its price.

C14 X fx * 14,155.00 A B D E G E 1 2 3 4 4 5 6 7 8 9 Name Blazer 1999 Explorer 1993 Escalade 1995 Highlander 1999 Envoy2001 Navigator 1995 Blazer 1995 Explorer 1998 Escalade 1997 Highlander 1993 Envoy1995 Navigator2001 Name 19,612.00 17,502.00 13,630.00 11,842.00 14,475.00 19,556.00 10,398.00 15,694.00 12,137.00 16,848.00 13,279.00 14,155.00 10 11 12 13 14 15 16 Model Year Value 17 18 19 mo