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

Accepted Answer

Slicers are visual controls that provide an interactive way to filter data in Excel. They allow you to quickly select and filter data by clicking on a button or a specific range of values in the slicer. This makes it easier to analyze and understand your data, particularly in large data sets.

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

Accepted Answer

VLOOKUP function is specifically designed to look up and retrieve data from a table based on a matching value in the first column. This makes it a popular choice for linking values to form controls in Excel.

Question 3

Microsoft Excel objects have ________,which are actions performed within Excel.
A)monitors
B)options
C)methods
D)references

Accepted Answer

The actions performed within Excel are referred to as methods. This includes tasks such as formatting cells, sorting data, or creating charts. A method is a specific action that can be performed on an Excel object, and each object will have its own set of available methods. Monitors and options are not relevant to Excel objects, and references are another type of Excel element used to refer to cells or ranges.

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

Accepted Answer

The Properties window in the Visual Basic Editor displays a list of all the properties of a selected object, allowing for easy viewing and editing.

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.

Accepted Answer

VBA is not considered a basic form of C++ programming. While there are similarities between the two languages, they are distinct programming languages with their own syntax and unique features.

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

Accepted Answer

The answer of When writing code,and several objects are being...

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

Accepted Answer

The tool within Microsoft Office that is used to create and edit within Visual Basic is called Visual Basic Editor.

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

Accepted Answer

A parameter is a variable used in a method to refer to one of the inputs provided when the method is called. The other options are not relevant for this definition.

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

Accepted Answer

A hierarchical collection of items in Visual Basic is best described by the Object model, which refers to a programming paradigm that encapsulates data and behavior into reusable software components. The Object model in Visual Basic allows for the creation of classes, objects, properties, methods, and events that can be manipulated within a hierarchical structure.

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.

Accepted Answer

The statement that the most recent trend in BI is the desire for digital dashboards is false. Digital dashboards have been a popular component of BI for many years and are not a recent trend.

Question 11

________ are defined as attributes of an object that can be manipulated using Visual Basic.
A)Indicators
B)Properties
C)Modules
D)Collections

Accepted Answer

Properties are attributes of an object that can be set, retrieved, or manipulated using Visual Basic. Indicators, modules, and collections are not inherently tied to the concept of manipulating object attributes in Visual Basic.

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

Accepted Answer

An object model consists of a collection of objects, each with its own set of properties, methods, and events that can be manipulated using VBA.

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

Accepted Answer

The Explorer window in the Visual Basic Editor displays a hierarchical list of all objects within a workbook, including macros and other modules. The Properties window displays the properties of a selected object, the Code window displays the code for a selected object, and the Information window provides details on a selected object, but none of these display a hierarchical list of all objects in a workbook.

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

Accepted Answer

A scroll bar has the same function as the spin button in terms of increasing or decreasing the value of the linked cell, but instead of clicking on the up or down arrows, the user can slide the bar to the left or right. The other options (menu and labels) do not have this function.

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

Accepted Answer

Form controls, such as buttons, checkboxes, and drop-down lists, can be inserted into an Excel worksheet to interact with models and perform various actions. They can be used to input data, run calculations, navigate through pages, and manipulate the appearance of the worksheet. The other options (B, C, D) are programming concepts, but they do not directly provide functionality for interacting with Excel models.

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

Accepted Answer

Labels would offer additional clarity by displaying the specific year or month being displayed in the PivotChart. Scroll bars, spin buttons, and menus are not directly related to displaying specific dates in a chart.

Question 17

Objects grouped together are called object ________,which can also be referred to as objects.
A)collections
B)methods
C)parameters
D)sources

Accepted Answer

Objects grouped together are referred to as object collections. While methods are a set of instructions that perform a specific task, parameters are options that are passed to methods or functions to modify their behavior. Sources generally refer to the origin of data or information. Therefore, the best choice is A) collections.

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

Accepted Answer

The Code window is where Visual Basic language is typed and edited. It is also where macro data can be viewed, edited, and managed. The Properties window displays the properties of an object, the Macro window is used to record and edit macros, and the Graphic window is used for designing user interfaces.

Question 19

A ________ is a form control that is linked to a specific cell.
A)scroll bar
B)radio button
C)menu
D)list

Accepted Answer

A radio button is a form control that is linked to a specific cell. It allows the user to select one option from a group of options.

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

Accepted Answer

To refer to a specific cell in a worksheet, the hierarchy should be followed as follows: Application.Workbook(Workbook Name).Sheets("Sheet Name").Range("Cell Address"). Therefore, option A is the correct choice. Option B is incorrect because there is no property like Worksheet in the Workbook object. Option C is incorrect because it omits the Workbook name in the hierarchy. Option D is incorrect because Range("A1") should have a sheet reference before it.

Quiz 14: Visual Basic for Applications

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

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

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

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

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

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

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 type of variable that refers to one of the pieces of data provided in a method is called a(n) ________.

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

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

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

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

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 ________ 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.

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

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

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

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

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

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 ________.