VBA quiz
Authored by Disha Campus
Other
University
Used 2+ times
AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
10 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
45 sec • 1 pt
Which of the following is NOT a feature of VBA?
Object-Oriented Programming
Dynamic Typing
Debugging Tools
Conditional Formatting
2.
MULTIPLE CHOICE QUESTION
45 sec • 1 pt
What is the purpose of Option Explicit in VBA?
To force the declaration of all variables
To enable debugging mode
To define a function
To format cells
3.
MULTIPLE CHOICE QUESTION
45 sec • 1 pt
Which of the following is the correct syntax for declaring an array in VBA?
Dim arrName[] As dataType
Dim arrName(10) As dataType
Dim arrName As dataType(10)
Dim arrName As dataType[]
4.
MULTIPLE CHOICE QUESTION
45 sec • 1 pt
Which of the following is NOT a control structure in VBA?
If-Then-Else
Select Case
For-Next
While-Do
5.
MULTIPLE CHOICE QUESTION
45 sec • 1 pt
Which of the following is NOT a VBA operator?
+
*
%
&
6.
MULTIPLE CHOICE QUESTION
45 sec • 1 pt
Which of the following is the correct syntax for a function in VBA?
FunctionName()
Function Name()
Function_Name()
functionName
7.
MULTIPLE CHOICE QUESTION
45 sec • 1 pt
Which of the following is NOT a VBA loop structure
For Next Loop
Do Until Loop
Do While Loop
Repeat Until Loop
Access all questions and much more by creating a free account
Create resources
Host any resource
Get auto-graded reports
Continue with Google
Continue with Email
Continue with Classlink
Continue with Clever
or continue with
Microsoft
%20(1).png)
Apple
Others
Already have an account?
