Instructions$\_$NP$\_$EX$19\_$EOM

earch in Documen

Insert

Design

Layout

References

Mailings

Review

View

Century Gothic

$22$

$A=$

$A=$

Af:

A$2$

B

I

abe

$x_2$

$x^2$

$A+$

A$.$

At

II

Jpdate To keep up$-$to$-$date with security updates, fixes, and improvernents, cho...

$7.$ Apply chart style $9$ to the stacked column chart you just created. Format the vertical axis to use a maximum value of $8000,$ change Display units to Thousands but don't show the units on the chart, and show $0$ decimal places in the axls labels.

New Perspectives Excel $2019|$ Module $4$: End of Module Project $1$

$8.$ Create a $3-$D Clustered Column chart based on the range A$6$:F$17.$ Resize and reposition the chart so that the upper$-$left corner Is located within cell H$32$ and the lower$-$right corner is located within cell Q$52.$ Remove the $2018,2019,$ and $2020$ series from the legend and chart area.

$9.$ Enter $2017$ and $2021$ Revenue Comparison by Product as the chart title and then format the chart title as $16$ point bold text. Enter Total revenue $($thousands$)$ as the vertical axis title.

$10.$ Change the background color of the plot area to White, Background $1$ and then change th $1$ toackground color of the chart area to Green, Accent $6,$ Lighter $80\%(10$th column, $2$nd row in the Theme Colors palette$).$

Your workbook should look like the final Figures on the following pages. Save your changes, close the workbook, and then exit Excel. Follow the directions on the SAM website to submit your completed project.