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

Find()

Answer

Search()

Answer

Locate()

Question 2

How do you clear a variant array completely in VBA?

Accepted Answer

Erase arr

Answer

Set arr = Nothing

Answer

arr = Null

Answer

ReDim arr(0)

Question 3

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

Accepted Answer

Raw underlying numeric values without date/currency conversion

Answer

Formatted text instead of raw data

Answer

The formula string of the cell

Answer

A copy of the cell value as a string

Question 4

Which VBA function joins array elements into a single string?

Accepted Answer

Join()

Answer

Concat()

Answer

Combine()

Answer

Merge()

Question 5

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

Accepted Answer

Worksheets.Add()

Answer

Workbook.AddSheet()

Answer

Sheets.New()

Answer

Workbook.Insert()

Question 6

What is the purpose of the UsedRange property in VBA?

Accepted Answer

Returns the rectangular range that encompasses all non-empty cells on the sheet

Answer

Returns only cells with formulas

Answer

Lists all named ranges

Answer

Filters out blank rows