Lookup & Reference =UNIQUE(array,[by_col],[exactly_once])

Quiz =UNIQUE — 15 Questions

15 quiz questions about =UNIQUE — test syntax, arguments, examples & errors!

Questions: 10 questions 15 questions Random 10 or 15 questions from the pool + shuffled options each time

← UNIQUE ▦ Practice in Playground

Progress — 15 questions 1 of 15

Question 1 of 15 1/15

What is the output type of =UNIQUE?

Question 2 of 15 2/15

What is the type of argument “array” in =UNIQUE?

Question 3 of 15 3/15

How many optional arguments does =UNIQUE have?

Question 4 of 15 4/15

What is the type of argument “by_col]” in =UNIQUE?

Question 5 of 15 5/15

Is argument “exactly_once]” required in =UNIQUE?

Question 6 of 15 6/15

Is =UNIQUE volatile?

Question 7 of 15 7/15

Which category does =UNIQUE belong to?

Question 8 of 15 8/15

What is the type of argument “exactly_once]” in =UNIQUE?

Question 9 of 15 9/15

Which statement about =UNIQUE is correct?

Question 10 of 15 10/15

Which function is NOT related to =UNIQUE?

Question 11 of 15 11/15

Which formula is a valid example of =UNIQUE?

Question 12 of 15 12/15

In =UNIQUE, which is argument #3?

Question 13 of 15 13/15

In =UNIQUE, which is argument #1?

Question 14 of 15 14/15

Which use case fits =UNIQUE?

Question 15 of 15 15/15

Since which Excel version is =UNIQUE available?

Click a question to see the answer.

1. What is the output type of =UNIQUE?

A. Logical
B. Mixed
C. Array ✓
D. Reference

Explanation: Output is “Array”.

2. What is the type of argument “array” in =UNIQUE?

A. Number
B. Range ✓
C. Logical
D. Reference

Explanation: Type of “array” is “Range”.

3. How many optional arguments does =UNIQUE have?

A. 1
B. 4
C. 3
D. 2 ✓

Explanation: =UNIQUE has 1 required, 2 optional (3 total).

4. What is the type of argument “by_col]” in =UNIQUE?

A. Logical ✓
B. Array
C. Date
D. Number

Explanation: Type of “by_col]” is “Logical”.

5. Is argument “exactly_once]” required in =UNIQUE?

A. No ✓
B. No
C. —
D. Yes

Explanation: “exactly_once]” is optional.

6. Is =UNIQUE volatile?

A. No ✓
B. No
C. —
D. Yes

Explanation: UNIQUE is not volatile.

7. Which category does =UNIQUE belong to?

A. Math & Trig
B. Information
C. Database
D. Lookup & Reference ✓

Explanation: Category is “Lookup & Reference”.

8. What is the type of argument “exactly_once]” in =UNIQUE?

A. Logical ✓
B. Number
C. Text
D. Range

Explanation: Type of “exactly_once]” is “Logical”.

9. Which statement about =UNIQUE is correct?

A. If you format the range of names as an Excel table, then the formula will automatically update when you add or remove names. If you want to sort the list of names, you can add the SORT function: =SORT(UNIQUE(B2:B12&" "&A2:A12)) ✓
B. Output is always a dynamic array
C. Volatile and recalculates every time
D. Text is always ignored

Explanation: Correct: If you format the range of names as an Excel table, then the formula will automatically update when you add or remove names. If you want to sort the list of names, you can add the SORT function: =SORT(UNIQUE(B2:B12&" "&A2:A12))

10. Which function is NOT related to =UNIQUE?

A. FILTER
B. SORT
C. RTD ✓
D. COUNTIF

Explanation: “RTD” is not related to UNIQUE.

11. Which formula is a valid example of =UNIQUE?

A. =FILTER(B2:B100)
B. =UNIQUE(B2:B100, 0)
C. UNIQUE(B2:B100)
D. =UNIQUE(B2:B100) ✓

Explanation: Correct example: =UNIQUE(B2:B100)

12. In =UNIQUE, which is argument #3?

A. value
B. array
C. exactly_once] ✓
D. lookup_value

Explanation: Argument #3 is “exactly_once]”.

13. In =UNIQUE, which is argument #1?

A. exactly_once]
B. array ✓
C. value
D. by_col]

Explanation: Argument #1 is “array”.

14. Which use case fits =UNIQUE?

A. Investment Appraisal
B. Numbering & Sample Data
C. Descriptive Statistics
D. Daily Tasks ✓

Explanation: Use case “Daily Tasks” fits UNIQUE.

15. Since which Excel version is =UNIQUE available?

A. Excel 2021 ✓
B. All versions
C. Excel 2007 (Compatibility)
D. Excel 2019

Explanation: Version: “Excel 2021”.