Question 1

It is a good coding practice to write code in ____________________ text.

Accepted Answer

The answer of It is a good coding practice to...

Question 2

The default project name given to new projects is ____.

Accepted Answer

A)  VBObject 
B)  NewProject 
C)  Project 
D)  VBAProject 
A)  VBObject 
B)  NewProject 
C)  Project 
D)  VBAProject

Question 3

The VBA code "SUM(A1:A4)".Formula = Range("A5")changes the formula of cell A5 to sum up the values in the range A1:A4.

Accepted Answer

A) True 
 B)False

Question 4

You can quickly switch to the Visual Basic Editor by pressing the Shift+Alt keys.

Accepted Answer

A) True 
 B)False

Question 5

The ____________________ window displays the VBA macro code associated with any item in the Project Explorer.

Accepted Answer

The answer of The ____________________ window displays the VBA macro...

Question 6

In Excel,ChartObject refers to a chart embedded within a worksheet._________________________

Accepted Answer

A) True 
 B)False

Question 7

When the Visual Basic Editor opens it usually displays ____ windows.

Accepted Answer

A)  three 
B)  six 
C)  seven 
D)  eight 
A)  three 
B)  six 
C)  seven 
D)  eight

Question 8

The most commonly used ____ operators are the And and Or operators.

Accepted Answer

A)  conditional 
B)  logical 
C)  key 
D)  concatenation 
A)  conditional 
B)  logical 
C)  key 
D)  concatenation

Question 9

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-In this control structure,one set of commands is run if the condition is true and a different set of commands is run if the condition is false

Accepted Answer

A) project 
B) object 
C) property 
D) module 
E) comment
F)method
G)variable
H)control structure
I)If-Then-Else
J)If-Then-ElseIf
K)comparison
L)logical 
A) project 
B) object 
C) property 
D) module 
E) comment
F)method
G)variable
H)control structure
I)If-Then-Else
J)If-Then-ElseIf
K)comparison
L)logical

Question 10

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Any element within the Excel working environment

Accepted Answer

A) project 
B) object 
C) property 
D) module 
E) comment
F)method
G)variable
H)control structure
I)If-Then-Else
J)If-Then-ElseIf
K)comparison
L)logical 
A) project 
B) object 
C) property 
D) module 
E) comment
F)method
G)variable
H)control structure
I)If-Then-Else
J)If-Then-ElseIf
K)comparison
L)logical

Question 11

A(n)____ is a collection of macros,worksheets,data entry forms,and other items that make up a customized application.

Accepted Answer

A)  window 
B)  project 
C)  object 
D)  applet 
A)  window 
B)  project 
C)  object 
D)  applet

Question 12

The VBA code Range("A1").____ Text:="Total Assets" adds the comment "Total Assets" to cell A1.

Accepted Answer

A)  Select 
B)  AddComment 
C)  Text 
D)  Properties 
A)  Select 
B)  AddComment 
C)  Text 
D)  Properties

Question 13

You can open the Immediate window in the accompanying figure by pressing the ____ keys in the Visual Basic Editor.

Accepted Answer

A)  Ctrl+A 
B)  Ctrl+G 
C)  Shift+A 
D)  Alt+I 
A)  Ctrl+A 
B)  Ctrl+G 
C)  Shift+A 
D)  Alt+I

Question 14

In the Excel ____________________,VBA organizes objects and object collections in a hierarchy with the Excel application at the top and the individual cells of a workbook at the bottom.

Accepted Answer

The answer of In the Excel ____________________,VBA organizes objects and...

Question 15

A(n)____________________ operator is a symbol used to compare one value with another.

Accepted Answer

The answer of A(n)____________________ operator is a symbol used to...

Question 16

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-An action that can be performed on an object

Accepted Answer

A) project 
B) object 
C) property 
D) module 
E) comment
F)method
G)variable
H)control structure
I)If-Then-Else
J)If-Then-ElseIf
K)comparison
L)logical 
A) project 
B) object 
C) property 
D) module 
E) comment
F)method
G)variable
H)control structure
I)If-Then-Else
J)If-Then-ElseIf
K)comparison
L)logical

Question 17

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Statement that describes the behavior or purpose of a procedure

Accepted Answer

A) project 
B) object 
C) property 
D) module 
E) comment
F)method
G)variable
H)control structure
I)If-Then-Else
J)If-Then-ElseIf
K)comparison
L)logical 
A) project 
B) object 
C) property 
D) module 
E) comment
F)method
G)variable
H)control structure
I)If-Then-Else
J)If-Then-ElseIf
K)comparison
L)logical

Question 18

A module is a collection of VBA ____________________.

Accepted Answer

The answer of A module is a collection of VBA...

Question 19

Unlike Windows Explorer,Project Explorer does not allow you to view your project components hierarchically.

Accepted Answer

A) True 
 B)False

Question 20

A(n)____ structure is a series of commands that evaluates conditions in your program and then directs the program to perform certain actions based on the status of those conditions.

Accepted Answer

A)  evaluation 
B)  control 
C)  append 
D)  conditional 
A)  evaluation 
B)  control 
C)  append 
D)  conditional

It is a good coding practice to write code in ____________________ text.

The default project name given to new projects is ____.

The VBA code "SUM(A1:A4)".Formula = Range("A5")changes the formula of cell A5 to sum up the values in the range A1:A4.

You can quickly switch to the Visual Basic Editor by pressing the Shift+Alt keys.

The ____________________ window displays the VBA macro code associated with any item in the Project Explorer.

In Excel,ChartObject refers to a chart embedded within a worksheet._________________________

When the Visual Basic Editor opens it usually displays ____ windows.

The most commonly used ____ operators are the And and Or operators.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -In this control structure,one set of commands is run if the condition is true and a different set of commands is run if the condition is false

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Any element within the Excel working environment

A(n)____ is a collection of macros,worksheets,data entry forms,and other items that make up a customized application.

The VBA code Range("A1").____ Text:="Total Assets" adds the comment "Total Assets" to cell A1.

You can open the Immediate window in the accompanying figure by pressing the ____ keys in the Visual Basic Editor.

In the Excel ____________________,VBA organizes objects and object collections in a hierarchy with the Excel application at the top and the individual cells of a workbook at the bottom.

A(n)____________________ operator is a symbol used to compare one value with another.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -An action that can be performed on an object

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Statement that describes the behavior or purpose of a procedure

A module is a collection of VBA ____________________.

Unlike Windows Explorer,Project Explorer does not allow you to view your project components hierarchically.

A(n)____ structure is a series of commands that evaluates conditions in your program and then directs the program to perform certain actions based on the status of those conditions.

Getting Started With Excel

Formatting a Workbook

Working With Formulas and Functions

Enhancing a Workbook With Charts and Graphs

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

Managing Multiple Worksheets and Workbooks

Using Advanced Functions and Conditional Formatting

Developing an Excel Application

Working With Financial Tools and Functions

Performing What-If Analyses

Connecting to External Data

Managing Your Files

Getting Started With Microsoft Office 2010

Filters

Exam 12: Expanding Excel With Visual Basic for Applications

It is a good coding practice to write code in ____________________ text.

The default project name given to new projects is ____.

The VBA code "SUM(A1:A4)".Formula = Range("A5")changes the formula of cell A5 to sum up the values in the range A1:A4.

You can quickly switch to the Visual Basic Editor by pressing the Shift+Alt keys.

The ____________________ window displays the VBA macro code associated with any item in the Project Explorer.

In Excel,ChartObject refers to a chart embedded within a worksheet._________________________

When the Visual Basic Editor opens it usually displays ____ windows.

The most commonly used ____ operators are the And and Or operators.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -In this control structure,one set of commands is run if the condition is true and a different set of commands is run if the condition is false

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Any element within the Excel working environment

A(n)____ is a collection of macros,worksheets,data entry forms,and other items that make up a customized application.

The VBA code Range("A1").____ Text:="Total Assets" adds the comment "Total Assets" to cell A1.

You can open the Immediate window in the accompanying figure by pressing the ____ keys in the Visual Basic Editor.

In the Excel ____________________,VBA organizes objects and object collections in a hierarchy with the Excel application at the top and the individual cells of a workbook at the bottom.

A(n)____________________ operator is a symbol used to compare one value with another.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -An action that can be performed on an object

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Statement that describes the behavior or purpose of a procedure

A module is a collection of VBA ____________________.

Unlike Windows Explorer,Project Explorer does not allow you to view your project components hierarchically.

A(n)____ structure is a series of commands that evaluates conditions in your program and then directs the program to perform certain actions based on the status of those conditions.

Getting Started With Excel

Formatting a Workbook

Working With Formulas and Functions

Enhancing a Workbook With Charts and Graphs

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

Managing Multiple Worksheets and Workbooks

Using Advanced Functions and Conditional Formatting

Developing an Excel Application

Working With Financial Tools and Functions

Performing What-If Analyses

Connecting to External Data

Managing Your Files

Getting Started With Microsoft Office 2010

Filters