Deck 22: Protecting, Tracking, and Sharing Workbooks

Question 1

Passwords for a workbook are case sensitive.

Answer 1

True

Question 2

To protect your Excel data from unwanted changes, you can add ____ protection to worksheets and workbooks.

A) username
B) password
C) database
D) tracking

Answer 2

B

Question 3

With the Track Changes feature enabled, a(n) border will appear around the changed cells until the file is closed.

Answer 3

True

Question 4

Excel tracks changes to worksheet names and formats applied to cells or data.

Question 5

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

Question 6

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

Question 7

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

A) Password
B) Protect Sheet
C) Worksheet Password
D) Share Worksheet

Question 8

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

Question 9

If you add password protection to individual worksheets, only the people who know the password can make changes to them.

Question 10

If you want to keep track of the changes made in a workbook, you can enable the ____ feature.

A) Track Changes
B) Password
C) Encryption
D) Decryption

Question 11

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

A) Data
B) Home
C) Review
D) Insert

Question 12

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

Question 13

Anyone can open and view a workbook that is password protected.

Question 14

When an unauthorized person tries to pry into a(n) decrypted file, they will only see unreadable text and symbols.

Question 15

Changes can be made to a worksheet that is password protected.

Question 16

When you have a worksheet that several people have access to, you run the risk of unwanted changes.

Question 17

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

Question 18

You can add ____ protection to an entire workbook.

A) track name
B) username
C) password
D) watermark

Question 19

In a shared workbook, changes are marked with a border as they are when the Track Changes feature is used.

Question 20

When you make changes to a shared workbook, Excel keeps track of the changes.

Question 21

Figure EX 16-1 To see the options shown in Figure EX 16-1 above, you first need to click the ____ tab.

A) File
B) Home
C) Review
D) View

Question 22

The Unprotect Worksheet button is found on the ____ tab.

A) Data
B) Home
C) Layout
D) Review

Question 23

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

A) Track Changes
B) Encrypt Changes
C) Protect Sheet
D) Encrypt Document

Question 24

You click the ____ button to select the Encrypt with Password option.

A) Save Options
B) Encryption
C) Track Changes
D) Protect Workbook

Question 25

The Share Workbook button is found on the ____ tab.

A) Home
B) Data
C) View
D) Review

Question 26

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

A) shadow
B) information icon
C) border
D) error message

Question 27

If someone tries to open a password-protected workbook, he or she will first be prompted to enter the ____ in a dialog box.

A) file name
B) author name
C) list of changes
D) password

Question 28

To prevent changes to a worksheet, you can protect it with a(n) ____________________.

Question 29

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

A) Home
B) File
C) Review
D) Data

Question 30

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

A) end
B) disable
C) enable
D) start

Question 31

The Track Changes arrow button is found on the ____ tab.

A) Data
B) Home
C) File
D) Review

Question 32

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.

A) Protect Sheet
B) Password Protect
C) Encrypt Document
D) Encrypt Sheet

Question 33

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. To make sure that there are no unwanted or unauthorized changes to the main sheet of the workbook, George can use the ____ dialog box.

A) Protect Sheet
B) Password Protect
C) Encrypt Document
D) Encrypt Sheet

Question 34

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

A) protected
B) synchronized
C) encrypted
D) shared

Question 35

When you password-protect a workbook, you are ____ the file.

A) decrypting
B) synchronizing
C) charting
D) encrypting

Question 36

The ____ tab in the Share Workbook dialog box gives you several options for managing workbook changes.

A) Advanced
B) Options
C) Manage
D) Data

Question 37

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, ____.

A) the change that is made first is accepted
B) the change that is made last is accepted
C) the data in the cell is not changed
D) Excel provides a prompt that allows the conflict to be resolved

Question 38

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

A) decrypting
B) encrypting
C) transferring
D) synchronizing

Question 39

To prevent a workbook from being opened by an unauthorized person, you can ____-protect a workbook.

A) password
B) change
C) share
D) network

Question 40

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.

A) template
B) shared
C) reserved
D) remote

Question 41

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

Question 43

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

Question 44

If you place your mouse pointer over a highlighted cell in a workbook with the Track Changes feature enabled, a(n) ____________________ will appear showing information about the change.

Question 45

Explain what the Track Changes feature does and discuss the reasons for using this feature.

Question 46

You enable the Share Workbook feature using the ____________________ dialog box.