Excel_5E_Sports_Schedule
Start Excel. Download, save, and open the workbook named Student_Excel_Sports_Schedule.xlsx.
Go To cell M82, and then insert a COUNTIF function to count the number of Staff referees using the range M1:M80 in the formula. In cell K82, type Events with Unassigned Referees.
Move to cell A1, and then from the files you downloaded for this project, Open the file e05E_Referee_Requests. Switch windows, and then make your 5E_Sports_Schedule the active window. Arrange the two files horizontally.
Mac users, do not open the file, or if you have opened the e05E_Referee_Requests workbook, close the file. In your 5E_Sports_Schedule file, click cell M48, type Danny Litowitz and then make cell A1 the active cell. Skip Steps 4 and 5, and then continue with Step 6.
In your 5E_Sports_Schedule workbook, Go To cell A82, Split the window, and then click in any cell above the split in column C. Use Find to locate the first Event # request from the e05E_Referee_Requests worksheet, and then in cell M48 in your 5E_Sports_Schedule, type Danny Litowitz to assign him as the Referee.
Close the Find and Replace dialog box, and then Close the e05E_Referee_Requests workbook. Maximize your 5E_Sports_Schedule worksheet, and then remove the Split.
Insert a new blank row 1. In cell A1, type Schedule of Sports Events with Unassigned Referees and then Merge & Center the title across the range A1:M1. Apply the Title cell style.
Create a New Table Style named Sports Schedule and format the First Row Stripe with a Fill—in the last column, the third color. Set the style you created as the default table style for this workbook.
Select the range A2:M81 and apply the Custom table style—Sports Schedule.
AutoFit columns A:M. Set the Orientation to Landscape, set the Width to 1 page, and center the worksheet Horizontally. Insert a footer in the left section that includes the file name, and in the right section, insert a page number.
In Page Break Preview, break Page 1 after row 49 to end Page 1 with TENNIS and begin Page 2 with TRACK. Return to Normal view. Set Print Titles to repeat row 2 at the top of each page.
In cell J2, Insert a Hyperlink to your student data file e05E_Sports_Coaches. Create the ScreenTip Click here for contact information and then test your hyperlink. Close the e05E_Sports_Coaches file.
Save your workbook and then close Excel. Submit the workbook as directed.