Microsoft Excel Advanced Formula and Macro Creation 2

Question 1

What does the VBA keyword 'Dim' stand for?

Accepted Answer

Dimension

Answer

Diminish

Answer

Direct Input Method

Answer

Data In Memory

Question 2

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

Accepted Answer

INDIRECT

Answer

OFFSET

Answer

INDEX

Answer

ADDRESS

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

Creating a loop

Answer

Defining a class module

Answer

Handling runtime errors

Question 4

What does the FORMULATEXT function do?

Accepted Answer

Returns the formula in a cell as a text string

Answer

Converts a formula result to text

Answer

Creates a formula from text

Answer

Evaluates text as a formula

Question 5

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

Accepted Answer

Simply press Enter — dynamic arrays spill automatically

Answer

Press Ctrl+Shift+Enter

Answer

Wrap in ARRAYFORMULA()

Answer

Select the output range first

Question 6

What is the purpose of the LAMBDA function in Excel?

Accepted Answer

Defining custom reusable functions without VBA

Answer

Creating anonymous functions in VBA

Answer

Generating random numbers

Answer

Creating lambda expressions for Power Query