46.
In VBA, which of the following logical operators performs the function of
conjunction on two expressions?
47.
In VBA, which of the following logical operators performs the function of
disjunction on two expressions?
48.
In VBA, which of the following logical operators performs the function of
exclusion on two expressions?
49.
In VBA, which of the following logical operators performs the function of
negation on an expression?
50.
Which of the following operators has the highest precedence in VBA?
51.
Which of the following is true about the way a macro works?
52.
Which of the following statements is VBA’s most important control
structure?
53.
When you want to execute one or more statements conditionally, what VBA
structure would you use?
54.
Which of the following VBA structures is recommended in a decision
involving three or more options?
55.
When VBA executes a Select Case structure, the structure is exited:
56.
Which of the following terms refers to repeating a block of statements or
code numerous times?
57.
Which of the following is the simplest type of looping statement?
58.
Which VBA loop structure is controlled by a counter variable, which starts at
one value and stops at another value?
59.
In which of the following VBA structures, a macro continues to execute the
loop until a specified condition is met?
60.
Which of the following is true about the Do-Until loop structure?
True / False Questions
61.
VBA stands for Virtual Basic for Applications.
62.
Units of VBA code are called subroutines.
63.
To use VBA in an Excel worksheet, you must purchase a separate plug-in
module.
64.
The macro recorder is a software tool that lets you record a sequence of
commands in Excel and save them as a macro.
65.
VBA is only a programming language and not a macro language.
66.
A macro is a set of actions recorded or written by a user.
67.
You can use VBA to create your own worksheet functions.
68.
A VBA macro can be used to print your company name and logo at the top
of all worksheets.
69.
You can customize the Excel toolbars with your own buttons that execute
the macros you write.
70.
The Visual Basic Editor is used to record a sequence of commands in Excel
to save them in a macro.