a. Open e04_exam_chap_data and save as e04_exam_chap_LastFirst.

b. Display the All Sales worksheet and freeze row 7 so that when a user scrolls down, they will still be able to see the titles.

c. Set the Print Area to the range F7:I32 using absolute field references.

Profit Analysis You will provide an analysis profit of cars sold and if each car is meeting the 15% profit set as the standard.

d. Display the Profit worksheet and create a table named Profit for the range A7:I32.

e. Set the table style to Table Style Medium 1 and turn off the Filter Button.

f. Delete the Days on Lot column and add a new column after Profit named Profit %. In cell I8, use a structured reference to create the formula to calculate the percent of profit over the purchase price (Profit/Purchase Price).

g. Add data bars with a style of Gradient Fill Light Blue Data Bar to the Profit column.

h. Add a Total Row for columns Purchase Price, Sale Price, and Profit.

i. Set the conditional formatting for the Profit % column so that any value that is less than 15% displays with Light Red Fill with Dark Red Text.

j. Create a custom sort by Vehicle Type using a custom list of Car, Truck, SUV, Van.

Top 10

You will find the top 10 transactions by gross profit to see if there are any trends in car type, body style or vehicle year

k. Display the Top 10 worksheet and create a table named Top for the range A7: I32.

l. Apply a filter to the Profit column to display only the Top 10 items.

m. Save and close the file. Based on your instructor's directions, submit e04_exam_chap_LastFirst.