Excel VBA Practice Test

Question 1

In VBA, which data type contains only two values?

Accepted Answer

Boolean

Answer

Byte

Answer

Long

Answer

Double

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

ROUND(10*RAND().O)

Answer

ROUND(10*RAND().0)+1

Answer

ROUND(9*RAND(),0)+1

Question 3

What is written at the function's end?

Accepted Answer

End Function

Answer

Last Function

Answer

Close Function

Answer

Stop Function

Question 4

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

Accepted Answer

True

Answer

0.0

Answer

False

Answer

100

Question 5

In VBA, what isn't a decision statement?

Accepted Answer

None of the above

Answer

if.. Elseif..Else statement

Answer

if statement

Answer

if.. Else statement

Question 6

In VBA, what is the output of expressicm 5+1 0?

Accepted Answer

15.0

Answer

150.0

Answer

5.0

Answer

10.0

Question 7

During the calculation process, rounding errors may occur.

Accepted Answer

Multiplication

Answer

Addition

Answer

Subtraction

Answer

None of the above

Question 8

In VBA, which of the following is not a data type?

Accepted Answer

Answer

Text

Answer

Date

Answer

Time

Answer

None of the above

Question 9

In Excel, what keyboard shortcut is used to use a breakpoint?

Accepted Answer

F9

Answer

F8

Answer

F6

Answer

F7

Question 10

What are the OR and XOR operators?

Accepted Answer

Logical Operators

Answer

Relational operators

Answer

Arithmetic operators

Answer

None of the above