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.

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.

Explanation:

Microsoft Excel is a spreadsheet application used for data analysis and statistical calculation. The worksheet is made of columns and rows like a table and labeled alphabetically and numerically respectively. Several worksheets can be referenced in an excel workbook

To consolidate data in excel, reference a cell from another worksheet in the formula of the current worksheet and copy the formula from the cell to a given range of cells, without copying the formatting of the cell.

answerpanning and scanning;