70.2K

Verified Solution

Link Copied!

i completed up to question 7 i need help with the rest

1:06 chegg.com Step Instructions Open exploring_e09_grader_h2_Sales.xlsx ar exploring e09_grader_h2_Sales_Last First 1 Group the five regional worksheets. Insert a ne existing data. Type Agent in cell A1 Apply the With the five regional sheets grouped, type Q handle to add Qtr2-Qtr4 in cells C1:E1 Apply t center horizontal alignment to cells B1:E1 With the five regional sheets grouped, type To Heading 2 style and horizontal center alignme With the five regional sheets grouped, click ce press ENTER. Use the fill handle to complete t the range F3:F19. 5 With the five regional sheets grouped, type To insert a function to total Qtrl sales. Copy the f 6 With the five regional sheets grouped, format B20:F20 with AcCounting Number Format and the range B3:F19 with Comma Style and zero Double Bottom Border to cells B20:F20. 7 Ungroup the worksheets and click the Summa enter a formula that refers to cell B20 in the N cell B3 and enter a formula that refers to cell B worksheet. Click cell B4 and enter a formula th 8 South Region worksheet. Click cell B5 and ent B20 in the Midwest Region worksheet. Click ce refers to cell B20 in the West Region workshee In the Summary sheet, select the range B2:B6 range C2:F6 1:06 chegg.com In the Summary sheet, apply the Accounting N decimal places to the range B2:F2 and Comm places to the range B3:F6. Ensure that the col 14.57 to display the formula results. 10 In the Summary sheet, create a hyperlink in ea cell A1 in the respective worksheet 11 Edit the hyperlink in cell A2 in the Summary sh Click to see North Region sales. Edit the hyper sheet to create the ScreenTip Click to see East hyperlink in cell A4 in the Summary sheet to cr see South Region sales. Edit the hyperlink in c to create the ScreenTip Click to see MidWest F hyperlink in cell A6 in the Summary sheet to cr see West Region sales 12 On the Summary sheet, set a Watch Window t range B2:F6 13 Use the data in the Summary sheet to answer and 4 in the Q&A Sheet (for questions 3 and 4, 14 Click the North Region sheet tab, change the and observe the changes in the Watch Window. Go to the question 2 15 Create a footer with your name on the left side center, and the file name code on the right sid 16 sheets. Save and close the workbook, and submit the 17 Total Points 1:06 chegg.com Step Instructions Open exploring_e09_grader_h2_Sales.xlsx ar exploring e09_grader_h2_Sales_Last First 1 Group the five regional worksheets. Insert a ne existing data. Type Agent in cell A1 Apply the With the five regional sheets grouped, type Q handle to add Qtr2-Qtr4 in cells C1:E1 Apply t center horizontal alignment to cells B1:E1 With the five regional sheets grouped, type To Heading 2 style and horizontal center alignme With the five regional sheets grouped, click ce press ENTER. Use the fill handle to complete t the range F3:F19. 5 With the five regional sheets grouped, type To insert a function to total Qtrl sales. Copy the f 6 With the five regional sheets grouped, format B20:F20 with AcCounting Number Format and the range B3:F19 with Comma Style and zero Double Bottom Border to cells B20:F20. 7 Ungroup the worksheets and click the Summa enter a formula that refers to cell B20 in the N cell B3 and enter a formula that refers to cell B worksheet. Click cell B4 and enter a formula th 8 South Region worksheet. Click cell B5 and ent B20 in the Midwest Region worksheet. Click ce refers to cell B20 in the West Region workshee In the Summary sheet, select the range B2:B6 range C2:F6 1:06 chegg.com In the Summary sheet, apply the Accounting N decimal places to the range B2:F2 and Comm places to the range B3:F6. Ensure that the col 14.57 to display the formula results. 10 In the Summary sheet, create a hyperlink in ea cell A1 in the respective worksheet 11 Edit the hyperlink in cell A2 in the Summary sh Click to see North Region sales. Edit the hyper sheet to create the ScreenTip Click to see East hyperlink in cell A4 in the Summary sheet to cr see South Region sales. Edit the hyperlink in c to create the ScreenTip Click to see MidWest F hyperlink in cell A6 in the Summary sheet to cr see West Region sales 12 On the Summary sheet, set a Watch Window t range B2:F6 13 Use the data in the Summary sheet to answer and 4 in the Q&A Sheet (for questions 3 and 4, 14 Click the North Region sheet tab, change the and observe the changes in the Watch Window. Go to the question 2 15 Create a footer with your name on the left side center, and the file name code on the right sid 16 sheets. Save and close the workbook, and submit the 17

Answer & Explanation Solved by verified expert

See Answer