Question 1

In a _____ loop,the macro executes the loop until the condition is true.

Accepted Answer

Do-Until
Explanation: The Do-Until loop

Question 2

You view and edit VBA macros using the Function procedure.

Accepted Answer

A) True 
 B)False

Question 3

In VBA,which of the following logical operators performs the function of negation on an expression?

Accepted Answer

A) XoR 
B) Or 
C) Imp 
D) Not 
A) XoR 
B) Or 
C) Imp 
D) Not

Question 4

Which of the following is a built-in function in Excel and does not require a macro?

Accepted Answer

A) Inserting a company name on all spreadsheets 
B) Creating a custom toolbar button 
C) Performing a specific calculation on multiple workbooks 
D) Computing Sum and Average 
A) Inserting a company name on all spreadsheets 
B) Creating a custom toolbar button 
C) Performing a specific calculation on multiple workbooks 
D) Computing Sum and Average

Question 5

A VBA macro can be used to print your company name and logo at the top of all worksheets.

Accepted Answer

A) True 
 B)False

Question 6

VBA is:

Accepted Answer

A) a programming language developed by Microsoft to extend and customize Excel. 
B) a graphical user interface that allows a novice Excel user to build complex worksheets. 
C) a programming environment built by a non-profit group of programmers that can be used with Excel. 
D) a programming environment developed by Microsoft that can be used instead of Excel and Access for complex applications. 
A) a programming language developed by Microsoft to extend and customize Excel. 
B) a graphical user interface that allows a novice Excel user to build complex worksheets. 
C) a programming environment built by a non-profit group of programmers that can be used with Excel. 
D) a programming environment developed by Microsoft that can be used instead of Excel and Access for complex applications.

Question 7

In the context of the precedence order for operators in VBA,_____ has the highest precedence.

Accepted Answer

expone ntiation
Explanation: Operators p

Question 8

Which of the following is true about the Project Explorer window?

Accepted Answer

A) It is most useful for executing VBA statements directly. 
B) It contains VBA code. 
C) It displays a tree diagram that consists of every workbook currently open in Excel. 
D) It shows you the properties that can be changed for the currently active object in the Project Explorer window. 
A) It is most useful for executing VBA statements directly. 
B) It contains VBA code. 
C) It displays a tree diagram that consists of every workbook currently open in Excel. 
D) It shows you the properties that can be changed for the currently active object in the Project Explorer window.

Question 9

Which of the following VBA windows shows every workbook that is currently open in Excel?

Accepted Answer

A) The Project Explorer Window 
B) The Code Window 
C) The Properties Window 
D) The Immediate Window 
A) The Project Explorer Window 
B) The Code Window 
C) The Properties Window 
D) The Immediate Window

Question 10

When working in VBE,an object is considered as a collection of projects.

Accepted Answer

A) True 
 B)False

Question 11

To assign a value to a variable,you must use the equal sign operator.

Accepted Answer

A) True 
 B)False

Question 12

In VBA,which of the following logical operators performs the function of exclusion on two expressions?

Accepted Answer

A) And 
B) Eqv 
C) XoR 
D) Imp 
A) And 
B) Eqv 
C) XoR 
D) Imp

Question 13

Which of the following VBA windows will you use to debug your VBA code?

Accepted Answer

A) The Project Explorer Window 
B) The Code Window 
C) The Properties Window 
D) The Immediate Window 
A) The Project Explorer Window 
B) The Code Window 
C) The Properties Window 
D) The Immediate Window

Question 14

Which of the following data type uses 2 bytes and whose range of values is true or false?

Accepted Answer

A) Boolean 
B) Integer 
C) Double (negative) 
D) Double (positive) 
A) Boolean 
B) Integer 
C) Double (negative) 
D) Double (positive)

Question 15

Which of the following statements is true of a user defined function?

Accepted Answer

A) It can be written when the function needed is already in Excel. 
B) It can increase the complexity of a worksheet. 
C) It can increase productivity. 
D) It can be recorded in a macro recorder. 
A) It can be written when the function needed is already in Excel. 
B) It can increase the complexity of a worksheet. 
C) It can increase productivity. 
D) It can be recorded in a macro recorder.

Question 16

Which of the following keys will you press to activate the VBE when Excel is active?

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 17

A(n)_____ data type uses 2 bytes and its range of values is True or False.

Accepted Answer

Boolean
Explanation: Data types are the

Question 18

A Sub procedure is a VBA macro that returns a single value.

Accepted Answer

A) True 
 B)False

Question 19

In VBA,which of the following logical operators performs the function of disjunction on two expressions?

Accepted Answer

A) Not 
B) Or 
C) And 
D) XoR 
A) Not 
B) Or 
C) And 
D) XoR

Question 20

Which of the following does a VBA macro manipulate?

Accepted Answer

A) A constant 
B) A variable 
C) An object 
D) A sub macro 
A) A constant 
B) A variable 
C) An object 
D) A sub macro

Exam 22: Programming in Excel With VBA

In a _____ loop,the macro executes the loop until the condition is true.

You view and edit VBA macros using the Function procedure.

In VBA,which of the following logical operators performs the function of negation on an expression?

Which of the following is a built-in function in Excel and does not require a macro?

A VBA macro can be used to print your company name and logo at the top of all worksheets.

VBA is:

In the context of the precedence order for operators in VBA,_____ has the highest precedence.

Which of the following is true about the Project Explorer window?

Which of the following VBA windows shows every workbook that is currently open in Excel?

When working in VBE,an object is considered as a collection of projects.

To assign a value to a variable,you must use the equal sign operator.

In VBA,which of the following logical operators performs the function of exclusion on two expressions?

Which of the following VBA windows will you use to debug your VBA code?

Which of the following data type uses 2 bytes and whose range of values is true or false?

Which of the following statements is true of a user defined function?

Which of the following keys will you press to activate the VBE when Excel is active?

A(n)_____ data type uses 2 bytes and its range of values is True or False.

A Sub procedure is a VBA macro that returns a single value.

In VBA,which of the following logical operators performs the function of disjunction on two expressions?

Which of the following does a VBA macro manipulate?

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