1. Group the U.S., Canada, and Mexico worksheets.
2. In cell F5, insert a formula using the SUM function that totals the Mini sales amounts for Quarters 14 (range B5:E5).
3. Fill the range F6:F7 with the formula in cell F5 to display the totals for the other types of portable speakers.
4. Ungroup the worksheets and then check to confirm that all three worksheets reflect the changes you made in this step.
5. Create a defined name for the Waterproof sales amounts (range B7:E7) using Waterproof_Total as the name.
6. In cell F5, enter a formula using the SUM function to display the total of the sales amounts in the Mini_Total range.
7. In cell F6, enter a formula using the SUM function to display the total of the sales amounts in the Voice_Activated_Total range.
8. In cell F7, enter a formula using the SUM function to display the total of the sales amounts in the Waterproof_Total range.

   1. type	Q1	Q2	Q3	Q4	Total	2020 Total
      Mini
      voice- acticated
      waterproof
      Total

      The Type cell is located in cell A4.