$1.$ Benicio Cortez is a financial consultant with NewSight Consulting in Denver, Colorado. He is working with DIG Technology, a company that sells five models of portable speakers to consumers in North America. In an Excel workbook, Benicio is analyzing the performance of each speaker model and projecting sales for a new product. He asks for your help in completing the analysis.

Go to the U$.$S$.$ worksheet. Benicio has received annual sales worksheets from the main offices in the three countries where DIG Technology sells products: the United States, Canada, and Mexico. The worksheets for the countries have a similar structure. Complete the worksheets as follows:

a$.$ Group the U$.$S$.,$ Canada, and Mexico worksheets.

b$.$ In cell F$5,$ insert a formula using the SUM function that totals the Mini sales amounts for Quarters $14($range B$5$:E$5).$

c$.$ Fill the range F$6$:F$7$ with the formula in cell F$5$ 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.