g$.$ Bold cells B$3$:E$3.$

h$.$ Apply the Accounting Number Format with $0$ digits after the decimal to cells B$4$:E$6.$

i$.$ AutoFit columns A:E$.$

$8.$ Calculate total sales for each of the truck locations.

a$.$ Enter the word Total in cell A$7.$

b$.$ Enter a SUM function in cell B$7$ to calculate the total of cells B$4$:B$6.$

c$.$ Use AutoFill to copy the formula to cells C$7$:E$7.$

d$.$ Apply the Total cell style to cells A$7$:E$7.$

$9.$ Insert a pie chart $(2-$D Pie$)$ to show the Old Bay sales for the month by location. Each piece of the pie should represent the Old Bay sales for a single location.

Note: You must complete this step correctly in order to receive points for completing the next step. Check your work carefully.

$10.$ Modify the pie chart as follows:

a$.$ Apply the Layout $6$ Quick Layout.

b$.$ Move the chart so it appears below the sales data.

$11.$ Insert a clustered column chart $(2-$D Column$)$ to show the sales for each type of popcorn for each location. Do not include the totals.

Note: You must complete this step correctly in order to receive points for completing the next step. Check your work carefully.

$12.$ Modify the column chart as follows:

a$.$ If necessary, modify the chart so each location is represented by a data series and the popcorn types are listed along the $x$ axis.

b$.$ Change the chart title to: July Sales by Popcorn Type