7. With the Chicago, St. Louis, and Minneapolis worksheets still grouped, update the worksheet as follows:
a. In cell A8, change the text "Marble" to read:
Stone
b. In cell A9, change the text "Total" to read:
Total sales
Do not ungroup the worksheets.
8. With the Chicago, St. Louis, and Minneapolis worksheets still grouped, create a formula as follows:
a. Enter a formula in cell B9 using the SUM function that totals the sales for Q1.
b. Copy the formula to the range C9:E9.
Ungroup the worksheets and then check to confirm that the formatting and formulas from Steps 6-8 are present in all three worksheets.
9. Min Jee wants to create a copy of the formatted Minneapolis worksheet to use for sales data from the upcoming Madison art fair. Create a copy of the Minneapolis worksheet between the Minneapolis worksheet and the Combined Sales worksheet, and then update the worksheet as follows:
a. Change the worksheet name to Madison for the copied worksheet.
b. Edit the text to read Madison 2021 in the merged range A2:F2.
c. Clear the contents of the range B5:E8.