Excel VBA Excel VBA Data Manipulation & Arrays

Question 1

How do you declare a dynamic array in VBA?

Accepted Answer

Dim arr() As Integer

Answer

Dim arr(10) As Integer

Answer

Dim arr As Array

Answer

Dim arr[10] As Integer

Question 2

Which VBA statement resizes a dynamic array while preserving existing data?

Accepted Answer

ReDim Preserve arr(20)

Answer

ReDim arr(20)

Answer

Resize arr(20)

Answer

Expand arr(20)

Question 3

What does the LBound() function return for an array?

Accepted Answer

The first valid index

Answer

The total number of elements

Answer

The last valid index

Answer

The data type of elements

Question 4

In VBA, how do you declare a two-dimensional array with 3 rows and 4 columns?

Accepted Answer

Dim arr(2, 3) As Integer

Answer

Dim arr(3, 4) As Integer

Answer

Dim arr[3][4] As Integer

Answer

Dim arr(3)(4) As Integer

Question 5

Which built-in VBA function splits a string into an array using a delimiter?

Accepted Answer

Split()

Answer

Slice()

Answer

Divide()

Answer

Tokenize()

Question 6

What is the default lower bound for VBA arrays?

Accepted Answer

0

Answer

1

Answer

-1

Answer

It depends on the array type