Exam 10: Troubleshooting Workbooks and Automating Excel Applications

You can obtain a(n) ____________________ from a commercial certification authority or, in some cases, from your system administrator.

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.

The error message #NAME? indicates ____.

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

To work with advanced macro features, the ____ tab must be displayed on the ribbon.

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

New or casual Excel users usually prefer to create a macro using the ____, an excellent choice for automating tasks that you perform using the keyboard or mouse.

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

When you choose ____, Excel disables all macros except macros that are digitally signed and are from an already trusted publisher.

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

You can assign a macro to a(n) ____________________, which is a combination of keystrokes you press to run the macro.

After you record a macro, you can run it in two ways: press the shortcut key assigned to the macro, or use the ____.

A macro is set to display the formulas in the active window. To disable this setting, the code _____ can be used.

Common formula errors include ____.

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

MATCHING Identify the letter of the choice that best matches the tools listed above. -Watch Window

All Excel ____________________, including the ones you record, consist of VBA code.

____________________ protection protects the contents of a worksheet to prevent anyone from changing, moving, or deleting its data.

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

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. -Elianna opens the Data Validation dialog box. What options will she be able to change using this dialog box?