Tracking Changes - Exercise

Contact Us or call 1-877-932-8228
Tracking Changes - Exercise

Tracking Changes

Duration: 10 to 20 minutes.

In this exercise, you will practice tracking changes and then accepting and rejecting changes.

For the purpose of this exercise, pretend you are a teacher. You have a worksheet showing your students' grades on four exams. You are letting your students grade themselves on the final project. You have given them access to your workbook on which they are to enter the grade they are giving themselves. You have told them they are not to make any changes to the workbook other than adding their grade for the final project. To make it easy to figure out if everyone did as asked without actually preventing them from making changes, you plan to turn on change tracking before sharing the workbook with them.

  1. Open Tracking Changes.xlsx from your Excel2013.3/Exercises folder. This is the workbook you will share with your students.
  2. Turn on Track Changes. Do not highlight the changes on the screen.
  3. Open Tracking Changes2.xlsx from your Excel2013.3/Exercises folder. This is the workbook after your students have entered their grades.
  4. Accept changes in column F (Final Project grades) and reject inappropriate changes. Nolan Ryan reminded you that you incorrectly gave him credit for a problem he missed on the fourth exam and you told him it would be okay to lower his grade to an 88, so accept this change.
  5. List all the changes on a new sheet.

Solution:

  1. To track changes in Tracking Changes.xlsx:
    1. On the REVIEW tab, in the Changes group, click the Track Changes command:Track Changes Command
    2. Click Highlight Changes:Highlight Changes Command
    3. In the Highlight Changes dialog box:
      1. Check the Track changes while editing. This also shares your workbook. box.
      2. Under Highlight which changes, accept the defaults.
      3. Uncheck the box next to Highlight changes on screen.
      4. Click OK:Highlight Changes
      5. In the dialog box that appears, confirm that you want to save the workbook by clicking OK:Confirm Dialog Box
  2. To accept appropriate changes and reject inappropriate changes in Tracking Changes2.xlsx:
    1. On the REVIEW tab, in the Changes group, click the Track Changes command:Track Changes Command
    2. Click Accept/Reject Changes:Accept/Reject Changes
    3. In the Select Changes to Accept or Reject dialog box, accept the defaults and click OK:Select Changes to Accept or Reject Dialog Box
    4. In the Accept or Reject Changes dialog box, review each change individually by clicking Accept or Reject. Accept all changes to column F (Final Project grades) and also the change to cell E11 (Nolan Ryan's 4th exam) and reject all other changes as students weren't supposed to change any other grades.
      1. Reject the first change, which is to cell B8:Reject Change
      2. Reject the second change, which is to cell C8:Reject Change
      3. Reject the third and fourth changes, which are to cells D8 and E8.
      4. Accept all remaining changes:Accept Changes
  3. To list all the changes on a new sheet:
    1. On the REVIEW tab, in the Changes group, click the Track Changes command:Track Changes Command
    2. Click Highlight Changes:Highlight Changes Command
    3. In the Highlight Changes dialog box, uncheck the When box, check List changes on a new sheet, and click OK:Highlight Changes Dialog Box
Next