In Excel 2016, which type of workbook do you have to use to enable Track Changes?

1) Shared Workbook
2) Personal Workbook
3) Protected Workbook
4) Read-Only Workbook

Answer :

Final answer:

In Excel 2016, Track Changes can only be enabled when working with a Shared Workbook. This feature allows for a collaborative editing environment and can track who made specific changes to the document.

Explanation:

In Excel 2016, to enable Track Changes, you must use a Shared Workbook. To prevent changes from being saved as edits, you would go to the tools ribbon and toggle Track Changes to off. If you wish to view all changes, you can open the Reviewing Pane from the tools ribbon. This allows you to see a panel that displays all changes. Also, you can navigate to a specific revision by clicking on the revision within this panel.

Remember that when using Track Changes in a Shared Workbook, multiple users can edit the workbook simultaneously, and it's possible for you to see who made which changes. This feature is crucial for collaborative work where accountability and tracking of edits are required.

a Shared Workbook is essential for utilizing Track Changes, offering a way to manage edits collaboratively while maintaining a clear alteration history.