7. Calculate total sales for each of the truck locations. a. Enter the word Total in cell A7. b. Enter a SUM function in cell B7 to calculate the total of cells B4:B6. C. Use AutoFill to copy the formula to cells C7:E7. d. Apply the Total cell style to cells A7:E7. 8. 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. 9. Modify the pie chart as follows: a. Apply the Layout 6 Quick Layout. b. Move the chart so it appears below the sales data. 10. 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. Hint: You may need to switch the row/column after inserting the chart. Note: You must complete this step correctly in order to receive points for completing the next step. Check your work carefully. 11. 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: September Sales by Popcorn Type C. Apply the Style 7 chart Quick Style. d. Display the chart data labels using the Outside End option. e. If necessary, move the chart so it is next to the pie chart and the top of the charts are aligned. 49 Reset Progr