Exam 10: Troubleshooting Workbooks and Automating Excel Applications

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

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

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.

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.

Macro ____ consist(s) of 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.

MATCHING Identify the letter of the choice that best matches the tools listed above. -formula auditing tools

Case 10-1 Elianna has put together the Projected Income worksheet above. She is finalizing the worksheet for a presentation to her company's board of directors. When needed, please refer to the figure above as you answer the questions below. -Under Assumptions, Elianna accidentally clears the entry for COGS, 300%, and she wants to recreate it. She only wants data entered as a percentage between 0 and 1. She also knows that several top managers throughout the company will be entering the data. What could Elianna do to guide them?

A trusted location is usually any computer that is used only by one person.

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

You can press the ____ keyboard combination to display the formula in the cell.

If a cell contains an error-indicator triangle in its upper-left corner, you can click the cell to display the ____ button.

An Excel application can be a DSS, a tool that helps managers or other users make decisions or solve problems.

The default setting for error alert messages is ____________________, which tells the user the entry is incorrect and must be canceled or corrected before continuing.

When you trace dependent cells, you trace the components of a formula that references other cells.

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

____ data is input data for which you already know the results.

A(n) ____________________ can specify the type of data that is appropriate to be entered into a cell, such as whole numbers, decimal numbers, dates, time, or text.

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

Hiding a row or column affects the data and any formulas that reference a hidden cell.

____________________ are items that are flagged as incorrect but are, in fact, correct.