VBA quiz

Which of the following is NOT a feature of VBA?

• Object-Oriented Programming

• Dynamic Typing

• Debugging Tools

• Conditional Formatting

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

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[]

Which of the following is NOT a control structure in VBA?

• If-Then-Else

• Select Case

• For-Next

• While-Do

Which of the following is NOT a VBA operator?

• +

• *

• %

• &

Which of the following is the correct syntax for a function in VBA?

• FunctionName()

• Function Name()

• Function_Name()

• functionName

Which of the following is NOT a VBA loop structure

• For Next Loop

• Do Until Loop

• Do While Loop

• Repeat Until Loop

Which of the following is NOT a VBA data type?

• String

• Boolean

• Character

• Integer

Which of the following is the correct syntax for a comment in VBA?

• //

• '

• ''

• #

What is a macro in VBA?

• A type of variable

• A set of instructions to automate a task

• A loop

• A data structure