$5.$

Create a worksheet group from the Grill$5-01$ through Grill$5-08$ worksheets. In the worksheet group, select the nonadjacent range A$7$:B$7,$A$11$:B$11,$A$16$:B$16,$ and then create named ranges from the selection using the labels in the left column.

$6.$

Use the Name Manager to change the TOTAL$\_$COST$\_$ OF$\_$ GOODS$\_$SOLD, TOTAL$\_$PAYROLL$\_$COSTS, and TOTAL$\_$SALES named ranges for the Grill$5-01$ worksheet from global scope to local scope by deleting those names and recreating them, limiting them to the scope of the Grill$5-01$ worksheet. Verify in the Name Manager that all the defined names in the workbook have local scope

$7.$

In the range B$5$:C$17$ of the Grill$5-01$ through Grill$5-08$ worksheets, replace the cell references to cells B$7,$ B$11,$ and B$16$ with the TOTAL$\_$SALES, TOTAL$\_$COST$\_$OF$\_$GOODS$\_$SOLD, and TOTAL$\_$PAYROLL$\_$COSTS defined names. You can either use the Apply Names command or find and replace the cell reference with the range name.

$8.$

In the Region Report worksheet, in cell F$5,$ use the SUM function to calculate the sum of cell B$5$ in the Grill$5-01$ through Grill$5-08$ worksheet group, displaying the total income from food salesUse AutoFill to extend the formula in cell F$5$ through the range F$5$:F$17.$ Fill without formatting in the range. Delete the zeros in cells F$8$ and F$12.$

$10.$

Open the Support$\_$EX$\_5\_$Region$1.$xlsx file located in the Excel$5>$ Review folder. Copy the range B$5$:B$17$ of the Region $1$ worksheet, and then use the Paste Link command to paste the external reference to the copied cells in the range B$5$:B$17$ of the Region Report worksheet. Delete the zeroes in cells B$8$ and B$12.$Repeat Step $10$ for the Region $2$ through Region $4$ data located in the Support$\_$EX$\_5\_$Region$2.$xlsx through Support$\_$EX$\_5\_$Region$4.$xlsx workbooks, pasting their external references in the ranges C$5$:C$17,$ D$5$:D$17,$ and E$5$:E$17,$ respectively. Delete the zeroes in rows $8$ and $12.$

$12.$

Copy the Grill$5-01$ worksheet to a new workbook so you can create a template of the Sales and Expenses worksheet with all the data removed, but the formulas and formatting retained.

$13.$

Save the NP$\_$EX$\_5\_$Report workbook, and then close it the new workbook you created in Step $12,$ make the following changes to the Grill$5-01$ worksheet:

Change the worksheet name to Franchise.

Change the text of cell A$2$ to $[$Region$]$ Monthly Sales and Expenses.

Delete the data in the nonadjacent range B$5$:B$6,$ B$9$:B$10,$ B$13$:B$15,$ F$4$:F$9.$

$15.$

Save the workbook as a template with the file name NP$\_$EX$\_5\_$Sales.xltx in the location specified by your instructor