Users can access the UNIQUE function through the Lookup & __________________ dropdown list in the Function Library group on the Formulas tab.

Users can access the UNIQUE function through the Lookup & __________________ dropdown list in the Function Library group on the Formulas tab.

• A. Reference
• B. Data
• C. Names
• D. Functions

Answer: (A)

The Unique function lives in the Lookup & Reference group because it’s used to identify or pull data from a range based on references, rather than performing calculations or data processing tasks. That’s why the missing word in the dropdown is Reference—the full category is Lookup & Reference. Other categories like Data, Names, or Functions don’t fit as neatly: Data contains common math and statistical functions, Names relates to named ranges, and Functions is a general umbrella rather than a specific category.

The Unique function lives in the Lookup & Reference group because it’s used to identify or pull data from a range based on references, rather than performing calculations or data processing tasks. That’s why the missing word in the dropdown is Reference—the full category is Lookup & Reference. Other categories like Data, Names, or Functions don’t fit as neatly: Data contains common math and statistical functions, Names relates to named ranges, and Functions is a general umbrella rather than a specific category.