Exam 10: Troubleshooting Workbooks and Automating Excel Applications

Cells with comments have blue indicator triangles in the upper-right corner. _________________________

One way to make a workbook easier to use is to automate repetitive or difficult tasks. To do so, you can use ____.

You can create a macro that can ____.

Excel applications are workbooks that you design so that others can use them in a relatively error-free manner. _________________________

The Data Validation Rule called Text length restricts formulas to a specified length.

VBA calls macros sub procedures, and starts each sub procedure name with Sub, followed by its descriptive name and a pair of ____________________.

Using only a validation rule without ____ can frustrate users of the worksheet.

To unprotect a workbook, on the REVIEW tab on the ribbon, click the Protect Workbook button in the ____ group, and then deselect the necessary check boxes.

Protect and uprotect a workbook using the ____ dialog box.

A(n) scenario support system is a type of information system that helps managers model business situations, especially through what-if analysis. _________________________

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

To prevent users from storing inaccurate data in a worksheet, you can include a(n) ____.

If you double-click the cell containing a formula with an error, Excel displays color-coded borders around related cells.

When you choose ____, Excel allows all macros to run.

When text is included inside quotation marks, it is treated as a ____.

If you know a document came from a trustworthy source and contains only safe macros, you can store it in a trusted location, allowing any macros in it to run without being checked by security settings in the ____________________.

A(n) ____________________ cell contains a formula that refers to other cells.

When Excel runs a macro, it performs the actions specified by the macro's ____.

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

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.