Statistical =MODE.SNGL(number1,[number2],...)

Quiz =MODE.SNGL — 15 Questions

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

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

← MODE.SNGL ▦ Practice in Playground

Progress — 15 questions 1 of 15

Question 1 of 15 1/15

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

Question 2 of 15 2/15

What usually causes #N/A in =MODE.SNGL?

Question 3 of 15 3/15

Which use case fits =MODE.SNGL?

Question 4 of 15 4/15

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

Question 5 of 15 5/15

Which statement about =MODE.SNGL is correct?

Question 6 of 15 6/15

Which is the correct syntax of =MODE.SNGL?

Question 7 of 15 7/15

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

Question 8 of 15 8/15

How many required arguments does =MODE.SNGL have?

Question 9 of 15 9/15

Which function is related to =MODE.SNGL?

Question 10 of 15 10/15

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

Question 11 of 15 11/15

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

Question 12 of 15 12/15

Is =MODE.SNGL volatile?

Question 13 of 15 13/15

Does =MODE.SNGL return a dynamic array?

Question 14 of 15 14/15

How many optional arguments does =MODE.SNGL have?

Question 15 of 15 15/15

Which function is NOT related to =MODE.SNGL?

Click a question to see the answer.

1. Is argument “number2” required in =MODE.SNGL?

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

Explanation: “number2” is optional.

2. What usually causes #N/A in =MODE.SNGL?

A. If the data set contains no duplicate data points, MODE.SNGL returns the #N/A error value. ✓
B. Output is always a dynamic array
C. Text is always ignored
D. Volatile and recalculates every time

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

3. Which use case fits =MODE.SNGL?

A. Reporting
B. Ranking & Top N
C. Rounding & Numeric
D. Descriptive Statistics ✓

Explanation: Use case “Descriptive Statistics” fits MODE.SNGL.

4. Is argument “number1” required in =MODE.SNGL?

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

Explanation: “number1” is required.

5. Which statement about =MODE.SNGL is correct?

A. Median which is 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. Arguments can either be numbers or names, arrays, or references that contain numbers. ✓
C. Requires add-in
D. Average which is 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: Arguments can either be numbers or names, arrays, or references that contain numbers.

6. Which is the correct syntax of =MODE.SNGL?

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

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

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

A. Requires add-in
B. Only works in old versions
C. Output is always a dynamic array
D. Check the data or use IFNA ✓

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

8. How many required arguments does =MODE.SNGL have?

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

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

9. Which function is related to =MODE.SNGL?

A. AREAS
B. GAMMAINV
C. AVERAGE ✓
D. BITOR

Explanation: “AVERAGE” is related to MODE.SNGL.

10. In =MODE.SNGL, which is argument #2?

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

Explanation: Argument #2 is “number2”.

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

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

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

12. Is =MODE.SNGL volatile?

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

Explanation: MODE.SNGL is not volatile.

13. Does =MODE.SNGL return a dynamic array?

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

Explanation: MODE.SNGL does not spill.

14. How many optional arguments does =MODE.SNGL have?

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

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

15. Which function is NOT related to =MODE.SNGL?

A. AVERAGE
B. MIRR ✓
C. MEDIAN
D. MODE

Explanation: “MIRR” is not related to MODE.SNGL.