8 Apply the Accounting Number Format to the first row of
6.000 sales figures and to the total row. Apply the Comma Style to the remaining sales figures.
9 Select the range that represents the sales figures for the
10.000 three months, including the month names and the product names— do not include any totals in the range. With this data selected, use the Recommended Charts command to insert a Clustered Column chart with the month names displayed on the category axis and the product names displayed in the legend.
10 Move the chart so that its upper left corner is positioned 3.000 in cell A10.
11 Apply Chart Style 5 and Color 3 under Colorful. Modify
13.000 the Chart Layout by applying Layout 1. Change the Chart Title to1st Quarter Oven Steamer Sales.
12 In the range F4: F7, insert Line sparklines that compare 10.000 the monthly data. Do not include the totals. Show the