Exam 10: Troubleshooting Workbooks and Automating Excel Applications

In general, an Excel application supports your decisions by allowing you to perform what-if ____________________ and other types of data analysis to model business situations.

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

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

To read a comment, you point to a cell with ____ to display its comment.

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

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

The error message #NAME? indicates ____.

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.

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

You can create an Excel macro by using the macro recorder to record your keystrokes and mouse actions as you perform them.

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

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

If you protect a worksheet, users cannot change ____.

As part of his new job, Seth has created a Projected Income worksheet for his company. He wants to prohibit users from changing the formulas in the Projected Income worksheet, while allowing them to change values such as unit sales and unit price. Seth has also imported a worksheet named Sales History, which contains sales information for sunglasses for the last year. -Seth wants to understand Excel's default settings. He realizes that the workbook's default setting includes which of the following?

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

The formula auditing tool called ____________________ displays tracer arrows that indicate which cells affect the value of the currently selected cell.

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

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

When you choose ____, Excel disables all macros and security alerts about macros in documents that are not stored in a trusted location.

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. -Elianna clicks on the cell containing the #NAME? error. To find out more about this error, what type of dialog box should she open?