Question 1

The ____________________ alert by default rejects the invalid data but allows you to override the rejection.

Accepted Answer

The answer of The ____________________ alert by default rejects the...

Question 2

Most ____ are not harmful and do not affect data in any way.

Accepted Answer

A) viruses 
B) macro viruses 
C) Trojan horses 
D) all of the above

Question 3

Any blanks or parentheses in a row or column label will be changed to ____ in defined names.

Accepted Answer

A) ampersands 
B) underscore characters 
C) hyphens 
D) dashes

Question 4

Clicking the Edit button in the accompanying figure opens the New Name dialog box in which you can modify the selected defined name.

Accepted Answer

A) True 
 B)False

Question 5

Data validation can verify data that was entered into a worksheet before the validation criteria were applied.

Accepted Answer

A) True 
 B)False

Question 6

A(n)____ message provides additional information about the type of data expected for the cell.

Accepted Answer

A) user 
B) key 
C) input 
D) value

Question 7

Using defined names like the kind shown in the accompanying figure makes creating and understanding a(n)____ easier.

Accepted Answer

A) index 
B) log 
C) formula 
D) All of the above

Question 8

To remove workbook protection click the Unprotect Workbook button in the ____ group on the Review tab.

Accepted Answer

A) Format 
B) Changes 
C) Sheet 
D) Options

Question 9

The Name box lists all of the names currently defined in the workbook including Excel table names.

Accepted Answer

A) True 
 B)False

Question 10

In the City_State_Zip field name shown in the accompanying figure the underscores replace ____ in the label name.

Accepted Answer

A) spaces 
B) periods 
C) commas 
D) numbers

Question 11

Match between columns
                        Premises: Confirms that a macro or document has not been altered

Accepted Answer

The Answer of digital signature and validation rule and Information is...

Question 12

A digital ____ is like a seal of approval.

Accepted Answer

A) affidavit 
B) clause 
C) signature 
D) salutation

Question 13

A protected sheet can always be unprotected but you can also require users to enter a(n)____________________ before the protection is removed.

Accepted Answer

The answer of A protected sheet can always be unprotected...

Question 14

Match between columns
                        Premises: Word or string of characters associated with a single cell or a range

Accepted Answer

The Answer of Information and VBA and Warning and validation is...

Question 15

One way of reducing the chance of data-entry error is to display a(n)____ message when a user clicks on the cell.

Accepted Answer

A) value 
B) input 
C) key 
D) user

Question 16

To create a macro you can write one by entering a series of commands in the ____ programming language.

Accepted Answer

A) HTML 
B) Java 
C) VBA 
D) Perl

Question 17

Applications typically include an interface to assist the user in using the system ranging from special buttons that assist in existing specific tasks to changing the entire Excel interface with customized ____.

Accepted Answer

A) commands 
B) menus 
C) functions 
D) all of the above

Question 18

When you find an error in a macro all of the following are options EXCEPT ____.

Accepted Answer

A) rerecord the macro using the same macro name 
B) delete the recorded macro and then record the macro again 
C) recopy the macro from the macro library 
D) run the macro one step at a time to locate the problem and then correct it

Question 19

Each macro must have a unique name.

Accepted Answer

A) True 
 B)False

Question 20

You use the Rules tab in the Data Validation dialog box to enter the validation rules for an active cell.

Accepted Answer

A) True 
 B)False

Exam 8: Excel: Developing an Excel Application

The ____________________ alert by default rejects the invalid data but allows you to override the rejection.

Most ____ are not harmful and do not affect data in any way.

Any blanks or parentheses in a row or column label will be changed to ____ in defined names.

Clicking the Edit button in the accompanying figure opens the New Name dialog box in which you can modify the selected defined name.

Data validation can verify data that was entered into a worksheet before the validation criteria were applied.

A(n) ____ message provides additional information about the type of data expected for the cell.

Using defined names like the kind shown in the accompanying figure makes creating and understanding a(n) ____ easier.

To remove workbook protection click the Unprotect Workbook button in the ____ group on the Review tab.

The Name box lists all of the names currently defined in the workbook including Excel table names.

In the City_State_Zip field name shown in the accompanying figure the underscores replace ____ in the label name.

Identify the letter of the choice that best matches the phrase or definition.

A digital ____ is like a seal of approval.

A protected sheet can always be unprotected but you can also require users to enter a(n)____________________ before the protection is removed.

Identify the letter of the choice that best matches the phrase or definition.

One way of reducing the chance of data-entry error is to display a(n) ____ message when a user clicks on the cell.

To create a macro you can write one by entering a series of commands in the ____ programming language.

Applications typically include an interface to assist the user in using the system ranging from special buttons that assist in existing specific tasks to changing the entire Excel interface with customized ____.

When you find an error in a macro all of the following are options EXCEPT ____.

Each macro must have a unique name.

You use the Rules tab in the Data Validation dialog box to enter the validation rules for an active cell.