Go to the U.S. worksheet. Benicio has received annual sales worksheets from the main offices in the 3 countries where DIG sells products: the United States, Canada, & Mexico.

Question

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.

davidmacago · Accepted Answer

a. Hold ctrl key select U.S., Cananda, and Mexico worksheets from bottom tab. If you have dark theme, the background color of those worksheets' name should change to white color.
b. Click on cell F5 of the U.S. worksheet. (Don't do anything. Let all the worksheets be selected.) Enter =sum(b5:e5)
c. Move your cursor to the corner of F5 cell, + sign will appear and drag it to the down side upto F7
d. Right click on any selected worksheet in the buttom tab. Click "Ungroup sheets" and the white background should be disappeared from other sheets.
Here is the video explanation for this module:
https://youtu.be/N67oCBHNlsY?t=42

Go to the U.S. worksheet. Benicio has received annual sales worksheets from the main offices in the 3 countries where DIG sells products: the United States, Canada, & Mexico.

Answers

Post your answer

Recommended Books