Microsoft Excel Advanced Formulas and Macros 2

Question 1

What is the purpose of IFERROR in Excel?

Accepted Answer

Returns a specified value if a formula evaluates to an error

Answer

IFERROR returns an alternative value if the formula results in any error type.

Question 2

Which VBA statement redirects execution when an error occurs?

Accepted Answer

On Error GoTo

Answer

On Error GoTo directs VBA to jump to a labeled line when a runtime error occurs.

Question 3

What does TEXTJOIN do that CONCATENATE cannot?

Accepted Answer

Joins text with a delimiter and can ignore empty cells

Answer

TEXTJOIN joins text using a specified delimiter and can skip empty cells.

Question 4

In VBA, what is the difference between 'ByRef' and 'ByVal'?

Accepted Answer

ByRef passes the reference allowing modification, ByVal passes a copy

Answer

ByRef (default) passes a reference so changes affect the original; ByVal passes a copy.

Question 5

What is SUMPRODUCT commonly used for beyond multiplication?

Accepted Answer

Conditional counting and summing with multiple criteria without Ctrl+Shift+Enter

Answer

SUMPRODUCT evaluates multiple Boolean conditions in arrays and sums results without CSE entry.

Excel Practice Test