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

How many arguments does =MODE have in total?

Question 2 of 15 2/15

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

Question 3 of 15 3/15

Which use case fits =MODE?

Question 4 of 15 4/15

How many optional arguments does =MODE have?

Question 5 of 15 5/15

Which formula is a valid example of =MODE?

Question 6 of 15 6/15

Which function is NOT related to =MODE?

Question 7 of 15 7/15

Since which Excel version is =MODE available?

Question 8 of 15 8/15

Is argument “number2” required in =MODE?

Question 9 of 15 9/15

Which statement about =MODE is correct?

Question 10 of 15 10/15

In =MODE, which is argument #1?

Question 11 of 15 11/15

What is the output type of =MODE?

Question 12 of 15 12/15

In =MODE, which is argument #2?

Question 13 of 15 13/15

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

Question 14 of 15 14/15

How many required arguments does =MODE have?

Question 15 of 15 15/15

Which is the correct syntax of =MODE?

Click a question to see the answer.

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

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

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

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

A. Output is always a dynamic array
B. Only works in old versions
C. Check the data or handle the error with IFNA ✓
D. Volatile and recalculates every time

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

3. Which use case fits =MODE?

A. Descriptive Statistics ✓
B. Daily Tasks
C. Worksheet Info & Navigation
D. Conditional Logic

Explanation: Use case “Descriptive Statistics” fits MODE.

4. How many optional arguments does =MODE have?

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

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

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

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

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

6. Which function is NOT related to =MODE?

A. AVERAGE
B. MEDIAN
C. CUBESET ✓
D. COUNTIF

Explanation: “CUBESET” is not related to MODE.

7. Since which Excel version is =MODE available?

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

Explanation: Version: “All versions”.

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

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

Explanation: “number2” is optional.

9. Which statement about =MODE is correct?

A. Output is always a dynamic array
B. The MODE function measures central tendency, which is the location of the center of a group of numbers in a statistical distribution. The three most common measures of central tendency are:
C. Requires add-in
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.

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

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

Explanation: Argument #1 is “number1”.

11. What is the output type of =MODE?

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

Explanation: Output is “Number”.

12. In =MODE, which is argument #2?

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

Explanation: Argument #2 is “number2”.

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

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

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

14. How many required arguments does =MODE have?

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

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

15. Which is the correct syntax of =MODE?

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

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