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

Quiz =UNIQUE — 10 Questions

10 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 — 10 questions 1 of 10

Question 1 of 10 1/10

How many arguments does =UNIQUE have in total?

Question 2 of 10 2/10

How many required arguments does =UNIQUE have?

Question 3 of 10 3/10

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

Question 4 of 10 4/10

Which category does =UNIQUE belong to?

Question 5 of 10 5/10

Is =UNIQUE volatile?

Question 6 of 10 6/10

What is the output type of =UNIQUE?

Question 7 of 10 7/10

Which statement about =UNIQUE is correct?

Question 8 of 10 8/10

Since which Excel version is =UNIQUE available?

Question 9 of 10 9/10

Does =UNIQUE return a dynamic array?

Question 10 of 10 10/10

In =UNIQUE, which is argument #1?

Click a question to see the answer.

1. How many arguments does =UNIQUE have in total?

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

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

2. How many required arguments does =UNIQUE have?

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

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

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

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

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

4. Which category does =UNIQUE belong to?

A. Financial
B. Lookup & Reference ✓
C. Date & Time
D. Text

Explanation: Category is “Lookup & Reference”.

5. Is =UNIQUE volatile?

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

Explanation: UNIQUE is not volatile.

6. What is the output type of =UNIQUE?

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

Explanation: Output is “Array”.

7. Which statement about =UNIQUE is correct?

A. Text is always ignored
B. Volatile and recalculates every time
C. Requires add-in
D. 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)) ✓

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))

8. Since which Excel version is =UNIQUE available?

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

Explanation: Version: “Excel 2021”.

9. Does =UNIQUE return a dynamic array?

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

Explanation: UNIQUE spills as a dynamic array.

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

A. exactly_once]
B. range
C. array ✓
D. criteria

Explanation: Argument #1 is “array”.