Question 1

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

Accepted Answer

Visual Basic for Applications

Question 2

Match between columns
                        Premises: For loop
For...Each loop
Do While loop
Loop
Do Until loop

Accepted Answer

The Answer of Used to execute a series of statements is...

Question 3

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.

Accepted Answer

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

Question 4

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

Accepted Answer

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

Question 5

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

Accepted Answer

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

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

Accepted Answer

The answer of The ________ window contains a list of...

Question 7

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

Accepted Answer

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

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

Accepted Answer

A) True 
 B)False

Question 9

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

Accepted Answer

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

Question 10

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

Accepted Answer

A) True 
 B)False

Question 11

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

Accepted Answer

A) True 
 B)False

Question 12

Match between columns
                        Premises: Digital dashboard
Spin button
Form control
Slicer
Scroll bar

Accepted Answer

The Answer of Refers to a workbook and Refers to is...

Question 13

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

Accepted Answer

A) True 
 B)False

Question 14

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

Accepted Answer

A) True 
 B)False

Question 15

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

Accepted Answer

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

Question 16

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

Accepted Answer

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

Question 17

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.

Accepted Answer

A) True 
 B)False

Question 18

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

Accepted Answer

A) True 
 B)False

Question 19

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

Accepted Answer

A) True 
 B)False

Question 20

A(n)________ is a dialog box object that is created using the MsgBox command.

Accepted Answer

The answer of A(n)________ is a dialog box object that...

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

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

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

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

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

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

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

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

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

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

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

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

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

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.

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

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

A(n)________ is a dialog box object that is created using the MsgBox command.

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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.

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

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

A(n)________ is a dialog box object that is created using the MsgBox command.

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