Excel VBA Practice Test

Question 1

In VBA, which data type contains only two values?

Accepted Answer

Boolean

Answer

The `Boolean` data type in VBA is specifically designed to store logical values, which can only be `True` or `False`. Internally, `True` is typically represented as -1 and `False` as 0, but conceptually it holds only two distinct states. Other data types like `Byte`, `Long`, and `Double` can hold a much wider range of numerical values.

Question 2

Which of the following formulas will produce an integer between 1 and 10, inclusive, with a probability of 10% for each integer?

Accepted Answer

INT(10*RAND())+1

Answer

The `RAND()` function in Excel generates a random decimal number between 0 (inclusive) and 1 (exclusive). Multiplying by 10 (`10*RAND()`) gives a number between 0 (inclusive) and 10 (exclusive). Applying `INT()` truncates the decimal, resulting in integers from 0 to 9. Adding 1 (`INT(10*RAND())+1`) shifts this range to 1 to 10, ensuring each integer has an equal 10% probability.

Question 3

What is written at the function's end?

Accepted Answer

End Function

Answer

In VBA, every `Function` procedure must be terminated with the `End Function` statement. This keyword signals the compiler that the definition of the function has concluded. Similarly, `Sub` procedures end with `End Sub`, and `If` blocks end with `End If`.

Question 4

What is the output of expression in VBA? (1O<>0 OR 0<>0) True/False

Accepted Answer

True

Answer

In VBA, the `OR` operator returns `True` if at least one of its operands is `True`. The first part of the expression, `10 <> 0`, evaluates to `True` because 10 is indeed not equal to 0. The second part, `0 <> 0`, evaluates to `False`. Since `True OR False` results in `True`, the overall expression evaluates to `True`.

Question 5

In VBA, what isn't a decision statement?

Accepted Answer

None of the above

Answer

VBA includes several decision statements to control program flow based on conditions. These include the `If...Then` statement, `If...Then...Else` statement, and `If...Then...ElseIf...Else` statement. All the options A, B, and C are valid forms of decision statements in VBA. Therefore, "None of the above" is the correct answer, implying all listed options *are* decision statements.