2 In merged cells D11-E11, select the data type of "Equipment ID". 3\ 3 In merged cells D12-E12, select the data type of "sales for each month. 3\ 4 In merged cells D13-E13, select the data type of "Equipment". 3\ 5 In cells O3 through O8, find the total sales for each equipment.\ \ \ Hint: Highlight the range C3:N8 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.\ \ \ \ \ 7\ 6 In cells C9 through N9, find the total sales for each month. In cell O9, find the total sales for the year.\ \ \ Hint: Use the sum shortcut; click on cell C9 and then on your keyboard press ALT then press =. \ \ \ \ \ 6\ 7 In cells P3 through P9, insert Sparklines.\ \ \ Hint: Click on cell P3, go to Insert Sparklines Line. Use the data range C3:N3.\ \ \ \ \ 7\