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

Is argument “by_col]” required in =UNIQUE?

Question 2 of 10 2/10

How many required arguments does =UNIQUE have?

Question 3 of 10 3/10

Does =UNIQUE return a dynamic array?

Question 4 of 10 4/10

Which statement about =UNIQUE is correct?

Question 5 of 10 5/10

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

Question 6 of 10 6/10

Is argument “array” required in =UNIQUE?

Question 7 of 10 7/10

How many optional arguments does =UNIQUE have?

Question 8 of 10 8/10

In =UNIQUE, which is argument #2?

Question 9 of 10 9/10

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

Question 10 of 10 10/10

In =UNIQUE, which is argument #3?

Click a question to see the answer.

1. Is argument “by_col]” required in =UNIQUE?

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

Explanation: “by_col]” is optional.

2. How many required arguments does =UNIQUE have?

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

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

3. Does =UNIQUE return a dynamic array?

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

Explanation: UNIQUE spills as a dynamic array.

4. Which statement about =UNIQUE is correct?

A. Only works in old versions
B. Volatile and recalculates every time
C. Text is always ignored
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))

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

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

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

6. Is argument “array” required in =UNIQUE?

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

Explanation: “array” is required.

7. How many optional arguments does =UNIQUE have?

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

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

8. In =UNIQUE, which is argument #2?

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

Explanation: Argument #2 is “by_col]”.

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

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

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

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

A. criteria
B. by_col]
C. exactly_once] ✓
D. lookup_value

Explanation: Argument #3 is “exactly_once]”.