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 A$6,$ enter a formula without using a function that references cell A$6$ in the Washington worksheet.

b$.$ Copy the formula from cell A$6$ to the range A$7$:A$9$ without copying the formatting.

c$.$ In cell B$6,$ enter a formula using the SUM function, $3-$D references, and grouped worksheets that totals the values from cell B$6$ in the Idaho:Washington worksheets.

d$.$ Copy the formula from cell B$6$ to the range B$7$:B$9$ without copying the formatting.

e$.$ Then copy the formulas and the formatting from the range B$6$:B$9$ to the range C$6$:E$9.$