Exam 8: Excel: Developing an Excel Application

The ____________________ alert by default rejects the invalid data but allows you to override the rejection.

Most ____ are not harmful and do not affect data in any way.

Any blanks or parentheses in a row or column label will be changed to ____ in defined names.

Clicking the Edit button in the accompanying figure opens the New Name dialog box in which you can modify the selected defined name.

Data validation can verify data that was entered into a worksheet before the validation criteria were applied.

A(n)____ message provides additional information about the type of data expected for the cell.

Using defined names like the kind shown in the accompanying figure makes creating and understanding a(n)____ easier.

To remove workbook protection click the Unprotect Workbook button in the ____ group on the Review tab.

The Name box lists all of the names currently defined in the workbook including Excel table names.

In the City_State_Zip field name shown in the accompanying figure the underscores replace ____ in the label name.

A digital ____ is like a seal of approval.

A protected sheet can always be unprotected but you can also require users to enter a(n)____________________ before the protection is removed.

One way of reducing the chance of data-entry error is to display a(n)____ message when a user clicks on the cell.

To create a macro you can write one by entering a series of commands in the ____ programming language.

Applications typically include an interface to assist the user in using the system ranging from special buttons that assist in existing specific tasks to changing the entire Excel interface with customized ____.

When you find an error in a macro all of the following are options EXCEPT ____.

Each macro must have a unique name.

You use the Rules tab in the Data Validation dialog box to enter the validation rules for an active cell.