I need help with 11-14. I have completed question 10 a-e. 10Edra wants to consolidate the data
Fantastic news! We've Found the answer you've been seeking!
Question:
I need help with 11-14. I have completed question 10 a-e.
- 10Edra wants to consolidate the data from each of the regions. Switch to the Consolidated Sales worksheet, then update the worksheet as follows:
- In cell A6, enter a formula without using a function that references cell A6 in the Washington worksheet.
- Copy the formula from cell A6 to the range A7:A9 without copying the formatting.
- In cell B6, enter a formula using the SUM function, 3-D references, and grouped worksheets that totals the values from cell B6 in the Idaho:Washington worksheets.
- Copy the formula from cell B6 to the range B7:B9 without copying the formatting.
- Then copy the formulas and the formatting from the range B6:B9 to the range C6:E9.
- 11Edra started to create named ranges in the worksheet and has asked you to complete the work. Make/create defined name for the range B6:E6 using Walkup as the range name.
- 12Make/Create names from the range A7:E9 using the values shown in the left column.
- 13Apply the defined names Q1_Sales, Q2_Sales, Q3_Sales, and Q4_Sales to the formulas in the range B10:E10 in the Consolidated Sales worksheet.
- 14Change the defined name to Totals_2021 for the range F6:F9. [Mac Hint: Delete the existing defined name "Totals" and add the new defined name.]