71.
A Sub procedure is a VBA macro that returns a single value.
72.
You view and edit VBA macros using the Function procedure.
73.
A variable in VBA is an item available for you to control in your code.
74.
Excel must be running before a VBA macro can be edited using the VB
editor.
75.
The quickest way to activate the VBE is to press Ctrl + F11 when Excel is
active.
76.
If the Project Window is not visible in VBE, press the Ctrl + W to open it.
77.
When working in VBE, an object is considered as a collection of projects.
78.
A single VBA module can store any number of Sub procedures, Function
procedures, and declarations.
79.
When typing code directly into a VBA macro, the Ctrl key is used to indent
some of the lines to make the code easier to read.
80.
When saving an Excel workbook, any macro that has been created will
automatically get saved within the workbook.
81.
Excel’s VBA macro recorder makes it easy to record user defined functions.
82.
A variable is the simplest type of VBA statement.
83.
In a VBA statement, a comment begins with a double quote (“).
84.
To assign a value to a variable, you must use the equal sign operator.
85.
It is permissible to use spaces when assigning variable names.
86.
Excel and VBA can work with both numbers and text.
87.
Variable-length strings theoretically can hold as many as 2 billion
characters.
88.
An assignment statement is a VBA statement that assigns the result of an
expression to a variable or an object.
89.
The operator XoR performs the logical inclusion on an expression.
90.
A macro is a VBA procedure that starts executing the code at the beginning
and progresses line by line until it reaches the end.
91.
The Select Case structure is used for decisions involving 2 options.
92.
The term looping refers to repeating a block of statements or code
numerous times.
93.
In a Do-While loop, the macro executes the loop until the condition is true.
Fill in the Blank Questions
94.
_____ extends and customizes Excel, allowing you to do things that Excel
itself is not able to do, such as calculating values in cells based on user
input values.
95.
Units of VBA code are called ____.
96.
The _____ is a software tool that lets you record a sequence of commands
in Excel and save them as a macro.
97.
A(n) _____ is a set of actions recorded or written by a user.
98.
A(n) _____ is a set of programming instructions that performs some action
on or with objects.
99.
A(n) _____ is a VBA macro that returns a single value.