strated Excel $2099|$ Module $4$: SAM Project $1$b

$5.$ Move the chart legend to the Left position to provide more room for the data.

$6.$ Grace can see that Quarter $2$ was the most profitable quarter of the year at $29\%.$

Explode the largest slice of the pie $($representing Quarter $2)$ by $10\%.$

$7.$ Go to the New Services worksheet. The clustered column chart in this worksheet shows how the Oakland revenue has changed over four quarters.

Resize and reposition the clustered column chart so that its upper$-$left corner is within cell $H3$ and its lower$-$right corner is within cell N$17.$

$8.$ Identify the purpose of the clustered column chart by entering Quarterly Revenue as the chart title.

$9.$ Change the chart colors to Monochromatic Palette $2(2$nd in the Monochromatic palette in the Change Colors menu$)$ to coordinate with the other colors in the works

$10.$ Change the Accent $2,$ Lighter $40\%(6$th column, $4$th row in the Theme Colors palette$)$ to contrast with the other data series.

$11.$ Apply the Accounting number format to the range $B5$:$F7,$ and decrease the number of decimal places shown to zero to change the format of the values in the vertical axis of the clustered column chart.

$12.$ Grace wants to create a chart that tracks the changes in the profit amounts from one quarter to another. Create a new chart as follows:

a$.$ Create a Line with Markers chart based on the range B$20$:E$21.$

b$.$ Enter Quarterly Profit as the chart title.

c$.$ Resize and reposition the chart so that its upper$-$left corner is within cell $H19$ and its lower$-$right corner is within cell N$32.$

our workbook should look like the Final Figures on the following pages. Save your changes, lose the workbook, and then exit Excel. Follow the directions on the SAM website to submit your