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

Which category does =UNIQUE belong to?

Question 3 of 15 3/15

Which statement about =UNIQUE is correct?

Question 4 of 15 4/15

Which function is related to =UNIQUE?

Question 5 of 15 5/15

Is =UNIQUE volatile?

Question 6 of 15 6/15

In =UNIQUE, which is argument #2?

Question 7 of 15 7/15

How many required arguments does =UNIQUE have?

Question 8 of 15 8/15

Which is the correct syntax of =UNIQUE?

Question 9 of 15 9/15

Is argument “exactly_once]” required in =UNIQUE?

Question 10 of 15 10/15

How many optional arguments does =UNIQUE have?

Question 11 of 15 11/15

Since which Excel version is =UNIQUE available?

Question 12 of 15 12/15

Is argument “array” required in =UNIQUE?

Question 13 of 15 13/15

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

Question 14 of 15 14/15

Which use case fits =UNIQUE?

Question 15 of 15 15/15

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

Click a question to see the answer.

1. What is the output type of =UNIQUE?

A. Value
B. Array ✓
C. Date
D. Reference

Explanation: Output is “Array”.

2. Which category does =UNIQUE belong to?

A. Lookup & Reference ✓
B. Statistical
C. Database
D. Information

Explanation: Category is “Lookup & Reference”.

3. 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. Volatile and recalculates every time
C. Output is always a dynamic array
D. Only works in old versions

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

4. Which function is related to =UNIQUE?

A. PMT
B. TRANSLATE
C. FILTER ✓
D. IMSIN

Explanation: “FILTER” is related to UNIQUE.

5. Is =UNIQUE volatile?

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

Explanation: UNIQUE is not volatile.

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

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

Explanation: Argument #2 is “by_col]”.

7. How many required arguments does =UNIQUE have?

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

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

8. Which is the correct syntax of =UNIQUE?

A. =FILTER(array,[by_col],[exactly_once])
B. =UNIQUE(array,[by_col],[exactly_once]) ✓
C. UNIQUE(array,[by_col],[exactly_once])
D. =UNIQUE(array,[by_col],[exactly_once], 0)

Explanation: Correct syntax: =UNIQUE(array,[by_col],[exactly_once])

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

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

Explanation: “exactly_once]” is optional.

10. How many optional arguments does =UNIQUE have?

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

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

11. Since which Excel version is =UNIQUE available?

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

Explanation: Version: “Excel 2021”.

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

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

Explanation: “array” is required.

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

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

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

14. Which use case fits =UNIQUE?

A. Investment Appraisal
B. Daily Tasks ✓
C. Lookup & Retrieval
D. External Data, Web & Cube

Explanation: Use case “Daily Tasks” fits UNIQUE.

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

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

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