Exam 8: Excel: Developing an Excel Application

The default is to protect only the windows used to display a workbook.

Range names can be up to ____ characters.

____ messages appear as ScreenTips next to the active cell.

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

Once you protect a worksheet the locked property is enabled and controls whether or not a cell can be edited.

Protecting the ____________________ of a workbook prohibits users from moving resizing closing or hiding parts of the Excel window.

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

Range names must begin with ____.

When you lock a workbook you control the ability users have to make changes to the file.

You cannot prevent users from changing all of the formulas in a worksheet.

If your data is organized in a tabular format you can quickly create range names for each column or row in the list by using the ____ dialog box.

Input messages appear as ____________________ next to the active cell.

In the Allow list box in the Data Validation dialog box the ____ option means that the validation rule will be based on an Excel logical formula.

A digital ____________________ is often used to identify the author of a workbook that contains macros.

Comments like those in the accompanying figure are often used to ____.

The Visual Basic Editor is a separate application that works with Excel and all of the Office products to edit and manage VBA code.

A(n)____________________ is a spreadsheet written or tailored to meet the user's specific needs.

You can keep users from deleting worksheets or inserting new ones.