Edra wants to consolidate the data from each of the regions. Switch to the Consolidated Sales...

  

 

Transcribed Image Text:

Edra wants to consolidate the data from each of the regions. Switch to the Consolidated Sales worksheet, then update the worksheet as follows: 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. 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. Then copy the formulas and the formatting from the range B6:B9 to the range C6:E9. e. Edra wants to consolidate the data from each of the regions. Switch to the Consolidated Sales worksheet, then update the worksheet as follows: 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. 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. Then copy the formulas and the formatting from the range B6:B9 to the range C6:E9. e.

Answer rating: 100% (QA)

10a In cell A6 use the formula WashingtonA6 10b Go to cell A6 and press CtrlC Mark c... View the full answer