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:39 without copying the formatting.
e. then copy the formulas and the formatting from the range b6:39 to the range c6:e9.



Answer :

Other Questions