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

In =UNIQUE, which is argument #3?

Question 2 of 15 2/15

Does =UNIQUE return a dynamic array?

Question 3 of 15 3/15

Which function is related to =UNIQUE?

Question 4 of 15 4/15

Which is the correct syntax of =UNIQUE?

Question 5 of 15 5/15

Since which Excel version is =UNIQUE available?

Question 6 of 15 6/15

Is =UNIQUE volatile?

Question 7 of 15 7/15

Is argument “by_col]” required in =UNIQUE?

Question 8 of 15 8/15

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

Question 9 of 15 9/15

In =UNIQUE, which is argument #1?

Question 10 of 15 10/15

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

Question 11 of 15 11/15

Which use case fits =UNIQUE?

Question 12 of 15 12/15

How many arguments does =UNIQUE have in total?

Question 13 of 15 13/15

Which statement about =UNIQUE is correct?

Question 14 of 15 14/15

In =UNIQUE, which is argument #2?

Question 15 of 15 15/15

How many required arguments does =UNIQUE have?

Click a question to see the answer.

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

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

Explanation: Argument #3 is “exactly_once]”.

2. Does =UNIQUE return a dynamic array?

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

Explanation: UNIQUE spills as a dynamic array.

3. Which function is related to =UNIQUE?

A. CHITEST
B. BESSELJ
C. FILTER ✓
D. FORECAST.ETS.CONFINT

Explanation: “FILTER” is related to UNIQUE.

4. Which is the correct syntax of =UNIQUE?

A. =UNIQUE(array,[by_col],[exactly_once]) ✓
B. =FILTER(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])

5. Since which Excel version is =UNIQUE available?

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

Explanation: Version: “Excel 2021”.

6. Is =UNIQUE volatile?

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

Explanation: UNIQUE is not volatile.

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

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

Explanation: “by_col]” is optional.

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

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

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

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

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

Explanation: Argument #1 is “array”.

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

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

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

11. Which use case fits =UNIQUE?

A. Error Handling
B. Investment Appraisal
C. Workdays & Due Dates
D. Daily Tasks ✓

Explanation: Use case “Daily Tasks” fits UNIQUE.

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

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

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

13. Which statement about =UNIQUE is correct?

A. Volatile and recalculates every time
B. Requires add-in
C. 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)) ✓
D. Select entire column for best performance

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

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

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

Explanation: Argument #2 is “by_col]”.

15. How many required arguments does =UNIQUE have?

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

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