Use a cell reference or a single formula where appropriate in order to receive full credit. Do not copy and paste values or type values, as you will not receive full credit for your answers.

Start Excel. Download and open the workbook named:

Describing Data Graphically and Numerically Start

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

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

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

In cells $O3$ through $08,$ find the total sales for each equipment.

Hint: Highlight the range C$3$:N$8$ and click the Quick Analysis Button that appears on the lower right corner then click on the totals tab and use the second Sum function.