Compatibility =MODE(number1,[number2],...)

Quiz =MODE — 15 Questions

15 quiz questions about =MODE — test syntax, arguments, examples & errors!

Questions: 10 questions 15 questions Random 10 or 15 questions from the pool + shuffled options each time

← MODE ▦ Practice in Playground

Progress — 15 questions 1 of 15

Question 1 of 15 1/15

What is the type of argument “number1” in =MODE?

Question 2 of 15 2/15

What is the output type of =MODE?

Question 3 of 15 3/15

How many arguments does =MODE have in total?

Question 4 of 15 4/15

What is the type of argument “number2” in =MODE?

Question 5 of 15 5/15

In =MODE, which is argument #1?

Question 6 of 15 6/15

What is the fix for #N/A in =MODE?

Question 7 of 15 7/15

Which is the correct syntax of =MODE?

Question 8 of 15 8/15

Which statement about =MODE is correct?

Question 9 of 15 9/15

How many required arguments does =MODE have?

Question 10 of 15 10/15

Which category does =MODE belong to?

Question 11 of 15 11/15

Which formula is a valid example of =MODE?

Question 12 of 15 12/15

Since which Excel version is =MODE available?

Question 13 of 15 13/15

Is argument “number2” required in =MODE?

Question 14 of 15 14/15

Is argument “number1” required in =MODE?

Question 15 of 15 15/15

Does =MODE return a dynamic array?

Click a question to see the answer.

1. What is the type of argument “number1” in =MODE?

A. Mixed
B. Date
C. Number ✓
D. Array

Explanation: Type of “number1” is “Number”.

2. What is the output type of =MODE?

A. Reference
B. Number ✓
C. Mixed
D. Date

Explanation: Output is “Number”.

3. How many arguments does =MODE have in total?

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

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

4. What is the type of argument “number2” in =MODE?

A. Date
B. Array
C. Mixed
D. Number ✓

Explanation: Type of “number2” is “Number”.

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

A. number2
B. value
C. range
D. number1 ✓

Explanation: Argument #1 is “number1”.

6. What is the fix for #N/A in =MODE?

A. Text is always ignored
B. Output is always a dynamic array
C. Only works in old versions
D. Check the data or handle the error with IFNA ✓

Explanation: If the data set contains no duplicate data points, MODE returns the #N/A error value. — Fix: Check the data or handle the error with IFNA

7. Which is the correct syntax of =MODE?

A. =COUNTIF(number1,[number2],...)
B. =MODE(number1,[number2],..., 0)
C. MODE(number1,[number2],...)
D. =MODE(number1,[number2],...) ✓

Explanation: Correct syntax: =MODE(number1,[number2],...)

8. Which statement about =MODE is correct?

A. Text is always ignored
B. Output is always a dynamic array
C. Arguments that are error values or text that can't be translated into numbers cause errors.
D. This function has been replaced with one or more new functions that may provide improved accuracy and whose names better reflect their usage. Although this function is still available for backward compatibility, you should consider using the new functions from now on, because this function may not be available in future versions of Excel. ✓

Explanation: Correct: This function has been replaced with one or more new functions that may provide improved accuracy and whose names better reflect their usage. Although this function is still available for backward compatibility, you should consider using the new functions from now on, because this function may not be available in future versions of Excel.

9. How many required arguments does =MODE have?

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

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

10. Which category does =MODE belong to?

A. Compatibility ✓
B. Statistical
C. Text
D. Logical

Explanation: Category is “Compatibility”.

11. Which formula is a valid example of =MODE?

A. MODE(A2:A7)
B. =MODE(A2:A7) ✓
C. =COUNTIF(A2:A7)
D. =MODE(A2:A7, 0)

Explanation: Correct example: =MODE(A2:A7)

12. Since which Excel version is =MODE available?

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

Explanation: Version: “All versions”.

13. Is argument “number2” required in =MODE?

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

Explanation: “number2” is optional.

14. Is argument “number1” required in =MODE?

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

Explanation: “number1” is required.

15. Does =MODE return a dynamic array?

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

Explanation: MODE does not spill.