Microsoft Excel Advanced Formula and Macro Creation 2

Question 1

What does the VBA keyword 'Dim' stand for?

Accepted Answer

Dimension

Answer

Dim stands for 'Dimension' and is used to declare variables in VBA.

Question 2

Which Excel function returns a reference to a range specified by a text string?

Accepted Answer

INDIRECT

Answer

INDIRECT converts a text string into an actual cell reference for dynamic reference building.

Question 3

In VBA, what is the purpose of 'With...End With'?

Accepted Answer

Executing statements on a single object without re-qualifying it

Answer

With...End With performs multiple operations on the same object without repeating the object reference.

Question 4

What does the FORMULATEXT function do?

Accepted Answer

Returns the formula in a cell as a text string

Answer

FORMULATEXT returns the formula in a referenced cell as text, useful for documentation and auditing.

Question 5

How do you create a spilling array formula in Excel 365?

Accepted Answer

Simply press Enter — dynamic arrays spill automatically

Answer

In Excel 365, dynamic array formulas automatically spill results into adjacent cells when you press Enter.

Excel Practice Test