Question 1

Cells with comments have blue indicator triangles in the upper-right corner. _________________________

Accepted Answer

red

Question 2

To prevent users from storing inaccurate data in a worksheet, you can include a(n) ____.

Accepted Answer

The best choice to prevent users from storing inaccurate data in a worksheet is to include an error alert message. This will notify the user of any errors or inconsistencies in the data they are entering and prompt them to correct it, thereby reducing the likelihood of inaccuracies being stored in the worksheet. Worksheet protection and file protection messages are related to security features and limiting access to the worksheet or file, and error detection warnings may not necessarily prevent inaccuracies from being stored if the user does not take action to correct them.

Question 3

When #DIV/0! appears in a cell, you know that a formula is trying to divide by the value 10, which cannot be done. _________________________

Accepted Answer

0
zero

Question 4

A(n) digital certificate should contain a digital signature, which confirms that the signer created the macro and that the macro has not been changed since its digital certificate was created. _________________________

Accepted Answer

A digital certificate does contain a digital signature, which is used to confirm both the identity of the signer and that the macro has not been altered since the certificate was issued.

Question 5

If you do not want others to view data in a worksheet but you want to retain the information, you can freeze a row or a column. _________________________

Accepted Answer

hide

Question 6

False positives are items that are incorrect but are not flagged as such. _________________________

Accepted Answer

negatives

Question 7

To help minimize the errors users make as they enter data into worksheets, Excel provides a ____ tool.

Accepted Answer

Data validation is a tool in Excel that allows users to restrict the type of data that can be entered into specific cells. This helps to minimize errors and ensure consistency in the data entered. The other options, data, data message, and data-entry, are not specific tools in Excel for minimizing data entry errors.

Question 8

A(n) ____ rule can specify a range of acceptable values, such as those between 1 and 100 or those in a particular list of values.

Accepted Answer

A validation rule can specify a range of acceptable values for input data, ensuring that data entered into a system meets established criteria. This helps to prevent incorrect or invalid data from being entered into the system.

Question 9

To help prevent a user from entering data that doesn't satisfy the validation rule for a cell, you can display a(n) ____ message that identifies the kind of data the user should enter.

Accepted Answer

An input message in spreadsheet programs like Microsoft Excel can be displayed to guide users on what type of data they should enter in a cell, helping to prevent invalid data entry based on the cell's validation rules.

Question 10

The formula auditing tool called Internal References allows you to step through a set of cells that directly or indirectly refer to themselves. _________________________

Accepted Answer

Circular

Question 11

Macro viruses are viruses that are written and stored as macros attached to documents created in Office programs such as Excel, and run when you open an infected document. _________________________

Accepted Answer

Macro viruses are indeed viruses that are written and stored as macros attached to documents created in Office programs such as Excel, and run when you open an infected document.

Question 12

An Error Alert button names the type of error, and lets you access the Excel Help tool or edit the formula in the Format Bar. _________________________

Accepted Answer

Formula

Question 13

An error alarm is a message box that displays a message of varying severity. _________________________

Accepted Answer

alert

Question 14

You access the data validation tool by clicking the DATA tab on the ribbon, and then clicking Data Validation in the ____ group to open the Data Validation dialog box.

Accepted Answer

The data validation tool is located in the Data Tools group on the DATA tab in the ribbon. Therefore, choice A is the correct answer. Choice B is partially correct, as it refers to the tab where the data validation tool can be found, but it does not specify the exact group. Choice C and D are incorrect, as they do not relate to the location of the data validation tool.

Question 15

You should protect your entire workbook file with a(n) passkey for optimal security. _________________________

Accepted Answer

password

Question 16

By default, input messages appear as comments next to the cell when the cell is selected. _________________________

Accepted Answer

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

Question 17

Excel applications are workbooks that you design so that others can use them in a relatively error-free manner. _________________________

Accepted Answer

Excel applications are specifically designed to reduce errors and make it easier for others to use the workbook.

Question 18

A(n) scenario support system is a type of information system that helps managers model business situations, especially through what-if analysis. _________________________

Accepted Answer

Decision Support System (DSS)
DSS (Decision Support System)
Decision Support System
DSS

Question 19

A(n) dependent cell uses the value in the active cell in its formula. _________________________

Accepted Answer

Dependent cells refer to cells that rely on other cells to provide them with data. Therefore, a dependent cell will use the value in the active cell in its formula.

Question 20

To help prevent a user from entering data that doesn't satisfy the validation rule for a cell, you can display a(n) output message that identifies the kind of data the user should enter. _________________________

Accepted Answer

input

Quiz 10: Troubleshooting Workbooks and Automating Excel Applications