Question

A group of users can perform certain operations on a shared workbook. Which option helps them to update and track changes in the shared workbook? The ­­­­­­option allows all group members to update information and track changes in the workbook.

Answer 1

The “Allow changes by more than one user at the same time” option.

In a group of users, it is very important to create a shared workbook so that several people are able to update information and track changes in the workbook at the same time. To do so, one should click on the review tab of the excel sheet and select share workbook. On the editing tab of the share workbook dialog box, select the Allow changes by more than one user at the same time check box. Go ahead and click the advanced tab and select option you would want to use and then click OK