Question 1

One way to ensure that correct data is entered into a cell or range is to use the Excel data ____________________ feature.

Accepted Answer

The answer of One way to ensure that correct data...

Question 2

Cell and range$\underline { \text { references } }$ do not indicate what data is stored in those cells._________________________

Accepted Answer

A) True 
 B)False

Question 3

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Appears when the cell becomes active and can be used to specify the type of data the user should enter in that cell

Accepted Answer

A) Stop 
B) Warning 
C) Information 
D) locked 
E) macro
F)VBA
G)defined name
H)input message
I)validation rule
J)digital certificate 
A) Stop 
B) Warning 
C) Information 
D) locked 
E) macro
F)VBA
G)defined name
H)input message
I)validation rule
J)digital certificate

Question 4

Input messages appear as ____________________ next to the active cell.

Accepted Answer

The answer of Input messages appear as ____________________ next to...

Question 5

If a _____ error appears when you run a macro that has worked in the past,some part of the macro code no longer makes sense to Excel.

Accepted Answer

A) syntax 
B) run-time 
C) logic 
D) baseline 
A) syntax 
B) run-time 
C) logic 
D) baseline

Question 6

Range names must begin with _____.

Accepted Answer

A) a letter or an underscore 
B) a number 
C) a hash tag 
D) an asterisk 
A) a letter or an underscore 
B) a number 
C) a hash tag 
D) an asterisk

Question 7

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Error alert that prevents you from storing the data in the cell

Accepted Answer

A) Stop 
B) Warning 
C) Information 
D) locked 
E) macro
F)VBA
G)defined name
H)input message
I)validation rule
J)digital certificate 
A) Stop 
B) Warning 
C) Information 
D) locked 
E) macro
F)VBA
G)defined name
H)input message
I)validation rule
J)digital certificate

Question 8

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

Accepted Answer

A) Information 
B) Stop 
C) Security 
D) Warning 
A) Information 
B) Stop 
C) Security 
D) Warning

Question 9

After the comments,in VBA code the next item is the _____ of the macro.

Accepted Answer

A) module 
B) body 
C) procedure 
D) command 
A) module 
B) body 
C) procedure 
D) command

Question 10

A(n)____________________ is a series of stored commands that can be run whenever you need to perform a task.

Accepted Answer

The answer of A(n)____________________ is a series of stored commands...

Question 11

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

Accepted Answer

A) skeleton 
B) structure 
C) format 
D) location 
A) skeleton 
B) structure 
C) format 
D) location

Question 12

One way to ensure that correct data is entered into a cell or range is to use the Excel data _____ feature.

Accepted Answer

A) validation 
B) concatenation 
C) security 
D) index 
A) validation 
B) concatenation 
C) security 
D) index

Question 13

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 invalid data,but...

Question 14

A _____ can be destructive and can modify or delete files that may not be recoverable.

Accepted Answer

A) digital signature 
B) macro virus 
C) comment virus 
D) micro virus 
A) digital signature 
B) macro virus 
C) comment virus 
D) micro virus

Question 15

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

Accepted Answer

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

Question 16

_____ messages appear as ScreenTips next to the active cell.

Accepted Answer

A) Value 
B) Input 
C) Key 
D) User 
A) Value 
B) Input 
C) Key 
D) User

Question 17

-You can use the Name Manager dialog box,shown in the accompanying figure,to create a defined name.

Accepted Answer

A) True 
 B)False

Question 18

The Stop alert prevents an entry from being stored in the cell.

Accepted Answer

A) True 
 B)False

Question 19

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

Accepted Answer

A) INSERT 
B) DEVELOPER 
C) LAYOUT 
D) MACRO 
A) INSERT 
B) DEVELOPER 
C) LAYOUT 
D) MACRO

Question 20

The _____ Center is a central location for all the security settings in Office.

Accepted Answer

A) Secure 
B) Security 
C) Trust 
D) Protection 
A) Secure 
B) Security 
C) Trust 
D) Protection

One way to ensure that correct data is entered into a cell or range is to use the Excel data ____________________ feature.

Cell and range $\underline { \text { references } }$ do not indicate what data is stored in those cells._________________________

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Appears when the cell becomes active and can be used to specify the type of data the user should enter in that cell

Input messages appear as ____________________ next to the active cell.

If a _____ error appears when you run a macro that has worked in the past,some part of the macro code no longer makes sense to Excel.

Range names must begin with _____.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Error alert that prevents you from storing the data in the cell

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

After the comments,in VBA code the next item is the _____ of the macro.

A(n)____________________ is a series of stored commands that can be run whenever you need to perform a task.

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

One way to ensure that correct data is entered into a cell or range is to use the Excel data _____ feature.

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

A _____ can be destructive and can modify or delete files that may not be recoverable.

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

_____ messages appear as ScreenTips next to the active cell.

-You can use the Name Manager dialog box,shown in the accompanying figure,to create a defined name.

The Stop alert prevents an entry from being stored in the cell.

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

The _____ Center is a central location for all the security settings in Office.

Getting Started With Excel

Formatting Workbook Text and Data

Calculating Data With Formulas and Functions

Analyzing and Charting Financial Data

Working With Excel Tables, Pivot-tables, and Pivot-charts

Managing Multiple Worksheets and Workbooks

Working With Advanced Functions

Exploring Financial Tools and Functions

Performing What If Analyses

Connecting to External Data

Collaborating on a Shared Workbook

Managing Your Files

Filters

Exam 7: Developing an Excel Application

One way to ensure that correct data is entered into a cell or range is to use the Excel data ____________________ feature.

Cell and range references ‾\underline { \text { references } } references ​ do not indicate what data is stored in those cells._________________________

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Appears when the cell becomes active and can be used to specify the type of data the user should enter in that cell

Input messages appear as ____________________ next to the active cell.

If a _____ error appears when you run a macro that has worked in the past,some part of the macro code no longer makes sense to Excel.

Range names must begin with _____.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Error alert that prevents you from storing the data in the cell

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

After the comments,in VBA code the next item is the _____ of the macro.

A(n)____________________ is a series of stored commands that can be run whenever you need to perform a task.

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

One way to ensure that correct data is entered into a cell or range is to use the Excel data _____ feature.

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

A _____ can be destructive and can modify or delete files that may not be recoverable.

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

_____ messages appear as ScreenTips next to the active cell.

-You can use the Name Manager dialog box,shown in the accompanying figure,to create a defined name.

The Stop alert prevents an entry from being stored in the cell.

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

The _____ Center is a central location for all the security settings in Office.

Getting Started With Excel

Formatting Workbook Text and Data

Calculating Data With Formulas and Functions

Analyzing and Charting Financial Data

Working With Excel Tables, Pivot-tables, and Pivot-charts

Managing Multiple Worksheets and Workbooks

Working With Advanced Functions

Exploring Financial Tools and Functions

Performing What If Analyses

Connecting to External Data

Collaborating on a Shared Workbook

Managing Your Files

Filters

Cell and range $\underline { \text { references } }$ do not indicate what data is stored in those cells._________________________