ASSIGNMENTS

LIBRARY

GRADES

Omole

$7.$ 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.$

$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.