EXCEL Practice Test: Video 1 Answers (25 Questions)

Question 1

What does VLOOKUP's fourth argument (range_lookup) control?

Accepted Answer

Exact match (FALSE) or approximate match (TRUE)

Answer

FALSE requires exact match; TRUE allows approximate match from sorted data.

Question 2

What replaced CONCATENATE and why?

Accepted Answer

CONCAT and TEXTJOIN; they accept ranges and add delimiters

Answer

CONCAT accepts ranges; TEXTJOIN adds delimiters and can skip empty cells.

Question 3

How does INDEX work with a single range?

Accepted Answer

Returns the value at a specified row position

Answer

INDEX returns the value at a given row and optional column position within a range.

Question 4

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 5

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.

Excel Practice Test