Question 1

When a workbook's structure is protected, users cannot ____ worksheets.
A) insert
B) delete
C) rename
D) all of the above

Accepted Answer

When a workbook's structure is protected, users cannot insert, delete or rename worksheets. Therefore, the best choice is D, which includes all three options.

Question 2

Protect and uprotect a workbook using the ____ dialog box.
A) Protect Structure and Windows
B) Data Validation
C) Protect Sheet
D) Format Cells

Accepted Answer

The correct dialog box for protecting and unprotecting a workbook is "Protect Structure and Windows." This option allows users to add or remove protection for the workbook structure and windows.

Question 3

You can use up to three levels of security and protection to control who can access and change your Excel data. These levels do NOT include ____.
A) worksheet protection
B) workbook protection
C) file protection
D) data table protection

Accepted Answer

The three levels of security and protection mentioned in the question are worksheet protection, workbook protection, and file protection. Data table protection is not one of the levels mentioned, and therefore is not included as an option.

Question 4

You can use ____ even for cells that allow any data values to be entered in them.
A) input messages
B) data messages
C) help messages
D) cell messages

Accepted Answer

Input messages can provide instructions or guidelines for entering data into a cell, even if the cell allows any data value. This can be helpful for promoting consistent data entry and reducing errors. Data messages, help messages, and cell messages may also be useful in certain situations, but they are not specifically designed to address the issue of allowing any data values to be entered.

Question 5

For optimal password security, Microsoft recommends that you always assign a password to open and view a file. Users who also have permission to modify data should then enter ____.
A) a second password
B) the same password
C) no password
D) a Microsoft-assigned password

Accepted Answer

Users who have permission to modify data should enter a second password for additional security. This ensures that even if someone gains access to the file with the first password, they still need to know the second password in order to make any changes to the data.

Question 6

To prevent data errors, you can ____ a workbook, which lets you control the changes users can make to it.
A) protect
B) save
C) guard
D) secure

Accepted Answer

Protecting a workbook allows you to prevent others from making changes to the data by locking specific cells, sheets, or the entire workbook. This helps to ensure that the data remains accurate and reliable. Saving, guarding, and securing a workbook do not necessarily provide the same level of protection against data errors.

Question 7

In addition to a helpful message that appears before users enter data, you can also display a(n) ____ message in a message box if users enter data that violates the cell's validation rule.
A) error alert
B) alarm
C) caution
D) stop and look

Accepted Answer

An error alert message box is the best choice to display if users enter data that violates the cell's validation rule. This helps to clearly communicate to the user that there is an issue with the data entered and prompts them to correct the error.

Question 8

If you set up the validation rule only, all future data entry in that cell is restricted to the values ____.
A) you have specified
B) Excel enters as a default
C) new users enter
D) none of the above

Accepted Answer

When you set up a validation rule, you are specifying the values that are allowed for data entry in that cell. Any future data entry will be restricted to these values only, and any other values will be rejected. Therefore, the correct answer is A) you have specified.

Question 9

By default, input messages appear as comments ____ when the cell is selected.
A) next to the cell
B) under the cell
C) on top of the cell
D) within the cell

Accepted Answer

Input messages designed to assist users in spreadsheet applications like Microsoft Excel appear next to the cell when it is selected, providing guidance or instructions related to the data expected in that cell.

Question 10

Using only a validation rule without ____ can frustrate users of the worksheet.
A) an input message
B) an error alert message
C) either a or b
D) neither a nor b

Accepted Answer

A validation rule alone may prevent users from entering invalid data, but without an input message or error alert message, they may not understand why their input isn't being accepted or how to correct their mistake. Providing both an input message and error alert message can improve user understanding and make the worksheet more user-friendly.

Question 11

You can protect a workbook by ____.
A) locking cells so that users cannot change their contents
B) hiding cells so that users cannot see them
C) preventing a worksheet from being deleted from a workbook
D) all of the above

Accepted Answer

All of the options mentioned in the choices can be used to protect a workbook. By locking cells, users cannot make any changes to the specific cells, and by hiding cells, users cannot view them. Preventing a worksheet from being deleted from a workbook can also be a way of protecting the data as accidentally deleting a worksheet can result in permanent loss of data. Hence, D is the correct choice.

Question 12

Which of the following is NOT one of the three tabs in the Data Validation dialog box?
A) Settings
B) Input Message
C) Error Alert
D) Audit

Accepted Answer

The three tabs in the Data Validation dialog box are Settings, Input Message, and Error Alert. There is no tab labeled Audit.

Question 13

When you protect a workbook, you can secure the ____.
A) workbook structure
B) workbook windows
C) both a and b
D) neither a nor b

Accepted Answer

When you protect a workbook, you have the option to secure both the workbook structure, which prevents users from adding or deleting sheets and also hiding or renaming them, and the workbook windows, which prevents users from resizing or moving them. Choosing both options provides the maximum level of security for the workbook.

Question 14

If you protect a worksheet, users cannot change ____.
A) any data
B) any formulas
C) both a and b
D) neither a nor b

Accepted Answer

Protecting a worksheet prevents users from changing both the data and formulas present in the worksheet.

Question 15

You use the Error Alert tab in the ____ dialog box to specify error alert styles and messages.
A) Data Validation
B) Formulas
C) Data
D) View

Accepted Answer

The Error Alert tab is a part of the Data Validation dialog box, which allows you to specify rules for data entry in a cell or range of cells.

Question 16

To reinforce the ____ rule, you can set up an error alert message for a cell.
A) validation
B) step-through
C) data
D) input

Accepted Answer

The validation rule allows you to set up specific criteria for a cell, such as only allowing positive numbers or limiting the length of text. If a user enters data that violates the validation rule, an error alert message can be set up to remind the user of the rule and prompt them to correct their input.

Question 17

If you want to prohibit workbook users from adding, renaming, or deleting worksheets in a workbook, you can enable ____ protection.
A) workbook
B) worksheet
C) data table
D) user data

Accepted Answer

Workbook protection is the correct choice because it allows you to prevent users from making structural changes to the workbook, such as adding, renaming, or deleting worksheets.

Question 18

The data validation rule called ____ value is the default setting for cells.
A) Any
B) Whole number
C) Decimal
D) List

Accepted Answer

The "Any" value is the default data validation rule for cells, meaning any data can be entered into the cell without restriction.

Question 19

To allow users to edit some cells while preventing them from changing others, you ____ the cells you want users to access and then protect the worksheet.
A) unlock
B) lock
C) protect
D) unprotect

Accepted Answer

Cells in Excel are locked by default. To allow users to edit specific cells, you must first unlock these cells and then protect the worksheet to prevent changes to other cells.

Question 20

Which of the following is NOT one of the three available error alert styles for a cell?
A) Stop
B) Warning
C) Information
D) Help

Accepted Answer

The three available error alert styles for a cell are Stop, Warning, and Information. "Help" is not one of the available error alert styles.

Quiz 10: Troubleshooting Workbooks and Automating Excel Applications

When a workbook's structure is protected, users cannot ____ worksheets.

Protect and uprotect a workbook using the ____ dialog box.

You can use up to three levels of security and protection to control who can access and change your Excel data. These levels do NOT include ____.

You can use ____ even for cells that allow any data values to be entered in them.

For optimal password security, Microsoft recommends that you always assign a password to open and view a file. Users who also have permission to modify data should then enter ____.

To prevent data errors, you can ____ a workbook, which lets you control the changes users can make to it.

In addition to a helpful message that appears before users enter data, you can also display a(n) ____ message in a message box if users enter data that violates the cell's validation rule.

If you set up the validation rule only, all future data entry in that cell is restricted to the values ____.

By default, input messages appear as comments ____ when the cell is selected.

Using only a validation rule without ____ can frustrate users of the worksheet.

You can protect a workbook by ____.

Which of the following is NOT one of the three tabs in the Data Validation dialog box?

When you protect a workbook, you can secure the ____.

If you protect a worksheet, users cannot change ____.

You use the Error Alert tab in the ____ dialog box to specify error alert styles and messages.

To reinforce the ____ rule, you can set up an error alert message for a cell.

If you want to prohibit workbook users from adding, renaming, or deleting worksheets in a workbook, you can enable ____ protection.

The data validation rule called ____ value is the default setting for cells.

To allow users to edit some cells while preventing them from changing others, you ____ the cells you want users to access and then protect the worksheet.

Which of the following is NOT one of the three available error alert styles for a cell?