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

Quiz =MODE — 10 Questions

10 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 — 10 questions 1 of 10

Question 1 of 10 1/10

Which function is NOT related to =MODE?

Question 2 of 10 2/10

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

Question 3 of 10 3/10

In =MODE, which is argument #1?

Question 4 of 10 4/10

Which statement about =MODE is correct?

Question 5 of 10 5/10

Since which Excel version is =MODE available?

Question 6 of 10 6/10

Does =MODE return a dynamic array?

Question 7 of 10 7/10

How many required arguments does =MODE have?

Question 8 of 10 8/10

Which function is related to =MODE?

Question 9 of 10 9/10

How many optional arguments does =MODE have?

Question 10 of 10 10/10

Which use case fits =MODE?

Click a question to see the answer.

1. Which function is NOT related to =MODE?

A. COUNTIF
B. MEDIAN
C. AVERAGE
D. BINOM.DIST.RANGE ✓

Explanation: “BINOM.DIST.RANGE” is not related to MODE.

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

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

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

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

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

Explanation: Argument #1 is “number1”.

4. Which statement about =MODE is correct?

A. 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. ✓
B. Volatile and recalculates every time
C. Mode The most frequently occurring number in a group of numbers. For example, the mode of 2, 3, 3, 5, 7, and 10 is 3.
D. Requires add-in

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.

5. Since which Excel version is =MODE available?

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

Explanation: Version: “All versions”.

6. Does =MODE return a dynamic array?

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

Explanation: MODE does not spill.

7. How many required arguments does =MODE have?

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

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

8. Which function is related to =MODE?

A. COUNTIF ✓
B. LOWER
C. ENCODEURL
D. POWER

Explanation: “COUNTIF” is related to MODE.

9. How many optional arguments does =MODE have?

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

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

10. Which use case fits =MODE?

A. Daily Tasks
B. Descriptive Statistics ✓
C. Comparation
D. Data Cleaning

Explanation: Use case “Descriptive Statistics” fits MODE.