Exam 14: Visual Basic for Applications

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

Names for Sub procedures must begin with a(n)________ and cannot contain any spaces.

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

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

Protecting the VBA code with a(n)________ ensures that no unauthorized person will access the code.

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

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

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

A container for code is called a ________.

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

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

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

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

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

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(n)________ is space in a computer's memory that is given a name and is used to store a value of a specified data type.