Developing an Excel Application

Which of the following is NOT a valid defined name?

Range names can be up to _____ characters.

The _____ dialog box displays all of the names in the workbook

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

Which of the following tabs in the Data Validation dialog box allows you to set validation criteria?

_____ messages appear as ScreenTips next to the active cell.

The following are Excel-supported error alert types: _____.

Every cell in a workbook has a(n) _____ property that determines whether or not changes can be made to that cell

Protecting the _____ prohibits users from renaming, deleting, hiding, or inserting worksheets.

To create a macro, you can enter a series of commands in the _____ programming language.

You can turn off the macro recorder by clicking the Stop Recording button in the Code group on the _____ tab.

To save a workbook with macros, the default Excel Workbook format needs to change to a macro-enabled workbook, which has the _____ file extension.

Which of the following can Rina tell when she opens a digitally signed file?

When you reference a cell or range in a different worksheet, the ____ separates the sheet reference from the cell reference.

When you reference cells and ranges in other worksheets, if the worksheet name contains spaces, you must enclose the sheet name in ____.