Exam 22: Protecting, Tracking, and Sharing Workbooks

To add password protection to a worksheet, the ____ dialog box is used.

When a file is protected , several people can make changes to the workbook at the same time.

You enable the Track Changes feature by clicking a check box in the ____________________ dialog box.

When you remove the password protection, you are ____ the workbook.

When Track Changes is enabled, cells that have been changed appear with a(n) ____.

The Protect Sheet button is found on the ____ tab on the Ribbon.

Case EX 16-2 Wendy is the Human Resources manager for a company that has offices in two locations. The employee data is stored in an Excel workbook. To maximize efficiency and productivity, Wendy feels that it is important that employees in the Human Resources department of both offices are able to work on the workbook simultaneously. She needs to make the workbook a ____ workbook.

Once password protection is removed from a worksheet, it cannot be added to the worksheet again.

Passwords for a workbook are case sensitive.

If the Track Changes feature is enabled, it makes the workbook a(n) shared file.

Case EX 16-1 George is the manager of a party planning company. He uses an Excel workbook to keep track of the parties that the company is planning or has planned in the past. George is concerned about a competitor gaining access to the information in the workbook. If George wants to make sure that only people who have the proper password can open the workbook, he needs to use the ____ dialog box.

When you ____ Track Changes, the workbook will no longer be shared.

If you decide that you no longer need to track changes in a workbook, you can disable the ____________________ feature.

Case EX 16-2 Wendy is the Human Resources manager for a company that has offices in two locations. The employee data is stored in an Excel workbook. If a conflict arises from employees in the different offices making changes to the same cell, ____.

When Track Changes is enabled, Excel identifies the name of the person who made the change and the date of the change.

As you review changes made to cells in a workbook with Track Changes enabled, you can accept or deny the changes.

The Unprotect Worksheet button is found on the ____ tab.

With a(n) ____ workbook, changes made by multiple users are tracked.

Figure EX 16-1 Clicking the Encrypt with Password option shown in Figure EX 16-1 above opens the ____ dialog box.

The Protect Workbook button is located in the Info section of the ____ window.