3 files for data

Augusta Location
Category	1st Quarter	2nd Quarter	3rd Quarter	4th Quarter	Total
Dine-In	$ 40,000	$ 34,000	$ 29,000	$ 22,000	$ 125,000
Pick-up	$ 62,000	$ 63,000	$ 62,000	$ 63,000	$ 250,000
Delivery	$ 22,000	$ 26,000	$ 35,000	$ 42,000	$ 125,000
Total	$ 124,000	$ 123,000	$ 126,000	$ 127,000	$ 500,000

Lewiston Location
Category	1st Quarter	2nd Quarter	3rd Quarter	4th Quarter	Total
Dine-In	$ 12,000	$ 10,000	$ 8,000	$ 6,000	$ 36,000
Pick-up	$ 27,000	$ 26,000	$ 26,000	$ 26,000	$ 105,000
Delivery	$ 25,000	$ 34,000	$ 46,000	$ 60,000	$ 165,000
Total	$ 64,000	$ 70,000	$ 80,000	$ 92,000	$ 306,000

Portland Location
Category	1st Quarter	2nd Quarter	3rd Quarter	4th Quarter	Total
Dine-In	$ 45,000	$ 41,000	$ 38,000	$ 33,000	$ 157,000
Pick-up	$ 19,000	$ 21,000	$ 20,000	$ 20,000	$ 80,000
Delivery	$ 25,000	$ 35,000	$ 45,000	$ 55,000	$ 160,000
Total	$ 89,000	$ 97,000	$ 103,000	$ 108,000	$ 397

Main file by teacher

Final result image by teacher

I can send the excel files. please give me a email thank you

-the first image is the questions to solve

-then the 3 below it are the data to use

-then the file teacher provided to do the work on

-and last the final result image teacher provided

Please help Thank you

and the pictures are clear if you open them in new tab sir/madam. i gave the whole answer as it was in the documents provided by the teacher. i missed the dead line so never mind now. not really helpfull

File Home Insert Design Layout References Mailings Review View Help Acrobat Table Design Layout Share Comments Arial 9 ~ A Aa AO JT X Cut Copy * Format Painter Find Replace Select AaBDCD AaBbC AaBbCcl AaBbccd AaBbccd AaBhCcDd AaBbccc AaBbCcD AaBbccd AaBbccDc AaBbccdc Emphasis Heading 1 Heading 2 I Normal T Normal ... Strong Subtitle I Title I No Spac... Subtle Em... Intense E... Paste BIUb X, X A Dictate Editor Create and Share Request Adobe PDF Signatures Adobe Acrobat Clipboard Styles Editing Voice Editor Step Instructions Points Possible Font Paragraph Exp19_Excel_Ch09_ML2_Pizza_Sales Project Description: 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, carryout, and delivery). You want to create linksto a summary workbookfor the yearly totals. 11 Copy the formula in cell B4 and use the Paste Formulas option in the range B5:87 to preserve the formatting 5 12 10 Steps to Perform: Step Instructions Points Possible You are ready to display the Contentsworksheet and insert hyperlinks. Insert a hyperlinkin cell A3 that linksto cell B7 in the Augusta sheet. Include the ScreenTip text: Augusta total sales (no period). Insert a hyperlink in cell A4 that linksto cell B7 in the Portland sheet. Include the Screen Tip text: Portland total sales (no period). Insert a hyperlinkin cell A5 that linksto cell B7 in the Lewiston sheet. Include the ScreenTip text: Lewiston total sales (no period). Insert a hyperlink in cell A6 that linksto cell B7 in the Summary sheet. Include the ScreenTip text: Total sales for all locations (no period). 1 0 Start Excel. Download and open the file named Exp19_Excel_Ch09_ML2_Pizza.xlsx. Grader has automatically added your last name to the beginning of the filename. You want to enter totals from the Augusta workbook into the Pizza workbook. 2 5 | 13 You want to create a data validation rule. 13 Display the Augusta worksheet; in cell B4, insert a link to the Dine-In total in cell F4 in the Exp19_ExcelChog_ML2_Augusta workbook. Edit the formula to make the cell reference relative. 3 You want to copy the formula down the column but preserve the originalformatting. 6 Select the range B3:85 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 (no period). 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 (no period). Enter the error message: Confirm the date with the VP. (including the period). Use AutoFill to copy the formula from cell B4 to the range B5:87 in the Augusta worksheet. Close the Augusta workbook; keep the Pizza workbookopen. 4 You wantto enter totals from the Portland workbook into the Pizza workbook. 5 14 You should test the validation rule to ensure it works correctly. 3 Display the Portland worksheet; in cell B4 insert a link to the Dine-In total in cell F4 in the Exp19_Excel_Ch09_ML2_ Portlandworkbook. Edit the formula to make the cell reference relative. Enter 10/5/2021 in cell B3 and click OK in the Confirm Date message box. 15 You want to unlocka range on the Future worksheetto enable changes by users. 6 5 6 You want to copy the formula down the column but preserve the original formatting. Use AutoFill to copy the formula from cell B4 to the range 85:87 in the Portland worksheet. Close the Portland workbook, keep the Pizza workbook open. Unlock the range B3:05. 16 Now that the cells are unlocked, you are ready to protect the Future worksheet. 6 6 You wantto enter totals from the Lewiston workbook into the Pizza workbook. 5 Protect the worksheet without a password and using the default settings. 17 Hide the Future worksheet 6 Display the Lewiston worksheet; in cell B4 insert a link to the Dine-In total in cell F4 in the Exp19_Excel_Chog_ML2_Lewistonworkbook. Edit the formula to make the cell reference relative. 18 6 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. 7 6 You want to copy the formula down the column but preserve the originalformatting. Use AutoFill to copy the formula from cell B4 to the range B5:37 in the Lewiston worksheet. Close the Lewiston workbook; keep the Pizza workbook open. 19 Mark the workbook as final. 0 Note: Mark as Finalis not available in Excel for Mac. Instead, use Always Open Read-Only on the Review tab. 8 5 The Summary sheet should contain the same formatting as the other sheets. Select the range A1:87 in the Lewiston worksheet. Group the Lewiston and Summary worksheets. Fill formatting only across the grouped worksheets. 20 Save and close Exp19_Excel_Ch09_ML2_Pizza.xlsx. Exit Excel. Submit the file as directed. 0 Total Points 100 9 Ungroup the worksheets and change the width of column B to 16 in the Summary worksheet. 2 10 You are ready to insert functions with 3-D references in the Summary worksheet. 5 In cell B4, insert a SUM function that calculates the total Dine-In sales for the three cities. Page 1 of 2 796 words m English (United States) C) Focus 100% A4 fix Dine-In File Home Insert Paste - Copy B File Home Insert Page Layout Formulas Data Review View Help File B4 Home Insert Format Painter D E F G H 1 An Clipboard C Calibri = ab Wrap Aria X Cut LG Copy Format Painter Paste X Cut [Copy v