Question 1

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 available error alert styles for a cell in Excel are Stop, Warning, and Information. Help is not an option.

Question 2

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

A second password is recommended for users who have permission to modify data, providing an additional layer of security beyond just opening and viewing the file.

Question 3

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 4

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 5

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 specific criteria for data entry in a cell. An error alert message can be set up to reinforce this rule and ensure that users enter data that meets the specified criteria. The other options (step-through, data, input) do not relate directly to setting up an error alert message for a cell.

Question 6

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

Setting up a validation rule restricts future data entry in the cell to only the values specified. It does not affect any previous data entered in the cell.

Question 7

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

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

Question 8

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 limit and control the changes that can be made to it, preventing data errors and maintaining data integrity. Saving, guarding, and securing a workbook do not necessarily provide the same level of control over user changes.

Question 9

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 provided are ways to protect a workbook. Locking cells prevents users from changing the cell contents, hiding cells stops users from viewing the data, and preventing a worksheet from being deleted maintains the structure of the workbook. Therefore, the best choice is D, which includes all options.

Question 10

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 are all related to Excel files, specifically worksheet protection, workbook protection, and file protection. Data table protection is not one of the three mentioned levels.

Question 11

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

Accepted Answer

Any value is the default setting for cells, meaning that the cell will accept any type of data (text, numbers, dates, etc.) unless a specific data validation rule is applied.

Question 12

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 without an input message or an error alert message can be frustrating for users as they may not understand why their input is being rejected. An input message can provide guidance to the user on what type of input is expected, while an error alert message can explain why the input was rejected and how to correct it. Therefore, it is best to include both an input message and an error alert message along with the validation rule.

Question 13

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 14

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 and workbook windows. Protecting workbook structure prevents users from adding, deleting, hiding, or moving worksheets within the workbook. Protecting workbook windows prevents users from resizing, moving, or closing workbook windows.

Question 15

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

When you protect a worksheet, by default all cells are locked, which means users cannot change any data or formulas. Therefore, the correct option is C, as it includes both A and B.

Question 16

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 17

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 used for specifying error alert styles and messages in the Data Validation dialog box.

Question 18

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 19

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 is the most appropriate response when users enter data that violates the cell's validation rule. An error alert indicates to the user that the data entered is invalid, and provides information on how to correct the problem. Alarm, caution, and stop-and-look messages are not specific enough in describing the nature of the error.

Question 20

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 as all these actions involve changing the structure of the workbook.

Quiz 10: Troubleshooting Workbooks and Automating Excel Applications

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

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

Protect and uprotect a workbook using the ____ dialog box.

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

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

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

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

You can protect a workbook by ____.

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

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

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

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

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

If you protect a worksheet, users cannot change ____.

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

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

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

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.

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