Question 1

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

Accepted Answer

A) method 
B) collection 
C) source 
D) object model 
A) method 
B) collection 
C) source 
D) object model

Question 2

Labels are critical to dashboard design and can add clarity to the graphics being displayed.

Accepted Answer

A) True 
 B)False

Question 3

________ provide management with a "Big picture" view of the business,usually from multiple perspectives using various charts and other graphical representations.

Accepted Answer

The answer of ________ provide management with a "Big picture"...

Question 4

Creating a lookup table and using the ________ function is a common approach to linking values to various form controls.

Accepted Answer

A) IF 
B) SUBTOTAL 
C) VLOOKUP 
D) HLOOKUP 
A) IF 
B) SUBTOTAL 
C) VLOOKUP 
D) HLOOKUP

Question 5

Within the Visual Basic Editor,the Project ________ window houses a hierarchical listing of all object in a workbook,which includes macros and other modules.

Accepted Answer

A) Properties 
B) Explorer 
C) Code 
D) Information 
A) Properties 
B) Explorer 
C) Code 
D) Information

Question 6

________ worksheets from intentional or unintentional modification can be done by simply hiding the worksheets in the Excel workbook.

Accepted Answer

The answer of ________ worksheets from intentional or unintentional modification...

Question 7

The ________ loops through an object collection or an array.

Accepted Answer

A) Do…While loop 
B) Do…Until loop 
C) For loop 
D) For…Each loop 
A) Do…While loop 
B) Do…Until loop 
C) For loop 
D) For…Each loop

Question 8

A run-time error occurs when the code is executed,displaying a description of the error.

Accepted Answer

A) True 
 B)False

Question 9

Objects grouped together are called object ________,which can also be referred to as objects.

Accepted Answer

A) collections 
B) methods 
C) parameters 
D) sources 
A) collections 
B) methods 
C) parameters 
D) sources

Question 10

A particular object can be referenced inside a collection by referring to the ________ collection and then the name or number that represents that specific member of that collection.

Accepted Answer

The answer of A particular object can be referenced inside...

Question 11

To refer to a particular object using VBA,the objects need to be referred to in their hierarchical structure.For example,to refer to cell A1 in a specific worksheet,the code would be ________.

Accepted Answer

A) Application.Workbook (workbookname.xlsx).Sheets("Sheet1").Range("A1") 
B) Application.Workbook (workbookname.xlsx).Worksheet("Sheet1").Range("A1") 
C) Application.Worksheet("Sheet1").Range("A1") 
D) Application.Workbook (workbookname.xlsx).Worksheet(Range("A1")) 
A) Application.Workbook (workbookname.xlsx).Sheets("Sheet1").Range("A1") 
B) Application.Workbook (workbookname.xlsx).Worksheet("Sheet1").Range("A1") 
C) Application.Worksheet("Sheet1").Range("A1") 
D) Application.Workbook (workbookname.xlsx).Worksheet(Range("A1"))

Question 12

A ________ error occurs when the code is executed,displaying a description of the error.

Accepted Answer

A) data port 
B) debugging 
C) run-time 
D) hard drive 
A) data port 
B) debugging 
C) run-time 
D) hard drive

Question 13

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

Accepted Answer

A) True 
 B)False

Question 14

________ are objects that can be placed into an Excel worksheet,providing the functionality to interact with your models.

Accepted Answer

A) Form controls 
B) Events 
C) Loops 
D) Objects 
A) Form controls 
B) Events 
C) Loops 
D) Objects

Question 15

All of the following are ways to make VBA code easy to read EXCEPT ________.

Accepted Answer

A) Comments 
B) Line breaks 
C) Paragraphs 
D) Indentations 
A) Comments 
B) Line breaks 
C) Paragraphs 
D) Indentations

Question 16

________ are visual controls that allow you to quickly and easily filter your data in an interactive way.

Accepted Answer

The answer of ________ are visual controls that allow you...

Question 17

To create a function procedure you must first declare it is a function,and then provide the function with a name and an opening parenthesis.

Accepted Answer

A) True 
 B)False

Question 18

Names for Sub procedures must begin with a letter and cannot contain any spaces.

Accepted Answer

A) True 
 B)False

Question 19

Match between columns
                        Premises: Project Explorer window
Properties window
Function procedure
Visual Basic Editor
Code window

Accepted Answer

The Answer of Group of VBA statements and Contains a is...

Question 20

Dashboards are objects that can be placed into an Excel worksheet,providing the functionality to interact with your models.

Accepted Answer

A) True 
 B)False

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

Labels are critical to dashboard design and can add clarity to the graphics being displayed.

________ provide management with a "Big picture" view of the business,usually from multiple perspectives using various charts and other graphical representations.

Creating a lookup table and using the ________ function is a common approach to linking values to various form controls.

Within the Visual Basic Editor,the Project ________ window houses a hierarchical listing of all object in a workbook,which includes macros and other modules.

________ worksheets from intentional or unintentional modification can be done by simply hiding the worksheets in the Excel workbook.

The ________ loops through an object collection or an array.

A run-time error occurs when the code is executed,displaying a description of the error.

Objects grouped together are called object ________,which can also be referred to as objects.

A particular object can be referenced inside a collection by referring to the ________ collection and then the name or number that represents that specific member of that collection.

To refer to a particular object using VBA,the objects need to be referred to in their hierarchical structure.For example,to refer to cell A1 in a specific worksheet,the code would be ________.

A ________ error occurs when the code is executed,displaying a description of the error.

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

________ are objects that can be placed into an Excel worksheet,providing the functionality to interact with your models.

All of the following are ways to make VBA code easy to read EXCEPT ________.

________ are visual controls that allow you to quickly and easily filter your data in an interactive way.

To create a function procedure you must first declare it is a function,and then provide the function with a name and an opening parenthesis.

Names for Sub procedures must begin with a letter and cannot contain any spaces.

Dashboards are objects that can be placed into an Excel worksheet,providing the functionality to interact with your models.

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

Exam 14: Visual Basic for Applications

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

Labels are critical to dashboard design and can add clarity to the graphics being displayed.

________ provide management with a "Big picture" view of the business,usually from multiple perspectives using various charts and other graphical representations.

Creating a lookup table and using the ________ function is a common approach to linking values to various form controls.

Within the Visual Basic Editor,the Project ________ window houses a hierarchical listing of all object in a workbook,which includes macros and other modules.

________ worksheets from intentional or unintentional modification can be done by simply hiding the worksheets in the Excel workbook.

The ________ loops through an object collection or an array.

A run-time error occurs when the code is executed,displaying a description of the error.

Objects grouped together are called object ________,which can also be referred to as objects.

A particular object can be referenced inside a collection by referring to the ________ collection and then the name or number that represents that specific member of that collection.

To refer to a particular object using VBA,the objects need to be referred to in their hierarchical structure.For example,to refer to cell A1 in a specific worksheet,the code would be ________.

A ________ error occurs when the code is executed,displaying a description of the error.

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

________ are objects that can be placed into an Excel worksheet,providing the functionality to interact with your models.

All of the following are ways to make VBA code easy to read EXCEPT ________.

________ are visual controls that allow you to quickly and easily filter your data in an interactive way.

To create a function procedure you must first declare it is a function,and then provide the function with a name and an opening parenthesis.

Names for Sub procedures must begin with a letter and cannot contain any spaces.

Dashboards are objects that can be placed into an Excel worksheet,providing the functionality to interact with your models.

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