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:9.
Ungroup the worksheets and then check to confirm that the formatting and formulas from Steps 6-8 are present in all three worksheets.
