excel help in question 12, 13, 14 module 5 a
- Create names from the range A7:E9 using the values shown in the left column.
- Apply 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.
- Change the defined name to Totals_2021 for the range F6:F9.
mentalmavens asked a year ago
Select range B7 through E7. Right click and then select "Define name..." from context menu. The required name should appear in Name field. Just hit OK. Do the same for B8 through E8 and then B9 through E9.
Click B10 and edit the fomala to
=SUM(Q1_Sales). You can do same for C10, D10, and E10.Select F6 through F9, right cick and select "Define name...". Enter Totals_2021 in name field.