Question

While reviewing a shared spreadsheet, Priya notices that some cells have been modified, but she’s unsure who made the changes. Which feature should she use to identify the editor?

• A. Data Validation
• B. Track Changes
• C. Observe Changes
• D. AutoFilter

Hint:

Use the "Track Changes" feature in spreadsheet applications to identify who made specific changes to a document and what changes were made.

Answer 1

The Correct Option is B

To solve this question, we need to identify the feature that Priya should use to track changes in a shared spreadsheet and determine who made specific modifications. Let us examine the provided options one by one:

1. Data Validation: This feature is used to set rules for what data can be entered in a cell. It does not track who made changes to the data.
2. Track Changes: This feature is specifically designed to track edits in a document or a spreadsheet. It keeps a record of changes made and identifies who made each change, making it the ideal tool for Priya to determine who modified the cells.
3. Observe Changes: This is not a recognized feature in most spreadsheet applications related to tracking changes.
4. AutoFilter: This feature is used to filter data within a spreadsheet based on certain criteria. It does not keep track of changes or identify the editor of the changes.

Based on the reasoning above, the feature that Priya should use to identify the editor of the modified cells is Track Changes. This feature will provide her with the information she needs about which cells were altered and by whom.