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 $A7$:$A9$ 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 $B6$:$B9$ to the range C$6$:E$9.$

Edra started to create named ranges in the worksheet and has asked you to complete the work. Create a defined name for the range B$6$:E$6$ using Walkup as the range name.

Create names from the range A$7$:E$9$ using the values shown in the left column.

Apply the defined names Q$1\_$Sales, Q$2\_$Sales, Q$3\_$Sales, and Q$4\_$Sales to the formulas in the range B$10$:E$10$ in the Consolidated Sales worksheet.

Change the defined name to Totals$\_2024$ for the range F$6$: F$9.[$Mac Hint: Delete the existing defined name "Totals" and add the new defined name.$]$

Edra wants to compare $2024$ sales totals to the sales totals for $2023$ and needs to add the $2020$ data to the Consolidated Sales worksheet. Open the file Support$\_$EX$365\_2021\_5$a$\_2023\_$Sales.xlsx$.$ Switch back to the NP$\_$EX$365\_2021\_5$a$\_$FirstLastName$\_2.$xlsx workbook and go to the Consolidated Sales worksheet. Create external references as follows:

a$.$ Link cell G$6$ in the Consolidated Sales worksheet to cell F$6$ in the Consolidated Sales worksheet in the Support$\_$EX$365\_2021\_5$a$\_2023\_$Sales.xisx workbook.

b$.$ Link cell G$7$ in the Consolidated Sales worksheet to cell F$7$ in the Consolidated Sales worksheet in the Support$\_$EX$365\_2021\_5$a$\_2023\_$Sales.xlsx workbook.

c$.$ Link cell G$8$ in the Consolidated Sales worksheet to cell F$8$ in the Consolidated Sales worksheet in the Support$\_$EX$365\_2021\_5$a$\_2023\_$Sales.xlsx workbook.

d$.$ Link cell G$9$ in the Consolidated Sales worksheet to cell F$9$ in the Consolidated Sales worksheet in the Support$\_$EX$365\_2021\_5$a$\_2023\_$Sales.xisx workbook.

e$.$ Do not break the links. Close the Support$\_$EX$365\_2021\_5$a$\_2023\_$Sales.xlsx workbook.

In cell G$10,$ enter a formula to total the values in the defined range Totals$\_2023,$ using the SUM function and the defined range name.

Edra wants to compare $2024$ sales totals to the sales totals for $2023$ and needs to add the $2020$ data to the Consolidated Sales worksheet. Open the file Support$\_$EX$365\_2021\_5$a$\_2023\_$Sales.xlsx$.$ Switch back to the NP$\_$EX$365\_2021\_5$a$\_$FirstLastName$\_2.$xlsx workbook and go to the Consolidated Sales worksheet. Create external references as follows:

a$.$ Link cell G$6$ in the Consolidated Sales worksheet to cell F$6$ in the Consolidated Sales worksheet in the Support$\_$EX$365\_2021\_5$a$\_2023\_$Sales.xisx workbook.

b$.$ Link cell G$7$ in the Consolidated Sales worksheet to cell F$7$ in the Consolidated Sales worksheet in the Support$\_$EX$365\_2021\_5$a$\_2023\_$Sales.xlsx workbook.

c$.$ Link cell G$8$ in the Consolidated Sales worksheet to cell F$8$ in the Consolidated Sales worksheet in the Support$\_$EX$365\_2021\_5$a$\_2023\_$Sales.xlsx workbook.

d$.$ Link cell G$9$ in the Consolidated Sales worksheet to cell F$9$ in the Consolidated Sales worksheet in the Support$\_$EX$365\_2021\_5$a$\_2023\_$Sales.xisx workbook.

e$.$ Do not break the links. Close the Support$\_$EX$365\_2021\_5$a$\_2023\_$Sales.xlsx workbook.

In cell G$10,$ enter a formula to total the values in the defined range Totals$\_2023,$ using the SUM function and the defined range name.