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

How many arguments does =MODE have in total?

Question 3 of 10 3/10

Which statement about =MODE is correct?

Question 4 of 10 4/10

Which formula is a valid example of =MODE?

Question 5 of 10 5/10

What is the output type of =MODE?

Question 6 of 10 6/10

Which category does =MODE belong to?

Question 7 of 10 7/10

Which function is related to =MODE?

Question 8 of 10 8/10

Is argument “number1” required in =MODE?

Question 9 of 10 9/10

Which is the correct syntax of =MODE?

Question 10 of 10 10/10

Is argument “number2” required in =MODE?

Click a question to see the answer.

1. Which function is NOT related to =MODE?

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

Explanation: “ROUNDUP” is not related to MODE.

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

3. Which statement about =MODE is correct?

A. 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.
B. Text is always ignored
C. 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. ✓
D. Average The arithmetic mean and is calculated by adding a group of numbers and then dividing by the count of those numbers. For example, the average of 2, 3, 3, 5, 7, and 10 is 30 divided by 6, which is 5.

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.

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

5. What is the output type of =MODE?

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

Explanation: Output is “Number”.

6. Which category does =MODE belong to?

A. Compatibility ✓
B. Engineering
C. Cube
D. Text

Explanation: Category is “Compatibility”.

7. Which function is related to =MODE?

A. VAR
B. WEEKNUM
C. ATAN2
D. COUNTIF ✓

Explanation: “COUNTIF” is related to MODE.

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

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

Explanation: “number1” is required.

9. 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],...)

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

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

Explanation: “number2” is optional.