Google Sheets Test Google Sheets Advanced Lookup Functions 3

Question 1

In XLOOKUP, which argument controls whether the search runs from first-to-last or last-to-first?

Accepted Answer

search_mode

Answer

The search_mode argument accepts values like 1, -1, 2, and -2 to set search direction and binary search.

Question 2

How does INDEX(range, MATCH(...)) find the intersection of a row and column?

Accepted Answer

By using MATCH twice for row and column positions

Answer

A two-dimensional lookup uses INDEX with two MATCH calls, one for the row and one for the column.

Question 3

What is the effect of setting XLOOKUP's match_mode to 2?

Accepted Answer

Wildcard character match

Answer

match_mode 2 enables wildcard matching using ? and * characters.

Question 4

Which function returns multiple matching rows for a single criterion, unlike VLOOKUP which returns only the first?

Accepted Answer

FILTER

Answer

FILTER returns every row that meets the condition, not just the first match.

Question 5

When VLOOKUP's range_lookup is TRUE, how must the first column be arranged for correct results?

Accepted Answer

Sorted in ascending order

Answer

Approximate-match VLOOKUP requires the lookup column sorted ascending, or it returns incorrect values.

Google Sheets Test Practice Test