nerdexam
Microsoft

77-427 · Question #52

You work as an Office Assistant for Blue Well Inc. The company has a Windows-based network. Some employees have changed some data in the worksheet of the company. You want to identify changes that…

The correct answer is A. History tracking B. Onscreen highlighting D. Reviewing of changes. The following ways are provided by Excel to access and use the stored change history: 1. Onscreen highlighting: It is used when a workbook does not contain many changes and a user wants to see all changes at a glance. 2. History tracking: It is used when a workbook has many…

Manage and share workbooks

Question

You work as an Office Assistant for Blue Well Inc. The company has a Windows-based network. Some employees have changed some data in the worksheet of the company. You want to identify changes that were made to the data in the workbook and then take a decision whether to accept or reject those changes. For this purpose, it is required to access and use the stored change history. Which of the following will you use to accomplish the task? Each correct answer represents a complete solution. Choose all that apply.

Options

  • AHistory tracking
  • BOnscreen highlighting
  • CSlicer-enabled highlighting
  • DReviewing of changes

How the community answered

(36 responses)
  • A
    78% (28)
  • C
    22% (8)

Explanation

The following ways are provided by Excel to access and use the stored change history: 1. Onscreen highlighting: It is used when a workbook does not contain many changes and a user wants to see all changes at a glance. 2. History tracking: It is used when a workbook has many changes and a user wants to investigate what occurred in a series of changes. 3. Reviewing of changes: It is used when a user is evaluating comments from other users. Answer option C is incorrect. This is an invalid answer option.

Topics

#track changes#change history#onscreen highlighting#reviewing changes

Community Discussion

No community discussion yet for this question.

Full 77-427 Practice