Excel VBA Excel VBA

Question 1

Which VBA statement exits a For...Next loop immediately?

Accepted Answer

Exit For

Answer

Exit For immediately transfers control to the statement following the Next keyword.

Question 2

What does the UBound function return when called on an array?

Accepted Answer

The highest valid index

Answer

UBound returns the largest available subscript (upper bound) for the specified dimension of an array.

Question 3

Which method is used to add a new worksheet to a workbook in VBA?

Accepted Answer

Worksheets.Add

Answer

Worksheets.Add (or Sheets.Add) creates and returns a new worksheet in the workbook.

Question 4

What is the result of the VBA expression: 10 Mod 3?

Accepted Answer

1

Answer

The Mod operator returns the remainder after division; 10 divided by 3 leaves a remainder of 1.

Question 5

Which VBA function converts a string to all uppercase letters?

Accepted Answer

UCase

Answer

UCase(string) returns the string with all alphabetic characters converted to uppercase.

Excel VBA Practice Test