Question
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
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\
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started