Google Sheets Test Google Sheets Advanced Lookup Functions 5

Question 1

Which XLOOKUP search_mode value performs a binary search on data sorted in ascending order?

Accepted Answer

2

Answer

search_mode 2 runs a binary search assuming the lookup array is sorted ascending, which is faster on large sorted data.

Question 2

What does LOOKUP (the plain LOOKUP function) assume about the data it searches?

Accepted Answer

It is sorted in ascending order

Answer

The legacy LOOKUP function assumes ascending-sorted data and can return wrong results otherwise.

Question 3

To return the LAST matching value instead of the first, which XLOOKUP argument do you adjust?

Accepted Answer

Set search_mode to -1

Answer

search_mode -1 searches from last to first, returning the final match instead of the first.

Question 4

When using FILTER for a lookup, what does it return if no rows meet the condition?

Accepted Answer

#N/A error

Answer

FILTER returns #N/A when no rows satisfy the condition unless a second argument for empty results is provided.

Question 5

Which is a valid reason to choose INDEX/MATCH over XLOOKUP in a shared workbook?

Accepted Answer

Compatibility with older tools that don't support XLOOKUP

Answer

INDEX/MATCH is broadly supported across older spreadsheet versions and export formats where XLOOKUP may not exist.

Google Sheets Test Practice Test