Question 1

Power Views are mechanisms that deliver business intelligence in graphical form.

Accepted Answer

A) True 
 B)False

Question 2

A(n)________ is an effective way of using VBA code to increase the interactivity of a dashboard by prompting the user for information and storing that information in a variable to be used later.

Accepted Answer

A) input box 
B) spinner 
C) list 
D) scroll bar 
A) input box 
B) spinner 
C) list 
D) scroll bar

Question 3

A Sub procedure performs an action on your project or workbook,such as renaming a worksheet or clearing filtered values from PivotTables.

Accepted Answer

A) True 
 B)False

Question 4

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

Accepted Answer

A) True 
 B)False

Question 5

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

Accepted Answer

The answer of Creating a lookup table and using the...

Question 6

________ is an interactive data visualization,exploration,and presentation experience that encourages the creation of beautiful ad-hoc reports.

Accepted Answer

A) PivotTable 
B) PowerPivot 
C) Power View 
D) PivotChart 
A) PivotTable 
B) PowerPivot 
C) Power View 
D) PivotChart

Question 7

When writing code,and several objects are being referenced at one time,it is necessary to put periods in between each object,called ________.

Accepted Answer

A) parameters 
B) separators 
C) indicators 
D) regulators 
A) parameters 
B) separators 
C) indicators 
D) regulators

Question 8

All of the following statements are TRUE regarding Visual Basic for Applications EXCEPT:

Accepted Answer

A) VBA allows a user to implement a wide variety of enhancements to many Microsoft Office applications. 
B) VBA is considered a very basic form of C++ programming. 
C) VBA provides additional tools that can enhance functionality and usability of an Excel application. 
D) VBA manipulates objects by using the methods and properties associated with them. 
A) VBA allows a user to implement a wide variety of enhancements to many Microsoft Office applications. 
B) VBA is considered a very basic form of C++ programming. 
C) VBA provides additional tools that can enhance functionality and usability of an Excel application. 
D) VBA manipulates objects by using the methods and properties associated with them.

Question 9

Visual Basic can store values in a ________,which is the space in a computer's memory that is given a name and is used to store values.

Accepted Answer

A) warehouse 
B) variable 
C) data port 
D) hard drive 
A) warehouse 
B) variable 
C) data port 
D) hard drive

Question 10

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

Accepted Answer

The answer of The two primary types of procedures that...

Question 11

A(n)________ is a special kind of variable used to refer to one of the pieces of data provided in a method.

Accepted Answer

The answer of A(n)________ is a special kind of variable...

Question 12

Microsoft Office has a tool built into it that is used to create and edit within Visual Basic.Which selection below is that tool?

Accepted Answer

A) Visual Basic Conveyor 
B) Visual Basic Illustrator 
C) Visual Basic Editor 
D) Visual Basic Player 
A) Visual Basic Conveyor 
B) Visual Basic Illustrator 
C) Visual Basic Editor 
D) Visual Basic Player

Question 13

Dynamic ________ offer additional clarity in PivotCharts by displaying the year and/or month that is being displayed when filtered.

Accepted Answer

A) scroll bars 
B) spin buttons 
C) menus 
D) labels 
A) scroll bars 
B) spin buttons 
C) menus 
D) labels

Question 14

All of the following statements are TRUE about improving the readability of VBA EXCEPT:

Accepted Answer

A) An important aspect of writing VBA is making sure the code is easy to read so that you and others can interpret what is happening. 
B) You need to take extra steps to keep the code legible and to document what steps you are taking and why. 
C) Commenting code in VBA is an excellent way of explaining the purpose and the intention of a procedure. 
D) Lengthy statements become difficult to read, because without pressing Tab, the lines of code will extend continuously to the left. 
A) An important aspect of writing VBA is making sure the code is easy to read so that you and others can interpret what is happening. 
B) You need to take extra steps to keep the code legible and to document what steps you are taking and why. 
C) Commenting code in VBA is an excellent way of explaining the purpose and the intention of a procedure. 
D) Lengthy statements become difficult to read, because without pressing Tab, the lines of code will extend continuously to the left.

Question 15

Microsoft Excel objects have ________,which are actions performed within Excel.

Accepted Answer

A) monitors 
B) options 
C) methods 
D) references 
A) monitors 
B) options 
C) methods 
D) references

Question 16

A(n)________ is a form control that is linked to a specific cell.

Accepted Answer

The answer of A(n)________ is a form control that is...

Question 17

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

Accepted Answer

A) Data ports 
B) Variables 
C) Elements 
D) Loops 
A) Data ports 
B) Variables 
C) Elements 
D) Loops

Question 18

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

Accepted Answer

The answer of A(n)________ occurs when the code is executed,displaying...

Question 19

Object-oriented programming uses a hierarchy of objects,also called classes,as the focus of the programming.

Accepted Answer

A) True 
 B)False

Question 20

Match between columns
                        Premises: ActiveSheet
ActiveWindow
Selection
ActiveCell
ActiveChart

Accepted Answer

The Answer of The active chart or chart contained in is...

Power Views are mechanisms that deliver business intelligence in graphical form.

A(n)________ is an effective way of using VBA code to increase the interactivity of a dashboard by prompting the user for information and storing that information in a variable to be used later.

A Sub procedure performs an action on your project or workbook,such as renaming a worksheet or clearing filtered values from PivotTables.

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

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

________ is an interactive data visualization,exploration,and presentation experience that encourages the creation of beautiful ad-hoc reports.

When writing code,and several objects are being referenced at one time,it is necessary to put periods in between each object,called ________.

All of the following statements are TRUE regarding Visual Basic for Applications EXCEPT:

Visual Basic can store values in a ________,which is the space in a computer's memory that is given a name and is used to store values.

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

A(n)________ is a special kind of variable used to refer to one of the pieces of data provided in a method.

Microsoft Office has a tool built into it that is used to create and edit within Visual Basic.Which selection below is that tool?

Dynamic ________ offer additional clarity in PivotCharts by displaying the year and/or month that is being displayed when filtered.

All of the following statements are TRUE about improving the readability of VBA EXCEPT:

Microsoft Excel objects have ________,which are actions performed within Excel.

A(n)________ is a form control that is linked to a specific cell.

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

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

Object-oriented programming uses a hierarchy of objects,also called classes,as the focus of the programming.

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

Power Views are mechanisms that deliver business intelligence in graphical form.

A(n)________ is an effective way of using VBA code to increase the interactivity of a dashboard by prompting the user for information and storing that information in a variable to be used later.

A Sub procedure performs an action on your project or workbook,such as renaming a worksheet or clearing filtered values from PivotTables.

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

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

________ is an interactive data visualization,exploration,and presentation experience that encourages the creation of beautiful ad-hoc reports.

When writing code,and several objects are being referenced at one time,it is necessary to put periods in between each object,called ________.

All of the following statements are TRUE regarding Visual Basic for Applications EXCEPT:

Visual Basic can store values in a ________,which is the space in a computer's memory that is given a name and is used to store values.

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

A(n)________ is a special kind of variable used to refer to one of the pieces of data provided in a method.

Microsoft Office has a tool built into it that is used to create and edit within Visual Basic.Which selection below is that tool?

Dynamic ________ offer additional clarity in PivotCharts by displaying the year and/or month that is being displayed when filtered.

All of the following statements are TRUE about improving the readability of VBA EXCEPT:

Microsoft Excel objects have ________,which are actions performed within Excel.

A(n)________ is a form control that is linked to a specific cell.

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

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

Object-oriented programming uses a hierarchy of objects,also called classes,as the focus of the programming.

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