Which function is accessed via the Lookup & Reference dropdown in the Formulas tab?

Which function is accessed via the Lookup & Reference dropdown in the Formulas tab?

• A. Unique
• B. TextJoin
• C. If
• D. Sort

Answer: (A)

In the Lookup & Reference area, you’re dealing with functions that help locate or reference data within a sheet. Unique is the one that fits this purpose because it returns the distinct values from a range, effectively identifying the items you want to reference without duplicates. It’s especially handy when you need a clean list of items to feed into other lookups or to populate a data validation list. For example, pulling unique customer names from a long list gives you a compact reference you can use for further lookups or summaries. Other options perform different tasks—TextJoin concatenates strings, If tests conditions, and Sort arranges data—so they belong to their own categories and aren’t the function you’d use to extract distinct values to reference.

In the Lookup & Reference area, you’re dealing with functions that help locate or reference data within a sheet. Unique is the one that fits this purpose because it returns the distinct values from a range, effectively identifying the items you want to reference without duplicates. It’s especially handy when you need a clean list of items to feed into other lookups or to populate a data validation list. For example, pulling unique customer names from a long list gives you a compact reference you can use for further lookups or summaries. Other options perform different tasks—TextJoin concatenates strings, If tests conditions, and Sort arranges data—so they belong to their own categories and aren’t the function you’d use to extract distinct values to reference.