Exam 10: Troubleshooting Workbooks and Automating Excel Applications

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.

MATCHING Identify the letter of the choice that best matches the tools listed above. -Show Formulas

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 textbook suggested that before using the formula auditing tools, you take the following three steps: fix obvious errors; use the Error Alert button; and examine the formula. Please briefly describe each of these steps.

MATCHING Identify the letter of the choice that best matches the tools listed above. -Trace Dependents

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

Documentation can be descriptions of the system, checklists, flowcharts, and other hard-copy documents, as well as notations built into the system itself.

The formula auditing tool called ____ toggles between displaying formulas or results of formulas in the worksheet.

A ____ worksheet usually contains the workbook title, creation date, name of the person who created the workbook, and any other information that describes the purpose and content of the workbook.

A virus can harm your computer by changing your program settings, for example, or deleting files on your hard disk.

____ tracer arrows indicate that a precedent cell contains an error.

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

VBA interprets ____ as "ignore these lines of text" because these lines do not contain commands that Excel should perform.

MATCHING Identify the letter of the choice that best matches the tools listed above. -Remove Arrows menu

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.

The Excel formula auditing tools help you troubleshoot formula problems by letting you review the ____ of a formula.

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

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.

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

The ____ on the blue tracer arrow indicate that certain cells are precedent cells for other cells.