Exam 14: Visual Basic for Applications

It is best to group your Sub procedures together by what they do into separate modules,renaming the module appropriately to describe the kind of procedures it contains.

(True/False)

4.9/5

(37)

Question 41

The Project Explorer window is where all the VBA code is typed and also where VBA generated by a recorded macro can be viewed and edited.

(True/False)

4.8/5

(35)

Question 42

A(n)________ is an action initiated either by a user or by VBA code.

(Short Answer)

4.8/5

(34)

Question 43

There are two primary types of procedures which are supported by Visual Basic: a Sub procedure and a ________ procedure.

(Multiple Choice)

4.8/5

(35)

Question 44

With the VBA ________ control structure there is virtually no limit to the commands and logic that can be applied.

(Short Answer)

4.8/5

(36)

Question 45

You need to take extra steps to keep the code legible and to document what steps you are taking and why.

(True/False)

4.8/5

(29)

Question 46

When using the ________,the code is executed one line at a time to make it easier to identify the exact point that the run-time error occurs.

(Short Answer)

4.9/5

(29)

Question 47

An object model consists of a(n)________ collection of objects,consisting of properties,methods,and events that can be manipulated using VBA.

(Short Answer)

4.8/5

(34)

Question 48

With the VBA ________ control structure there is virtually no limit to the commands and logic that can be applied.

(Multiple Choice)

4.8/5

(39)

Question 49

________ are used to execute a series of statements multiple times.

(Short Answer)

4.8/5

(35)

Question 50

A(n)________ at the workbook level would be when a user opens or closes a workbook.

(Multiple Choice)

4.9/5

(33)

Question 51

Within the Visual Basic Editor,the ________ window reveals a list of all the properties of a selected object,like size and color.

(Multiple Choice)

4.9/5

(38)

Question 52

An object model consists of a hierarchical collection of objects,consisting of properties,methods,and events that can be manipulated using VBA.

(True/False)

5.0/5

(30)

Question 53

________ programming uses a hierarchy of objects,also called classes,as the focus of the programming.

(Short Answer)

4.8/5

(36)

Question 54

________ are defined as attributes of an object that can be manipulated using Visual Basic.

(Multiple Choice)

4.8/5

(37)

Question 55

A(n)________ performs an action on your project or workbook,such as renaming a worksheet or clearing filtered values from PivotTables.

(Short Answer)

4.9/5

(37)

Question 56

The two primary types of procedures that are supported by VBA are Sub procedures and module procedures.

(True/False)

4.7/5

(35)

Question 57

The ________ loops until a specified number of loops have been completed.

(Multiple Choice)

4.9/5

(43)

Question 58

All of the following statements are TRUE regarding loops in VBA EXCEPT:

(Multiple Choice)

4.9/5

(34)

Question 59

Which type of model below BEST describes a hierarchical collection of items that can be manipulated when using Visual Basic?

(Multiple Choice)

4.8/5

(34)

Question 60

Showing 41 - 60 of 99

It is best to group your Sub procedures together by what they do into separate modules,renaming the module appropriately to describe the kind of procedures it contains.

The Project Explorer window is where all the VBA code is typed and also where VBA generated by a recorded macro can be viewed and edited.

A(n)________ is an action initiated either by a user or by VBA code.

There are two primary types of procedures which are supported by Visual Basic: a Sub procedure and a ________ procedure.

With the VBA ________ control structure there is virtually no limit to the commands and logic that can be applied.

You need to take extra steps to keep the code legible and to document what steps you are taking and why.

When using the ________,the code is executed one line at a time to make it easier to identify the exact point that the run-time error occurs.

An object model consists of a(n)________ collection of objects,consisting of properties,methods,and events that can be manipulated using VBA.

With the VBA ________ control structure there is virtually no limit to the commands and logic that can be applied.

________ are used to execute a series of statements multiple times.

A(n)________ at the workbook level would be when a user opens or closes a workbook.

Within the Visual Basic Editor,the ________ window reveals a list of all the properties of a selected object,like size and color.

An object model consists of a hierarchical collection of objects,consisting of properties,methods,and events that can be manipulated using VBA.

________ programming uses a hierarchy of objects,also called classes,as the focus of the programming.

________ are defined as attributes of an object that can be manipulated using Visual Basic.

A(n)________ performs an action on your project or workbook,such as renaming a worksheet or clearing filtered values from PivotTables.

The two primary types of procedures that are supported by VBA are Sub procedures and module procedures.

The ________ loops until a specified number of loops have been completed.

All of the following statements are TRUE regarding loops in VBA EXCEPT:

Which type of model below BEST describes a hierarchical collection of items that can be manipulated when using Visual Basic?

Navigate, manipulate, and Print Worksheets

Formatting, functions, and Formulas

Cell References, named Ranges, and Functions

Effective Charts

Complex Conditional and Retrieval Functions

Analyze Data Using Tables

Multiple Worksheets workbooks and Templates

Refine an Excel Application

Organize, import, export, and Cleanse Data Sets

Data Tables, scenario Manager, and Solver

Loan Amortization, investment Analysis, and Asset Depreciation

Business Statistics and Regression Analysis

Excels Data Model, Power-pivot, and Power View

Appendix:efficient Interaction With a Touch Screen

The Common Features of Microsoft Office

Filters