Automating Workbook Functionality

Question 1

Which section of the Data Validation dialog box allows a user to establish criteria?

Revolt · Accepted Answer

Settings

Question 2

What is the purpose of the Input Message feature?

Revolt · Accepted Answer

to inform a user that data validation has been established

Question 3

What does the #NULL error in a cell mean?

Revolt · Accepted Answer

The answer does not exist.

Question 4

What is the default security setting for macros?

Revolt · Accepted Answer

disable all macros with notification

Question 5

What program in Excel allows you to edit, record, and write your own macros?

Revolt · Accepted Answer

Visual Basic for Applications

Question 6

What characters can be included in a macro name? Check all that apply.lettersnumbersspacesunderscoressymbols

Revolt · Accepted Answer

letters; numbers; underscores

Question 7

What is the purpose of saving a macro to your Personal Macro Workbook?

Revolt · Accepted Answer

The saved macros are available to be added to any workbook.

Automating Workbook Functionality Answers