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

1. Blank Workbook
2. Shared Workbook
3. Template
4. Macro-Enabled Workbook

Answer :

Final answer:

To enable Track Changes in Excel 2016, you must use a Shared Workbook. Hence, correct answer is 2.

Explanation:

In Excel 2016, to enable Track Changes, you must use a Shared Workbook. This functionality allows multiple users to edit the workbook simultaneously, and it keeps a record of who made changes, what those changes were, and when they were made.

It's important to note that Track Changes is not available in a regular Blank Workbook, Template, or Macro-Enabled Workbook if it has not been shared.

When opening a workbook with macros, Excel will present a security warning under the Ribbon, cautioning you about the risks of enabling content, as macros can contain harmful code. If you encounter this warning, you should understand the implications of enabling macros and adjust your security settings appropriately.

To utilize macros fully or to use Excel's advanced features such as Track Changes, ensure that you are working with the correct type of workbook.

For further assistance with Excel functions and security settings, you can visit Excel's main support page at support.office.com.