100.
Visual Basic for Applications (VBA) manipulates ____, such as a workbook,
a worksheet, a cell range, a chart, or a shape.
101.
A(n) _____ can be used in VBA macro to store such things as values, text, or
property settings (such as a font color or alignment).
102.
The _____ is a separate application where you write and edit your Visual
Basic macros.
103.
The quickest way to activate the Visual Basic Editor (VBE) is to press _____
when Excel is active.
104.
In the Visual Basic Editor (VBE), the _____ window displays a tree diagram
that consists of every workbook currently open in Excel.
105.
The _____ window is most useful for executing VBA statements directly and
for debugging code.
106.
When you’re working in the Visual Basic Editor (VBE), each Excel workbook
that’s open is known as a(n) ____.
107.
_____ is a type of code which consists of one or more statements that you
provide to VBA.
108.
All macros reside in code modules of which there are two types: _____ and
_____ modules.
109.
The macro recorder can only produce _____ procedures.
110.
If the function you need is not already in Excel, you can write your own
_____ using VBA.
111.
A(n) _____ is the simplest type of VBA statement.
112.
To assign a value to a variable, you must use the _____ operator.
113.
When assigning variable names, you can use letters, numbers, and some
punctuation characters, but the first character must be a(n) ____.
114.
In the context of the elements of VBA programming, a(n) _____ is a named
element whose value doesn’t change.
115.
A(n) _____ data type uses 2 bytes and its range of values is True or False.
116.
Excel and Visual Basic for Applications (VBA) can work with both numbers
and text. Text is often referred to as a(n) ____.
117.
In VBA, _____ are declared with a specified number of characters.
118.
If you want to declare a variable explicitly, you do so using a _____
statement.
119.
A(n) _____ is a VBA statement that assigns the result of an expression to a
variable or an object.
120.
In the context of the precedence order for operators in VBA, _____ has the
highest precedence.
121.
Some Visual Basic for Applications (VBA) procedures, such as ____, always
start at the code’s beginning and progress line by line to the end, never
deviating from this top-to-bottom flow.
122.
In the context of the standard structured decision offered by VBA, the _____
structure is suggested for decisions involving three or more options.
123.
The term _____ refers to repeating a block of statements or code numerous
times.
124.
A(n) _____ loop continues to execute until a specified condition has been
met.
125.
In a _____ loop, the macro executes the loop until the condition is true.
