Exam 8: Excel: Developing an Excel Application

A macro ____________________ uses a program's own macro programming language for distribution.

The frequency of error alert determines what choices the user is presented with when an invalid entry is attempted.

After the first character in a range name which of the following is acceptable?

Which of the following are Excel-supported error alert types?

In the Allow list box in the Data Validation dialog box the ____________________ option means that the cell will accept only times.

Protecting the ____ of a workbook keeps users from modifying the worksheets themselves.

You control how Excel handles suspect macros by setting Excel's ____________________.

The current data in the ParkingFee cell according to the accompanying figure is ____.

If you change the definition of a range name pointing it to a different range the value of any formula using that range name will be updated automatically to reflect the new definition.

In addition to referring to cells by their cell references it is easier to remember where different data is stored by assigning a descriptive ____________________ like the kind shown in the accompanying figure to each cell or range.

The least severe error alert is the ____ alert.

A(n)____ certificate is another name for a digital ID.

Sub procedures are organized into ____.

By default the locked property is turned off for each cell when you protect a workbook.

For cell and range names names of 25 to 50 characters are considered practical although names can be up to 255 characters.

By default users are only allowed to select ____ cells in a protected worksheet.

In the Allow list box in the Data Validation dialog box the ____ option means that the cell will accept only values from a list.

In the Allow list box in the Data Validation dialog box the ____ option means that the cell will accept only dates.

Which of the following is a tab in the Data Validation dialog box?