Excel Lookup & Reference Function Quiz

Question 1

When performing a standard ID lookup, what is the mandatory requirement for the [range_lookup] or [match_mode] argument?

Question 2

In professional modeling, why is the INDEX + MATCH duo often preferred over the legacy VLOOKUP function?

Question 3

Which native feature of XLOOKUP eliminates the need for expensive nested IFERROR functions?

Question 4

What is the primary 'Performance Penalty' associated with the OFFSET function in industrial-scale workbooks?

Question 5

When constructing an internal navigation link using HYPERLINK, what symbol is required at the start of the 'link_location'?

Question 6

Using XLOOKUP, how do you retrieve the MOST RECENT entry from a running transaction log?

Question 7

Which function provides the 'GPS Coordinate' for the horizontal position of a cell reference?

Question 8

Why would a professional auditor use the FORMULATEXT function instead of simply viewing the cell result?

Question 9

The CHOOSE function is often used as a 'Scenario Switch'. What must be the data type of the 'index_num' argument?

Question 10

If you need to return a specific cell's text address as a string (e.g., '$A$1'), which function do you use?

Question 11

What differentiates the ROWS function from the ROW function?

Question 12

When using INDIRECT to reference a sheet name with spaces (e.g., 'Sales Data'), how must the sheet name be formatted?

Question 13

What happens when XLOOKUP is given a multi-column range as the 'return_array'?

Question 14

For extremely high-speed, million-row lookups, why might a professional use binary search (match_mode 2 in XLOOKUP)?

Question 15

Which 'Reference Mode' allows the INDEX function to define a dynamic range like $A$1:INDEX(...)?