Excel VBA Excel VBA Fundamentals & Syntax

Question 1

Which keyword is used to declare a variable in VBA?

Accepted Answer

Dim

Answer

Var

Answer

Let

Answer

Define

Question 2

What is the correct way to start a VBA subroutine?

Accepted Answer

Sub MySub()

Answer

Function MySub()

Answer

Begin MySub()

Answer

Start MySub()

Question 3

Which VBA data type stores True or False values?

Accepted Answer

Boolean

Answer

Integer

Answer

String

Answer

Byte

Question 4

What does the Option Explicit statement do in VBA?

Accepted Answer

Requires all variables to be declared before use

Answer

Enables error handling

Answer

Optimizes code performance

Answer

Enables access to Excel objects

Question 5

In VBA, which operator is used for string concatenation?

Accepted Answer

&

Answer

+

Answer

*

Answer

#

Question 6

Which VBA loop construct checks its condition BEFORE executing the loop body?

Accepted Answer

Do Until...Loop

Answer

Do...Loop Until

Answer

For Each...Next

Answer

Do...Loop While