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

Step 1: Understanding the feature to track edits.
The "Track Changes" feature in spreadsheet applications allows users to track and identify modifications made to the document. It shows who made the changes and what modifications were made, making it easier to review collaborative edits.
Step 2: Analyzing the options.

• (A) Data Validation: Incorrect. Data validation restricts the type of data entered into cells, but it does not track changes or identify the editor.
• (B) Track Changes: Correct. The "Track Changes" feature enables users to identify who made the changes and which cells were modified.
• (C) Observe Changes: Incorrect. "Observe Changes" is not a standard feature in spreadsheet software.
• (D) AutoFilter: Incorrect. AutoFilter is used to filter and view subsets of data, but it does not track changes or identify editors.

Step 3: Conclusion.
Therefore, the correct answer is (B) Track Changes, as it helps Priya identify who made the changes in the shared spreadsheet. Final Answer:} Track Changes.