Excel VBA Excel VBA Data Manipulation & Arrays 3

Question 1

Which VBA function returns the position of a substring within a string?

Accepted Answer

InStr()

Answer

InStr() searches for the first occurrence of one string within another and returns its position as an integer.

Question 2

How do you clear a variant array completely in VBA?

Accepted Answer

Erase arr

Answer

The Erase statement frees the memory of a dynamic array or resets all elements of a static array.

Question 3

What does the Range.Value2 property return compared to Range.Value?

Accepted Answer

Raw underlying numeric values without date/currency conversion

Answer

Value2 returns the raw underlying value without applying date serial or currency formatting conversions.

Question 4

Which VBA function joins array elements into a single string?

Accepted Answer

Join()

Answer

Join() concatenates all elements of a one-dimensional array into a single string, optionally using a delimiter.

Question 5

In VBA, which method adds a new worksheet to a workbook?

Accepted Answer

Worksheets.Add()

Answer

Worksheets.Add() inserts a new worksheet into the workbook and returns a reference to the new sheet.

Excel VBA Practice Test