Total

Use a cell reference or a single formula where appropriate in order to rece

$1-2.$ In merged cells D$11-$E$11,$ select the data type of "Equipment ID$".$

$3.$ In merged cells D$12-$E$12,$ select the data type of "sales for each month"

$4.$ In merged cells D$13-$E$13,$ select the data type of "Equipment".

$5.$ In cells $O3$ through $O8$ in the table above, find the total sales for each equipme $6.$ In cells C$9$ through N$9$ in the table above, find the total sales for each month. above, find the total sales for the year.

$7.$ In cells $P3$ through $P9$ in the table above, insert Sparklines.

$8.$ In merged cells D$17-$E$17,$ is there any trend in the data based on the line in cell P$9?$

$9.$ In cell D$18,$ find the average sales per month in $2017.$

$10.$ In cell D$19,$ find the median sales per month in $2017.$

$11.$ In merged cells D$20-$E$20,$ select the shape of the data based on the answers in cells D$18$ and D$19.$

Instructions Sales Data

Accessibility: Investigate

$-3F$

Mostly cloudy

Search