23.
Which of the following is true about the Project Explorer window?
24.
Which of the following VBA windows will you use to debug your VBA code?
25.
Which of the following key(s) will display the Immediate Window if it is not
visible on the VBE Program Window?
26.
Which of the following is true about the Immediate window?
27.
When you record a macro, Excel automatically inserts a VBA _____ to hold
the recorded code.
28.
When entering code directly into a module, which key should be used to
indent some of the lines to make the code easier to read?
29.
While entering a VBA code directly, to continue a single line of code from
one line to the next, end the first line with:
30.
Sub procedures start with the keyword Sub followed by the name of the
procedure and opening and closing:
31.
Which of the following statements is true of a user defined function?
32.
Which of the following is the simplest type of VBA statement?
33.
With which of the following would you begin a comment line?
34.
Which of the following elements of VBA programming may change during
the execution of a procedure?
35.
Which of the following would be considered a named element whose value
would not change during the execution of a procedure?
36.
Which of the following data type uses 2 bytes and whose range of values is
true or false?
37.
Which of the following data type uses 1 byte per character and whose range
of values varies?
38.
Excel and VBA can work with both numbers and text. Text is often referred
to as ____.
39.
What type of strings theoretically can hold as many as 2 billion characters?
40.
Which of the following options would describe the process of creating
variables simply by using them?
41.
Which of the following describes the process of defining the names of all
the variables you are going to use, before you use them in your code?
42.
Which of the following is used to declare an explicit variable with VBA
code?
43.
In VBA, dates and times are placed between two:
44.
Which of the following is a VBA statement that allocates the result of an
expression to a variable or an object?
45.
In VBA, which of the following symbols represents the exponentiation
operator?