I need help with the attached excel worksheet problem.

1. Open the SierrraPacificCC-05 workbook. Click the Enable Editing button if necessary. 2. Save the workbook as Excel 5-2. 3. Group and format the worksheets. a. Click the 2013-14 worksheet tab. b. Hold down the Shift key and click the 2015-16 worksheet tab to select all the sheets. c. Right-click the column F heading and choose Delete. d. Select cells B8:F8 and click the AutoSum button [Home tab, Editing group]. e. Select cells A1:F2 and apply Outside Borders. f. Click cell A1. g. Right-click the 2013-14 worksheet tab and choose Ungroup Sheets. Save the workbook. 4. Create a new, blank workbook and save it as [your initials] Excel 5-2A. 5. Click the Arrange All button [View tab, Window group]. Choose Vertical and click OK. 6. Copy a worksheet to another workbook. a. Right-click the 2013-14 worksheet tab in [your initials] Excel 5-2. b. Choose Move or Copy. c. In the To book list, click the arrow and choose as [your initials] Excel 5-2A. d. Click to place a check mark for Create a copy (Figure 5-54). e. Click OK. A copy of the worksheet is placed in the new workbook. 7. Prepare the dependent workbook. a. In [your initials] Excel 5-2A, edit the label in cell A2 to read Academic Years 2013-2016. b. Select and delete the contents of cells B4:E7. c. Rename the 2013-2014 tab in [your initials] Excel 5-2A as 2013-2016. d. Delete Sheet1. e. Apply Dark Red fill to cells A3:F3 and A4:A7. E5-285 5-54 Move and Copy dialog box to copy worksheet to another workbook 8. Build an external reference formula in the dependent workbook. a. Click in cell B4 in the [your initials] Excel 5-2A workbook and type = to start the formula. b. Click cell B4 on the 2013-14 sheet tab in [your initials] Excel 5-2. c. Type + to add the next cell. d. Click cell B4 on the 2014-15 sheet tab in [your initials] Excel 5-2. e. Type +, and click cell B4 on the 2015-16 sheet tab in [your initials] Excel 5-2 (Figure 5-55). 5-55 External reference formula with absolute references f. Press Enter. The formula is placed in the [your initials] Excel 5-2A workbook with absolute references. g. Maximize the [your initials] Excel 5-2A workbook and click cell B4. E5-286 9. Edit and copy an external reference formula in the dependent workbook. a. Click in the Formula bar for cell B4 in the dependent workbook, [your initials] Excel 5-2A. b. Delete the $ symbols in the first occurrence of $B$4 to change the absolute reference to a relative reference. c. Delete the $ symbols in each occurrence of $B$4 in the formula (Figure 5-56). d. Press Enter. e. Copy the formula in cell B4 to cells B5:B7 without fill formatting. Copy the formula to cells C4:E7. f. Select the [your initials] Excel 5-2 workbook. Group worksheets 2013-14, 2014-15, and 2015-16. Select B5:F7 and apply Comma formatting without decimal places. Ungroup the sheets. g. Switch to [your initials] Excel 5-2A. Click cell B4. 5-56 External reference formula edited to use relative references 10. Insert a screenshot in a workbook. a. Click the Show Formulas button on the Formulas tab [Formula Auditing group]. You will take a screenshot of the formulas for placement in the source workbook. AutoFit the columns as needed. b. From the Windows Taskbar, switch to [your initials] Excel 5-2. Maximize the window. c. Insert a new worksheet and name it Screenshot. Place the sheet at the end of the tab names. d. Click the Take a Screenshot button [Insert tab, Illustrations group]. Note that when you are taking the screenshot, it works best if you close all open programs except Excel. e. From the gallery of thumbnails, click the thumbnail for [your initials] Excel 5-2A. The screenshot is placed on the new worksheet (Figure 5-57). 5-57 Screenshot placed in worksheet f. Click the dialog box launcher for the Size group on the Picture Tools Format tab. g. Set the Height of the screenshot to 5 and press Enter. The width is automatically reset to maintain the image's proportion. h. Close the Format Picture task pane. i. Click cell A26 to deselect the screenshot. E5-287 11. Save and close [your initials] Excel 5-2. 12. View and break links in the dependent workbook. a. Maximize the [your initials] Excel 5-2A window if necessary. b. Click the Show Formulas button on the Formulas tab [Formula Auditing group] to hide the formulas. AutoFit columns as needed. c. Click cell B4 if necessary. d. Click the Edit Links button [Data tab, Connections group]. e. Click Break Link. When you break a link, the formulas are replaced with values and this command cannot be undone (Figure 5-58). 5-58 Edit Links dialog box and Break Links message box f. Click Break Links. All formulas are removed, but the cells display the values. Click Close. g. Select B5:F7 and apply Comma formatting without decimal places. 13. Insert a hyperlink. a. Right-click cell A10 on the 2013-2016 sheet tab. b. Choose Hyperlink from the context-sensitive menu. c. Click Existing File or Web Page in the Insert Hyperlink dialog box. d. In the Look in list, select [your initials] Excel 5-2. Navigate to the appropriate folder if necessary by clicking the drop-down arrow and choosing the folder name. e. Select the default text in the Text to display box, and type Open the source workbook. You will use the default ScreenTip (Figure 5-59). 5-59 Hyperlink to open another workbook f. Click OK in the Insert Hyperlink dialog box. g. Click the hyperlink text to open the source workbook. E5-288 14. Close [your initials] Excel 5-2. Save and close [your initials] Excel 5-2A (Figure 5-60). Sierra Pacific Community College District Academic Year 2013-2014 Fall On-campus tuition Distance learning tuition Utilization fee Facilities fee Total Revenue $9,450,750 $3,450,800 $276,064 $1,134,090 Spring $8,235,600 $2,750,050 $220,004 $988,272 InterSession $1,780,500 $950,000 $76,000 $213,660 Summer $6,345,760 $1,850,090 $148,007 $761,491 Totals $25,812,610 $9,000,940 $720,075 $3,097,513 Sierra Pacific Community College District Academic Year 2014-2015 Fall On-campus tuition Distance learning tuition Utilization fee Facilities fee Total Revenue $11,124,560 $5,145,090 $411,607 $1,334,947 Spring $10,500,075 $4,560,125 $364,810 $1,260,009 InterSession $1,750,000 $1,150,000 $92,000 $210,000 Summer $7,345,500 $3,314,510 $265,161 $881,460 Totals $30,720,135 $14,169,725 $1,133,578 $3,686,416 Sierra Pacific Community College District Forecast for Academic Year 2015-2016 Fall On-campus tuition Distance learning tuition Utilization fee Facilities fee Total Revenue $12,163,200 $7,194,600 $575,568 $1,459,584 Spring $11,403,000 $6,994,750 $559,580 $1,368,360 InterSession $2,345,000 $1,150,000 $92,000 $281,400 Summer $8,973,150 $3,314,510 $265,161 $1,076,778 Totals $34,884,350 $18,653,860 $1,492,309 $4,186,122 Paradise Lakes Resort July 14 - 20, 2014 Sales Categories Monday Cabin Rentals Local Tours Fishing Guides Equipment Rentals Apparel Total Tuesday Wednesday Thursday Friday Saturday Sunday 6,778.00 1,456.00 1,564.00 654.00 678.00 8,777.00 2,243.00 1,890.00 876.00 764.00 6,789.00 1,890.00 1,564.00 657.00 892.00 3,405.00 876.00 1,245.00 358.00 451.00 $ 2,345.00 750.00 458.00 250.00 356.00 1,234.00 968.00 675.00 325.00 543.00 4,533.00 1,254.00 890.00 678.00 532.00 6,335.00 $ 4,159.00 $ 3,745.00 $ 7,887.00 $ 11,130.00 $ 14,550.00 $ 11,792.00