You are an accountant for a pharmaceutical sales company. As one of your tasks, you compile an annual report that documents regional sales information into one standardized worksheet. As part of this process, you group the worksheets and insert descriptive rows and columns, apply formatting, and insert functions. Your last step is to create a sales summary worksheet and provide basic information for management to evaluate. Open e09m1Sales and save it as e09m1Sales_LastFirst. Group the five regional worksheets and complete the following steps: Insert a new row above row 1 of the existing data. Type Agent in cell A1. Apply the Heading 2 style in the Styles group on the Home tab. Type Qtr1 in cell B1. Use the fill handle to add Qtr2-Qtr4 in cells C1:E1. Apply the Heading 3 style and apply center horizontal alignment to cells B1:E1. Type Total in cell F1. Apply the Heading 2 style and horizontal center alignment. Click cell F2, type =SUM(B2:E2), and press Enter. Use the fill handle to complete the summary information to the range B3:B19. Keep the five worksheets grouped (not including the Summary sheet) and complete the following steps: Type Total in cell A20. In cell B20, insert a function to total Qtr1 sales. Copy the function to the range C20:F20. Format the ranges B2:F2 and B20:F20 with Accounting Number Format and zero decimal places. Format the range B3:F19 with Comma Style and zero decimal places. Add Top and Double Bottom Border to cells B20:F20. Ungroup the worksheets and click the Summary sheet tab. Build formulas with 3-D references by completing the following steps: Click cell B2 and enter a formula that refers to cell B20 in the North Region worksheet. Click cell B3 and enter a formula that refers to cell B20 in the East Region worksheet. Click cell B4 and enter a formula that refers to cell B20 in the South Region worksheet. Click cell B5 and enter a formula that refers to cell B20 in the Midwest Region worksheet. Click cell B6 and enter a formula that refers to cell B20 in the West Region worksheet. Select the range B2:B6 and copy the formulas to the range C2:F20. Apply Accounting Number Format with zero decimal places to the range B2:F2 and Comma Style with zero decimal places to the range B3:F6. Adjust the column widths if they are too narrow to display the formula results. Create a hyperlink in each cell in the range A2:A6 to cell A1 in the respective worksheet. Edit each hyperlink to create a ScreenTip such as Click to see North Region sales. Set a Watch Window to watch the formulas in the range B2:F6 on the Summary sheet. Use the data in the Summary sheet to answer the summary questions 1, 3, and 4 in the Q&A sheet. Click the North Region sheet tab, change the value in cell B2 to 3,000,000, and observe the changes in the Watch Window. Go to the Q&A sheet and answer question 2. 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 Summary and Q&A sheets. Save and close the file. Based on your instructor’s directions, submit e09m1SalesRetire_LastFirst.