Exam 8: Excel: Developing an Excel Application

The ____ alert accepts the invalid data but still allows you to cancel the data entry.

Which of the following is a valid function name?

Each cell can have at most three validation rules.

One way to run a macro is to assign it to a(n)button that is placed directly on the worksheet.

When a workbook is protected such that options to modify the worksheet are no longer available what do the corresponding commands on the shortcut menu look like?

To open the Protect Sheet dialog box click the Review tab on the Ribbon and then click the Protect Sheet button in the ____________________ group.

When you protect a sheet unless you are concerned the users will turn off protection and make changes to formulas it is probably best not to specify a ____.

If content is blocked the ____ located under the Ribbon appears notifying you that some content was disabled.

Even when the worksheet is unprotected the locked property determines whether or not changes can be made to a given cell.

The ____ box displays all of the names in the workbook.

The most direct way to create defined names like the kind shown in the accompanying figure is to use the ____ box on the formula bar.

To view the code of a macro you need to open the Visual Basic ____.

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

In the Allow list box in the Data Validation dialog box the ____________________ option means that the cell will accept any value entered into the cell.

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

The ____ Macro workbook is a hidden workbook opened whenever you start Excel making its macros available anytime you use Excel.

Using the Excel data validation feature you can specify the ____ of data.

If you want to return to the Visual Basic Editor you can select one of the macros in the VBE dialog box and click the Edit button again.

A(n)____________________ is a text box that is attached to a specific cell in a worksheet.