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

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

Question 2 of 10 2/10

Which use case fits =MODE?

Question 3 of 10 3/10

Is =MODE volatile?

Question 4 of 10 4/10

Which is the correct syntax of =MODE?

Question 5 of 10 5/10

How many arguments does =MODE have in total?

Question 6 of 10 6/10

Which statement about =MODE is correct?

Question 7 of 10 7/10

How many required arguments does =MODE have?

Question 8 of 10 8/10

Which function is NOT related to =MODE?

Question 9 of 10 9/10

What is the output type of =MODE?

Question 10 of 10 10/10

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

Click a question to see the answer.

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

A. Check the data or handle the error with IFNA ✓
B. Only works in old versions
C. Output is always a dynamic array
D. Select entire column for best performance

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

2. Which use case fits =MODE?

A. Error Handling
B. Descriptive Statistics ✓
C. Securities & Bonds
D. External Data, Web & Cube

Explanation: Use case “Descriptive Statistics” fits MODE.

3. Is =MODE volatile?

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

Explanation: MODE is not volatile.

4. Which is the correct syntax of =MODE?

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

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

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

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

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

6. Which statement about =MODE is correct?

A. Median The middle number of a group of numbers; that is, half the numbers have values that are greater than the median, and half the numbers have values that are less than the median. For example, the median of 2, 3, 3, 5, 7, and 10 is 4.
B. 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. ✓
C. Requires add-in
D. For a symmetrical distribution of a group of numbers, these three measures of central tendency are all the same. For a skewed distribution of a group of numbers, they can be different.

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.

7. How many required arguments does =MODE have?

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

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

8. Which function is NOT related to =MODE?

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

Explanation: “HSTACK” is not related to MODE.

9. What is the output type of =MODE?

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

Explanation: Output is “Number”.

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

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

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