Exam 10: Troubleshooting Workbooks and Automating Excel Applications

When you choose ____, Excel disables all macros but retains security alerts about macros in documents that are not stored in a trusted location.

By default, input messages appear as comments next to the cell when the cell is selected. _________________________

MATCHING Identify the letter of the choice that best matches the tools listed above. -Show Formulas

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

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

If you want to prohibit workbook users from adding, renaming, or deleting worksheets in a workbook, you can enable ____ protection.

MATCHING Identify the letter of the choice that best matches the tools listed above. -Evaluate Formula

Protect and uprotect a workbook using the ____ dialog box.

____ is a program that is attached to a file and runs when you open the file. It can harm your computer by changing program settings or deleting hard disk files.

Displaying an input message when a user clicks a cell is a helpful way to let the user know what type of data to enter in the cell.

An error alarm is a message box that displays a message of varying severity. _________________________

When you trace dependent cells, you trace the components of a formula that references other cells.

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

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

A(n) ____________________ is a system that is used to collect, organize, and process data, and to communicate and distribute the results in a coordinated manner.

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

A ____ worksheet usually contains the workbook title, creation date, name of the person who created the workbook, and any other information that describes the purpose and content of the workbook.

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.

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

You can use up to three levels of security and protection to control who can access and change your Excel data. Please describe two of the three levels and how you access each of them.