Deck 14: Visual Basic for Applications

Question 1

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

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

Answer 1

D

Question 2

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

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

Answer 2

C

Question 3

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

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

Answer 3

C

Question 4

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

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

Question 5

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

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 6

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

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

Question 7

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

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

Question 8

A type of variable that refers to one of the pieces of data provided in a method is called a(n)________.

A)parameter
B)module
C)object
D)method

Question 9

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

A)Organizational
B)Subject
C)Object
D)Program

Question 10

All of the following statements are TRUE about business intelligence EXCEPT:

A)Business intelligence is a variety of software applications that are used to analyze an organization's data.
B)The role of BI has increased over the last decade because the amount of data being collected by businesses continues to grow at a rapid rate.
C)The most recent trend, which appears that it will be short-lived, is the desire for digital dashboards.
D)Dashboards provide management with a "big picture" view of the business, usually from multiple perspectives using various charts and other graphical representations.

Question 11

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

A)Indicators
B)Properties
C)Modules
D)Collections

Question 12

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

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

Question 13

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

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

Question 14

A ________ has a very similar function as the spin button,however,the value of the linked cell is increased or decreased by sliding it to the left or right.

A)scroll bar
B)spin button
C)menu
D)labels

Question 15

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

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

Question 16

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

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

Question 17

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

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

Question 18

In Visual Basic Editor,the ________ window is where all the Visual Basic language is typed,and where macro data can be viewed.

A)Code
B)Properties
C)Macro
D)Graphic

Question 19

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

A)scroll bar
B)radio button
C)menu
D)list

Question 20

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)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 21

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

A)Loops are used to execute a series of statements multiple times.
B)In the syntax of the Do loop, the data type of the element and group must be the same.
C)The number of times the code is executed can be determined by a specified number, until a condition is true or false, or the code can continue to execute however many objects there are in a collection.
D)There are essentially two categories of loops: Do loops and For...Next loops.

Question 22

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

A)If-Then
B)If-Then-Else
C)If-Then-Again
D)If-Then-End

Question 23

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.

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

Question 24

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

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

Question 25

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

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

Question 26

Protecting the VBA code with ________ ensures that no unauthorized person will access the code.

A)a password
B)encryption
C)form control
D)method

Question 27

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

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

Question 28

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

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

Question 29

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)input box
B)spinner
C)list
D)scroll bar

Question 30

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

A)procedure
B)variable
C)event
D)object

Question 31

The ________ loops through an object collection or an array.

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

Question 32

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

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 33

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

Question 34

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

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

Question 35

A container for code is called a ________.

A)Sub procedure
B)module
C)function procedure
D)Properties window

Question 36

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

A)Sub procedure
B)module
C)function procedure
D)Properties window

Question 37

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

A)Virtual
B)Prime
C)Function
D)Base

Question 38

All of the following statements are TRUE about VBA procedures EXCEPT:

A)Function procedures are often used to create custom functions that can be entered in worksheet cells.
B)You can have zero or hundreds of Sub procedures and functions written within a single module.
C)If a Sub procedure is to run when a workbook opens or a worksheet becomes active, then it is typically stored in the workbook or worksheet object to take advantage of the Procedure menu at the top of the Code window.
D)Three primary types of procedures are supported by VBA.

Question 39

The ________ allows you to check and fix VBA code errors.

A)parameter
B)debugger
C)message box
D)properties box

Question 40

All of the following statements are TRUE about protecting VBA code EXCEPT:

A)It is considered best practice to export any VBA modules as text files before protecting them with a password.
B)Before a worksheet is protected, ensure that cells that need to be allowed to be changed to use the dashboard are not locked.
C)Some managers may need to access the raw data in a workbook and should know VBA to be able to unhide those worksheets.
D)Protecting worksheets from intentional or unintentional modification can be done by hiding the worksheets in the Excel workbook.

Question 41

The Properties window contains a list of all the properties of a selected object such as name,size,and color.

Question 42

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

Question 43

Methods are attributes of an object that can be referred to or manipulated using VBA.

Question 44

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

Question 45

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.

Question 46

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

Question 47

A parameter is a special kind of variable used to refer to one of the pieces of data provided in a method.

Question 48

The Code window contains a hierarchical list of all the objects in open workbooks,including macros,modules,and worksheets.

Question 49

A message box is a form control that is linked to a specific cell.

Question 50

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.

Question 51

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

Question 52

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

Question 53

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

Question 54

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

Question 55

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

Question 56

A function procedure is a group of VBA statements that perform a calculation and return a single value.

Question 57

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.

Question 58

With a scroll bar,the value of the linked cell is increased or decreased by sliding the scroll bar to the left or right.

Question 59

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

Question 60

Visual Basic for Applications is a powerful programming language that is part of all Microsoft Office applications.

Question 61

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

Question 62

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

Question 63

An easy way to gain a better understanding of how VBA works is to use the VBA Recorder to generate VBA code for actions you want to complete.

Question 64

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

Question 65

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

Question 66

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

Question 67

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

Question 68

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.

Question 69

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.

Question 70

A(n)________ is a group of VBA statements that perform a calculation and return a single value.

Question 71

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

Question 72

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

Question 73

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.

Question 74

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

Question 75

The ________ window contains a list of all the properties of a selected object such as name,size,and color.

Question 76

Press F3 in the VBE to display the Object Browser,which shows properties,methods,and events for an object.

Question 77

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

Question 78

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

Question 79

________ is a powerful programming language that is part of most Microsoft Office applications.

Question 80

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