Exam 8: Excel: Developing an Excel Application

In VBA macros are called ____ procedures.

The Excel data ____ feature restricts data entry to follow a defined set of rules.

In the Allow list box in the Data Validation dialog box the ____ option means that the cell will accept only text of a specified number of characters.

In the Allow list box in the Data Validation dialog box the ____ option means that the cell will accept any type of numeric value.

One way to ensure that correct data is entered into a cell or range is to use the Excel data ____ feature.

Defined names are automatically substituted for the cell addresses in a formula.

You can allow users to insert new rows or columns into a sheet even if the sheet is protected.

The ____ Reference button controls how Excel records the act of selecting a range in the worksheet.

A macro can be stored in ____.

The ____ Center is a central location for all the security settings in Office 2007.

When you open a file with macros the response you see is based on the security level set on the computer.

To open the ____ dialog box click the Data tab on the Ribbon and then click Data Validation in the Data Tools group.

Each sub procedure in VBA begins with the keyword "Sub" followed by the name of the sub procedure and a set of ____.

The active cell in the accompanying figure is ____.

Sometimes when you build a worksheet for other users you may decide to add a(n)____ message to a cell even if you don't validate the data in that cell.

By default a macro will select the same cells regardless of which cell is first selected because the macro records a selection using relative cell references.

A digital certificate confirms that the macro created by the signer has not been altered since the digital certificate was created.

To move the box you would drag the selection handle of the comment in the accompanying figure.