Use a cell reference or a single formula where appropriate in order to receive full credit. Do not copy

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

Qualitative$-$Nominal

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

$6.$ In cells C$9$ through N$9$ in the table above, find the total sales for each month. In cell O$9$ in the table above, find the total sales for the year.

$7.$ In cells P$3$ through P$9$ 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.$