Exam 10: Troubleshooting Workbooks and Automating Excel Applications

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 now wants to check for errors. A first step would be to look at those cells with a ____.

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.

By entering a variety of input data and comparing the results to output you have already calculated outside the worksheet, you can use ____ analysis to indirectly verify the validity of your worksheet.

Which of the following is NOT one of the three tabs in the Data Validation dialog box?

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

The words End Sub indicate the end of the ____.

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

To view the code of a macro, you open the ____, a separate program that works with Excel and other Office applications and lets you work with VBA code.

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

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

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

You click the Circle Invalid Data command on the Data Validation menu to find and mark cells containing data that does not meet validation criteria.

Backups of important Excel files should be stored or maintained _____.

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

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 is ready to edit one of the macros in the worksheet. To do this, she opens the ____.

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. -What entry should Elianna have in the cell returning the #NAME? error?

Which of the following is NOT one of the three available error alert styles for a cell?

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

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

To save and run a macro in an Excel workbook, it must be saved as a macro-enabled workbook, giving it a(n) ____________________ extension.