Question 1

It is permissible to use spaces when assigning variable names.

Accepted Answer

A) True 
 B)False  False

Question 2

VBA stands for Virtual Basic for Applications.

Accepted Answer

A) True 
 B)False  False

Question 3

VBA is only a programming language and not a macro language.

Accepted Answer

A) True 
 B)False  False

Question 4

The quickest way to activate the Visual Basic Editor (VBE)is to press _____ when Excel is active.

Accepted Answer

Alt + F11
Explanation: The quickest way

Question 5

Which of the following is true about Function procedures?

Accepted Answer

A) Function procedures return a single value. 
B) The end of a Function procedure is marked by the keyword End Sub. 
C) The macro recorder can produce Function procedures. 
D) Function procedures refer to one or more information statements that you provide to VBA. 
A) Function procedures return a single value. 
B) The end of a Function procedure is marked by the keyword End Sub. 
C) The macro recorder can produce Function procedures. 
D) Function procedures refer to one or more information statements that you provide to VBA.

Question 6

Which of the following VBA structures is recommended in a decision involving three or more options?

Accepted Answer

A) If-Then 
B) Select-Case 
C) Looping 
D) Do-While 
A) If-Then 
B) Select-Case 
C) Looping 
D) Do-While

Question 7

In VBA,_____ are declared with a specified number of characters.

Accepted Answer

fixed-length strings
Explanati

Question 8

Visual Basic for Applications (VBA)manipulates ____,such as a workbook,a worksheet,a cell range,a chart,or a shape.

Accepted Answer

objects
Explanation: VBA manip

Question 9

Which of the following operators has the highest precedence in VBA?

Accepted Answer

A) Division 
B) Addition 
C) Multiplication 
D) Exponentiation 
A) Division 
B) Addition 
C) Multiplication 
D) Exponentiation

Question 10

When working on a worksheet,Ben was editing his macros using the Visual Basic Editor (VBE).After a while he wanted to go back to the Excel application interface.Which of the following key(s)should Ben use to toggle between the Excel application interface and the VBE?

Accepted Answer

A) Ctrl+F9 
B) Ctrl+V 
C) Alt+F11 
D) Alt+V 
A) Ctrl+F9 
B) Ctrl+V 
C) Alt+F11 
D) Alt+V

Question 11

An assignment statement is a VBA statement that assigns the result of an expression to a variable or an object.

Accepted Answer

A) True 
 B)False

Question 12

The macro recorder can only produce _____ procedures.

Accepted Answer

Sub
Explanation: In VBA,macros

Question 13

Units of VBA code are often referred to as ____.

Accepted Answer

A) subroutines 
B) routines 
C) macros 
D) programs 
A) subroutines 
B) routines 
C) macros 
D) programs

Question 14

Variable-length strings theoretically can hold as many as 2 billion characters.

Accepted Answer

A) True 
 B)False

Question 15

Which of the following elements of VBA programming may change during the execution of a procedure?

Accepted Answer

A) A constant 
B) A variable 
C) A comment 
D) A macro 
A) A constant 
B) A variable 
C) A comment 
D) A macro

Question 16

Which of the following key(s)will display the Immediate Window if it is not visible on the VBE Program Window?

Accepted Answer

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

Question 17

A(n)_____ is a VBA statement that assigns the result of an expression to a variable or an object.

Accepted Answer

assignment statement
Explanati

Question 18

Units of VBA code are called ____.

Accepted Answer

macros
Explanation: Units of V

Question 19

In a Do-While loop,the macro executes the loop until the condition is true.

Accepted Answer

A) True 
 B)False

Question 20

Which of the following is true about the Do-Until loop structure?

Accepted Answer

A) In a Do-Until loop,the macro executes the loop until the condition is false. 
B) A Do-Until loop continues until a specified condition is met. 
C) A Do-Until loop is the simplest type of loop. 
D) A Do-Until loop is similar to the Do-While structure. 
A) In a Do-Until loop,the macro executes the loop until the condition is false. 
B) A Do-Until loop continues until a specified condition is met. 
C) A Do-Until loop is the simplest type of loop. 
D) A Do-Until loop is similar to the Do-While structure.

Exam 22: Programming in Excel With VBA

It is permissible to use spaces when assigning variable names.

VBA stands for Virtual Basic for Applications.

VBA is only a programming language and not a macro language.

The quickest way to activate the Visual Basic Editor (VBE)is to press _____ when Excel is active.

Which of the following is true about Function procedures?

Which of the following VBA structures is recommended in a decision involving three or more options?

In VBA,_____ are declared with a specified number of characters.

Visual Basic for Applications (VBA)manipulates ____,such as a workbook,a worksheet,a cell range,a chart,or a shape.

Which of the following operators has the highest precedence in VBA?

When working on a worksheet,Ben was editing his macros using the Visual Basic Editor (VBE).After a while he wanted to go back to the Excel application interface.Which of the following key(s)should Ben use to toggle between the Excel application interface and the VBE?

An assignment statement is a VBA statement that assigns the result of an expression to a variable or an object.

The macro recorder can only produce _____ procedures.

Units of VBA code are often referred to as ____.

Variable-length strings theoretically can hold as many as 2 billion characters.

Which of the following elements of VBA programming may change during the execution of a procedure?

Which of the following key(s)will display the Immediate Window if it is not visible on the VBE Program Window?

A(n)_____ is a VBA statement that assigns the result of an expression to a variable or an object.

Units of VBA code are called ____.

In a Do-While loop,the macro executes the loop until the condition is true.

Which of the following is true about the Do-Until loop structure?

The Information Age in Which You Live: Changing the Face of Business

Major Business Initiatives: Gaining Competitive Advantage With It

Databases and Data Warehouses: Supporting the Analytics-Driven Organization

Analytics, Decision Support, and Artificial Intelligence: Brain-Power for Your Business

Electronic Commerce: Strategies for the New Economy

Systems Development: Phases, Tools, and Techniques

Infrastructure, Cloud Computing, Metrics, and Business Continuity Planning: Building and Sustaining the Dynamic Enterprise

Protecting People and Information: Threats and Safeguards

Emerging Trends and Technologies: Business, People, and Technology Tomorrow

Computer Hardware and Software

The World Wide Web and the Internet

Designing Databases and Entity-Relationship Diagramming

Decision Analysis With Spreadsheet Software

Network Basics

Building a Web Page With Html

Object-Oriented Technologies

Computer Crime and Digital Forensics

Building an E-Portfolio

Implementing a Database With Microsoft Access

Careers in Business

Building Web Sites With Front-page

Filters