Microsoft Excel 2010 Expert — Question 23
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.
Answer options
- A. History tracking
- B. Onscreen highlighting
- C. Slicer-enabled highlighting
- D. Reviewing of changes
Correct answer: B, A, D
Explanation
The correct options are B, A, and D because 'Onscreen highlighting' helps visually indicate changes, 'History tracking' provides a record of changes made, and 'Reviewing of changes' allows for evaluation of those modifications. 'Slicer-enabled highlighting' does not pertain to tracking changes in a worksheet, making it an incorrect choice.