You manage a chain of pizza restaurants in Augusta, Lewiston, and Portland, Maine. Each store manager created a workbook containing the quarterly sales for each type of sale (dine-in, carry-out, and delivery). You want to create links to a summary workbook for the yearly totals.

a. Open e09m2Augusta and save it as e09m2Augusta_LastFirst, open e09m2Lewiston and save it as e09m2Lewiston_LastFirst, and open e09m2Portland and save it as e09m2Portland_LastFirst.

b. Calculate totals in the ranges F4:F6 and B7:F7 in all three workbooks.

c. Open e09m2Pizza and save it as e09m2Pizza_LastFirst. Continue working in this workbook.

d. Display the Augusta worksheet; in cell B4 insert a link to the Dine-In total in cell F4 in the e09m2Augusta_LastFirst workbook. Edit the formula to make the cell reference relative, use AutoFill to copy the formula to the range B5:B7, and then select the Fill Without Formatting

e. Display the Portland worksheet; in cell B4 insert a link to the Dine-In total in cell F4 in the e09m2Portland_LastFirst workbook. Edit the formula to make the cell reference relative, copy the formula, and use the paste option to paste the Formula to the range B5:B7 to preserve the existing formatting.

f. Display the Lewiston worksheet; in cell B4 insert a link to the Dine-In total in cell F4 in the e09m2Lewiston_LastFirst workbook. Edit the formula to make the cell reference relative, copy the formula, and then use the paste option to paste the Formula to the range B5:B7 to preserve the existing formatting.

g. Close the Augusta, Portland, and Lewiston workbooks. h. Select the range A1:B7 in the Lewiston worksheet. Group the Lewiston and Summary work-sheets. Fill formatting only across the grouped worksheets. Ungroup the worksheets and change the width of column B to 16 in the Summary worksheet.

i. Insert functions with 3-D references in the Summary worksheet by completing the following steps: • Insert a SUM function in cell B4 that calculates the total Dine-In sales for the three cities. • Copy the formula in cell B4 and use the Paste Formulas option in the range B5:B7 to preserve the formatting.

j. Display the Contents worksheet and insert the following hyperlinks: • Insert a hyperlink in cell A3 that links to cell B7 in the Augusta sheet. Include the ScreenTip text: Augusta total sales (no period). • Insert a hyperlink in cell A4 that links to cell B7 in the Portland sheet. Include the ScreenTip text: Portland total sales (no period). • Insert a hyperlink in cell A5 that links to cell B7 in the Lewiston sheet. Include the ScreenTip text: Lewiston total sales (no period). • Insert a hyperlink in cell A6 that links to cell B7 in the Summary sheet. Include the ScreenTip text: Total sales for all locations (no period).

k. Select the range B3:B5 on the Future worksheet and add the following data validation rule: • Allow Date between 3/1/2021 and 10/1/2021. • Enter the input message title: Proposed Date. • Enter the input message: Enter the proposed opening date for this location. (including the period). • Select the Information error alert style. • Enter the error alert title: Confirm Date. • Enter the error message: Confirm the date with the VP. (including the period). • Enter 10/5/2021 in cell B5 and click OK in the Confirm Date message box.

l. Make these changes to the Future worksheet: • Unlock the range B3:B5. • Protect the worksheet by adding the password Expl0r!ng. • Hide the Future worksheet.

m. Create a footer with your name on the left side, the sheet name code in the center, and the file name code on the right side of the five visible worksheets.

n. Mark the workbook as final. (On a Mac, use Always Open Read-Only).

o. Close the file and exit Excel. Open File Explorer, select the four e09m2 files, and create a com-pressed (zipped) folder named e09m2PizzaFiles_LastFirst.

p. Based on your instructor’s directions, submit e09m2PizzaFiles_LastFirst.zip.

You manage a chain of pizza restaurants in Augusta, Lewiston, and Portland, Maine. Each store manager created a workbook containing the quarterly sales for each type of sale (dine-in, carry-out, and delivery). You want to create links to a summary workbook for the yearly totals.

a. Open e09m2Augusta and save it as e09m2Augusta_LastFirst, open e09m2Lewiston and save it as e09m2Lewiston_LastFirst, and open e09m2Portland and save it as e09m2Portland_LastFirst.

b. Calculate totals in the ranges F4:F6 and B7:F7 in all three workbooks.

c. Open e09m2Pizza and save it as e09m2Pizza_LastFirst. Continue working in this workbook.

d. Display the Augusta worksheet; in cell B4 insert a link to the Dine-In total in cell F4 in the e09m2Augusta_LastFirst workbook. Edit the formula to make the cell reference relative, use AutoFill to copy the formula to the range B5:B7, and then select the Fill Without Formatting

e. Display the Portland worksheet; in cell B4 insert a link to the Dine-In total in cell F4 in the e09m2Portland_LastFirst workbook. Edit the formula to make the cell reference relative, copy the formula, and use the paste option to paste the Formula to the range B5:B7 to preserve the existing formatting.

f. Display the Lewiston worksheet; in cell B4 insert a link to the Dine-In total in cell F4 in the e09m2Lewiston_LastFirst workbook. Edit the formula to make the cell reference relative, copy the formula, and then use the paste option to paste the Formula to the range B5:B7 to preserve the existing formatting.

g. Close the Augusta, Portland, and Lewiston workbooks. h. Select the range A1:B7 in the Lewiston worksheet. Group the Lewiston and Summary work-sheets. Fill formatting only across the grouped worksheets. Ungroup the worksheets and change the width of column B to 16 in the Summary worksheet.

i. Insert functions with 3-D references in the Summary worksheet by completing the following steps: • Insert a SUM function in cell B4 that calculates the total Dine-In sales for the three cities. • Copy the formula in cell B4 and use the Paste Formulas option in the range B5:B7 to preserve the formatting.

j. Display the Contents worksheet and insert the following hyperlinks: • Insert a hyperlink in cell A3 that links to cell B7 in the Augusta sheet. Include the ScreenTip text: Augusta total sales (no period). • Insert a hyperlink in cell A4 that links to cell B7 in the Portland sheet. Include the ScreenTip text: Portland total sales (no period). • Insert a hyperlink in cell A5 that links to cell B7 in the Lewiston sheet. Include the ScreenTip text: Lewiston total sales (no period). • Insert a hyperlink in cell A6 that links to cell B7 in the Summary sheet. Include the ScreenTip text: Total sales for all locations (no period).

k. Select the range B3:B5 on the Future worksheet and add the following data validation rule: • Allow Date between 3/1/2021 and 10/1/2021. • Enter the input message title: Proposed Date. • Enter the input message: Enter the proposed opening date for this location. (including the period). • Select the Information error alert style. • Enter the error alert title: Confirm Date. • Enter the error message: Confirm the date with the VP. (including the period). • Enter 10/5/2021 in cell B5 and click OK in the Confirm Date message box.

l. Make these changes to the Future worksheet: • Unlock the range B3:B5. • Protect the worksheet by adding the password Expl0r!ng. • Hide the Future worksheet.

m. Create a footer with your name on the left side, the sheet name code in the center, and the file name code on the right side of the five visible worksheets.

n. Mark the workbook as final. (On a Mac, use Always Open Read-Only).

o. Close the file and exit Excel. Open File Explorer, select the four e09m2 files, and create a com-pressed (zipped) folder named e09m2PizzaFiles_LastFirst.

p. Based on your instructor’s directions, submit e09m2PizzaFiles_LastFirst.zip.

You manage a chain of pizza restaurants in Augusta, Lewiston, and Portland, Maine. Each store manager created a workbook containing the quarterly sales for each type of sale (dine-in, carry-out, and delivery). You want to create links to a summary workbook for the yearly totals.

a. Open e09m2Augusta and save it as e09m2Augusta_LastFirst, open e09m2Lewiston and save it as e09m2Lewiston_LastFirst, and open e09m2Portland and save it as e09m2Portland_LastFirst.

b. Calculate totals in the ranges F4:F6 and B7:F7 in all three workbooks.

c. Open e09m2Pizza and save it as e09m2Pizza_LastFirst. Continue working in this workbook.

d. Display the Augusta worksheet; in cell B4 insert a link to the Dine-In total in cell F4 in the e09m2Augusta_LastFirst workbook. Edit the formula to make the cell reference relative, use AutoFill to copy the formula to the range B5:B7, and then select the Fill Without Formatting

e. Display the Portland worksheet; in cell B4 insert a link to the Dine-In total in cell F4 in the e09m2Portland_LastFirst workbook. Edit the formula to make the cell reference relative, copy the formula, and use the paste option to paste the Formula to the range B5:B7 to preserve the existing formatting.

f. Display the Lewiston worksheet; in cell B4 insert a link to the Dine-In total in cell F4 in the e09m2Lewiston_LastFirst workbook. Edit the formula to make the cell reference relative, copy the formula, and then use the paste option to paste the Formula to the range B5:B7 to preserve the existing formatting.

g. Close the Augusta, Portland, and Lewiston workbooks. h. Select the range A1:B7 in the Lewiston worksheet. Group the Lewiston and Summary work-sheets. Fill formatting only across the grouped worksheets. Ungroup the worksheets and change the width of column B to 16 in the Summary worksheet.

i. Insert functions with 3-D references in the Summary worksheet by completing the following steps: • Insert a SUM function in cell B4 that calculates the total Dine-In sales for the three cities. • Copy the formula in cell B4 and use the Paste Formulas option in the range B5:B7 to preserve the formatting.

j. Display the Contents worksheet and insert the following hyperlinks: • Insert a hyperlink in cell A3 that links to cell B7 in the Augusta sheet. Include the ScreenTip text: Augusta total sales (no period). • Insert a hyperlink in cell A4 that links to cell B7 in the Portland sheet. Include the ScreenTip text: Portland total sales (no period). • Insert a hyperlink in cell A5 that links to cell B7 in the Lewiston sheet. Include the ScreenTip text: Lewiston total sales (no period). • Insert a hyperlink in cell A6 that links to cell B7 in the Summary sheet. Include the ScreenTip text: Total sales for all locations (no period).

k. Select the range B3:B5 on the Future worksheet and add the following data validation rule: • Allow Date between 3/1/2021 and 10/1/2021. • Enter the input message title: Proposed Date. • Enter the input message: Enter the proposed opening date for this location. (including the period). • Select the Information error alert style. • Enter the error alert title: Confirm Date. • Enter the error message: Confirm the date with the VP. (including the period). • Enter 10/5/2021 in cell B5 and click OK in the Confirm Date message box.

l. Make these changes to the Future worksheet: • Unlock the range B3:B5. • Protect the worksheet by adding the password Expl0r!ng. • Hide the Future worksheet.

m. Create a footer with your name on the left side, the sheet name code in the center, and the file name code on the right side of the five visible worksheets.

n. Mark the workbook as final. (On a Mac, use Always Open Read-Only).

o. Close the file and exit Excel. Open File Explorer, select the four e09m2 files, and create a com-pressed (zipped) folder named e09m2PizzaFiles_LastFirst.

p. Based on your instructor’s directions, submit e09m2PizzaFiles_LastFirst.zip.

b. Calculate totals in the ranges F4:F6 and B7:F7 in all three workbooks.

b. Calculate totals in the ranges F4:F6 and B7:F7 in all three workbooks.

c. Open e09m2Pizza and save it as e09m2Pizza_LastFirst. Continue working in this workbook.

c. Open e09m2Pizza and save it as e09m2Pizza_LastFirst. Continue working in this workbook.

n. Mark the workbook as final. (On a Mac, use Always Open Read-Only).

n. Mark the workbook as final. (On a Mac, use Always Open Read-Only).

p. Based on your instructor’s directions, submit e09m2PizzaFiles_LastFirst.zip.

p. Based on your instructor’s directions, submit e09m2PizzaFiles_LastFirst.zip.