In B$17,$ enter a function to count the number of White $8\mathrm{.}5$x$11$ Light orders. Use

appropriate cell referencing so you can copy this function down for the rest of the

products.

$6.$ In C$17,$ enter a function to calculate the average profit for the White $8\mathrm{.}5$x$11$ Light

orders. To do this, you cannot use a simple AVERAGE function. You will need to first

determine the total profit for the given product. Then divide this value by the number

of that product sold. Use appropriate cell referencing so you can copy this function

down for the rest of the products. $($If you have calculated this correctly, the value in

C$17$ should be $$29,940\mathrm{.}49.)$

$7.$ Enter the appropriate functions in cells G$15$:G$19$ to calculate the requested measure

as noted in F$15$:F$19.$

$8.$ Go to the Annual Comparison worksheet. Here, you need to display the Average

Profit for each product for $2020-2021$ as calculated above. Cell D$7$ should be equal to

the value of cell C$17$ in the MWPSData worksheet. Once you have done this, copy the

formula in cell D$7$ down for the rest of the products.

$9.$ On the Annual Comparison worksheet, enter a function in cell B$13$ to calculate the

sum for all products in $2018-2019.$ Copy this function across for the other years.

Part $4$: Formatting $$ Enhance the Appearance of the Worksheet

$1.$ On the MWPSData worksheet, merge and center the worksheet headings found in

cells A$1$ and A$2$ across columns A $$ L$.$ Increase the font size of the row $1$ heading to

$18$ pt$.$ Bold this heading. Increase the font size of the row $2$ heading to $16$ pt$.$

$2.$ Replace $$your name$$ in row $2$ with your own name.

$3.$ Format the values in C$6$:C$10,$ C$17$:C$22$ and G$15$:G$20$ to display as Currency with

two $(2)$ decimal places.

$4.$ On the Annual Comparison worksheet, format the values in B$2$:D$8$ to display as

Currency with two $(2)$ decimal places.

MGMT $2080,$ Fall $20233$