As the department head of the biology department at a university, you prepare and finalize the faculty teaching schedules. Recently, you prepared the first draft of the Spring class schedule. You will integrate changes from your assistant, add properties, insert a comment, check the workbook, and finalize the schedule.

Instructions:

For the purpose of grading the project you are required to perform the following tasks:

Step

Instructions

Points Possible

1

Open Excel and enter Exploring Series as the user name in the Excel Options dialog box, if necessary. Add the Compare and Merge Workbooks command to the Quick Access Toolbar, if necessary. Download and open exploring_e11_grader_h1_Classes.xlsx. Save it as exploring_e11_grader_h1_Classes_LastFirst.

Select cell A1. Activate the Track Changes feature, highlight all changes on screen, click the When check box to deselect it, and then create a History worksheet. Select the data on the History worksheet, copy it to the Clipboard, add a new worksheet (in the third position), and paste to keep source column widths. Rename the sheet Changes.

10

4

On the Faculty worksheet, open the Select Changes to Accept or Reject dialog box and deselect all check boxes. Accept the changes to cell J2 and F22. Reject the change to delete row 40. Accept the change to cell J39 and to delete row 37. Reject the change to cell J57. Accept all changes on the Changes worksheet. Turn off workbook sharing and save the workbook.

10

5

Insert the comment Assign faculty to classes in cell J2 in the Faculty worksheet. Then edit the comment by typing listed as STAFF. at the end of the existing comment text.

5

6

Type Spring Biology Schedule in the Title property box for the workbook.

5

7

Insert a new sheet named Checks, and move it to the right side of the other sheet tabs. Type Document Inspector in cell A1, type Accessibility Checker in cell A2, and Compatibility Checker in cell A3.

5

8

Run Document Inspector with all the default options selected. Look at the category names for the concerns in the workbook. Close the Document Inspector. Type the first word of the category name in cell B1 in the Checks sheet.

10

9

Run Accessibility Checker. Type the first sentence (including the period) displayed in the Accessibility Checker task pane in cell B2 in the Checks sheet. Close the Accessibility Checker task pane.

10

10

Run the Compatibility Checker. Type the sentence displayed in the Compatibility Checker dialog box (include the period) in cell B3 in the Checks sheet. Close the Compatibility Checker.

10

11

Set the width of column A to 17 and the width of column B to 29 in the Checks sheet.

4

12

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 each worksheet.

6

13

Display the Faculty worksheet and use the Page Setup dialog box to repeat row 1 on each page.