Exam 10: Troubleshooting Workbooks and Automating Excel Applications

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

It is best to include a workbook's filename, worksheet name, and date on cell formula printouts that are used for documentation. The worksheet's ____ is a handy location for this kind of information.

You can immediately fix the #### error by ____.

A(n) dependent cell uses the value in the active cell in its formula. _________________________

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

For optimal password security, Microsoft recommends that you always assign a password to open and view a file. Users who also have permission to modify data should then enter ____.

If you protect a worksheet, users cannot change ____.

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. -Seth wants to understand Excel's default settings. He realizes that the workbook's default setting includes which of the following?

To achieve a gross profit, an item's COGS should always be less than the sales price.

An Error Alert button names the type of error, and lets you access the Excel Help tool or edit the formula in the Format Bar. _________________________

One way to correct a macro is to run the macro one step at a time by opening the Macro dialog box, clicking the macro you want to delete, and then clicking the ____ button. After you identify the step causing the problems, record the macro again.

EPS is the amount of ____________________ that has been earned by each share on average, which measures the earning power of the product.

EPS is calculated by dividing the number of shares outstanding by net income.

An Error Alert button appears on tracer arrows and ____.

Cell formula printouts also serve as a backup for workbooks.

You can use the ____ button in the Formula Auditing group to identify parts of a formula that reference other cells.

____________________ refers to all the records that describe how and why a system has been developed, and how it should be used.

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

Incorrect positives are items that are incorrect but are not flagged as such. _________________________