On which tab is the Function Library group that contains the UNIQUE function located?

On which tab is the Function Library group that contains the UNIQUE function located?

• A. Formulas
• B. Home
• C. Data
• D. Review

Answer: (A)

Access to functions is centralized in the Formulas tab, within the Function Library. This is where Excel groups functions by purpose (Financial, Logical, Text, Date & Time, Lookup & Reference, Math & Trig, etc.). The UNIQUE function is part of this library, so you access it by going to the Formulas tab and using the Function Library (often under a category like Lookup & Reference) or by typing =UNIQUE(...) directly. Other tabs such as Home, Data, and Review don’t host the Function Library, so they aren’t where you would find the UNIQUE function.

Access to functions is centralized in the Formulas tab, within the Function Library. This is where Excel groups functions by purpose (Financial, Logical, Text, Date & Time, Lookup & Reference, Math & Trig, etc.). The UNIQUE function is part of this library, so you access it by going to the Formulas tab and using the Function Library (often under a category like Lookup & Reference) or by typing =UNIQUE(...) directly. Other tabs such as Home, Data, and Review don’t host the Function Library, so they aren’t where you would find the UNIQUE function.