module 5 1a question number 10

Question

Edra wants to consolidate the data from each of the regions. Switch to the Consolidated Sales worksheet, then update the worksheet as follows:
a.	In cell A6, enter a formula without using a function that references cell A6 in the Washington worksheet.
b.	Copy the formula from cell A6 to the range A7:A9 without copying the formatting.
c.	In cell B6, enter a formula using the SUM function, 3-D references, and grouped worksheets that totals the values from cell B6 in the Idaho:Washington worksheets.
d.	Copy the formula from cell B6 to the range B7:B9 without copying the formatting.
e.	Then copy the formulas and the formatting from the range B6:B9 to the range C6:E9.

rames · Accepted Answer

a.

In cell A6 of the "Consolidated Sales" worksheet, enter the formula ='Washington'!A6. This references cell A6 in the "Washington" worksheet.

b.

Select cell A6.
Copy the cell (Ctrl + C or right click and select Copy).
Highlight the range A7:A9.
Right click and under "Paste Options", select "Formulas".

c.

In cell B6, enter the formula =SUM(Idaho:Washington!B6). This formula totals the values from cell B6 across the worksheets named "Idaho" through "Washington".

d. *

Select cell B6.
Copy the cell (Ctrl + C or right click and select Copy).
Select the range B7:B9.
Right click and under "Paste Options", select "Formulas".

e.

Select range B6:B9.
Copy the selected range (Ctrl + C or right click and select Copy).
Select the range C6:E9.
Right click and select "Paste" (or press Ctrl + V). In this case, u don't need to worry about formatting because the value we copied and the destination cell has same stylings.

Video instruction:

module 5 1a question number 10

Answers

Post your answer

Recommended Books