Exam 10: Troubleshooting Workbooks and Automating Excel Applications

Most of Excel's error-checking rules are disabled by default.

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

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

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 has included a Print Formulas button on the worksheet. This button links to ____.

The formula auditing tool called ____________________ displays tracer arrows that indicate which cells affect the value of the currently selected cell.

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.

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

To read a comment, you point to a cell with ____ to display its comment.

A #VALUE! error in a worksheet cell indicates ____.

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

____ tracer arrows point to another cell that provides data for the active cell.

For optimal password security, Microsoft recommends that you always assign a password to open and view a file.

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

The words End Sub indicate the end of the ____.

You can create an Excel macro by using the macro recorder to record your keystrokes and mouse actions as you perform them.

By default, input messages appear as comments ____ when the cell is selected.

By default, every cell in a worksheet is unlocked.

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 click the Circle Invalid Data command on the Data Validation menu to find and mark cells containing data that does not meet validation criteria.

The data validation rule called ____ value is the default setting for cells.