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

What is the output type of =UNIQUE?

Question 2 of 10 2/10

Which use case fits =UNIQUE?

Question 3 of 10 3/10

Is =UNIQUE volatile?

Question 4 of 10 4/10

Which category does =UNIQUE belong to?

Question 5 of 10 5/10

In =UNIQUE, which is argument #1?

Question 6 of 10 6/10

How many required arguments does =UNIQUE have?

Question 7 of 10 7/10

How many optional arguments does =UNIQUE have?

Question 8 of 10 8/10

Does =UNIQUE return a dynamic array?

Question 9 of 10 9/10

Which statement about =UNIQUE is correct?

Question 10 of 10 10/10

Is argument “by_col]” required in =UNIQUE?

Click a question to see the answer.

1. What is the output type of =UNIQUE?

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

Explanation: Output is “Array”.

2. Which use case fits =UNIQUE?

A. Rounding & Numeric
B. Daily Tasks ✓
C. Lookup & Retrieval
D. Conditional Formatting & Validation

Explanation: Use case “Daily Tasks” fits UNIQUE.

3. Is =UNIQUE volatile?

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

Explanation: UNIQUE is not volatile.

4. Which category does =UNIQUE belong to?

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

Explanation: Category is “Lookup & Reference”.

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

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

Explanation: Argument #1 is “array”.

6. How many required arguments does =UNIQUE have?

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

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

7. How many optional arguments does =UNIQUE have?

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

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

8. Does =UNIQUE return a dynamic array?

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

Explanation: UNIQUE spills as a dynamic array.

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. Only works in old versions
C. Select entire column for best performance
D. Output is always a dynamic array

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. Is argument “by_col]” required in =UNIQUE?

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

Explanation: “by_col]” is optional.