a. Group the U.S., Canada, and Mexico worksheets. b. In cell F5, insert a formula using the SUM function that totals the Mini sales amounts for Quarters 1-4 (range B5:E5). c. Fill the range F6:F7 with the formula in cell F5 to display the totals for the other types of portable speakers. d. Ungroup the worksheets and then check to confirm that all three worksheets reflect the changes you made in this step. e. Create a defined name for the Waterproof sales amounts (range 07:E7) using Waterproof_Total as the name. f. In cell F5, enter a formula using the SUM function to display the total of the sales amounts in the Mini_Total range. g. In cell F6, enter a formula using the SUM function to display the total of the sales amounts in the Voice_Activated_Total range. h. In cell F7, enter a formula using the SUM function to display the total of the sales amounts in the Waterproof_Total range. 1. Total 2020 Total type Q1 Q2 Q3 Q4 Mini voice-acticated waterproof Total The Type cell is located in cell A4