Exam 10: Troubleshooting Workbooks and Automating Excel Applications

When printing worksheet formulas, especially for the purposes of documentation, it is very helpful to set the print options to ____.

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

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

In VBA, comments appear in green and start with a(n) ____.

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.

You can create an Excel macro by ____.

Excel assumes that any text in a formula is either a command word, such as a function name, or a reference to a cell, such as a named range.

The steps you want to automate are stored as ____ commands in the macro, and are performed in sequence when you run the macro.

A(n) ____________________ is a note that you attach to a cell, separate from other cell content.

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

A(n) ____________________ cell contains a value that is used in a formula in the active cell.

You control how Excel handles macros that are not stored in trusted locations by choosing one of four macro settings in its Trust Center. Please list and describe each of the four settings.

Case 10-2 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. -In order for Seth to allow others to enter data into some of the cells in the worksheet but not others, he should ____.

The data validation tool restricts data being entered and data already stored in the worksheet.

A(n) ____________________ is a series of commands that you store and then run when you need to perform a task.

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

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

You control how Excel handles macros that are not stored in trusted locations by choosing Macro Settings in the ____.

The formula auditing tool called Evaluate Formula displays the different parts of a nested formula, evaluated in the order the formula is written.

You can protect a workbook by ____.