Statistical =COUNT(value1, [value2], ...)

Quiz =COUNT — 10 Questions

10 quiz questions about =COUNT — test syntax, arguments, examples & errors!

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

← COUNT ▦ Practice in Playground

Progress — 10 questions 1 of 10

Question 1 of 10 1/10

What is the type of argument “value2” in =COUNT?

Question 2 of 10 2/10

How many optional arguments does =COUNT have?

Question 3 of 10 3/10

Which formula is a valid example of =COUNT?

Question 4 of 10 4/10

Is =COUNT volatile?

Question 5 of 10 5/10

Which function is related to =COUNT?

Question 6 of 10 6/10

How many required arguments does =COUNT have?

Question 7 of 10 7/10

Is argument “value2” required in =COUNT?

Question 8 of 10 8/10

Which is the correct syntax of =COUNT?

Question 9 of 10 9/10

In =COUNT, which is argument #1?

Question 10 of 10 10/10

Which statement about =COUNT is correct?

Click a question to see the answer.

1. What is the type of argument “value2” in =COUNT?

A. Date
B. Any type ✓
C. Number
D. Array

Explanation: Type of “value2” is “Any type”.

2. How many optional arguments does =COUNT have?

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

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

3. Which formula is a valid example of =COUNT?

A. =COUNTA(A2:A6)
B. =COUNT(A2:A6) ✓
C. COUNT(A2:A6)
D. =COUNT(A2:A6, 0)

Explanation: Correct example: =COUNT(A2:A6)

4. Is =COUNT volatile?

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

Explanation: COUNT is not volatile.

5. Which function is related to =COUNT?

A. SERIESSUM
B. QUOTIENT
C. COUNTA ✓
D. GROUPBY

Explanation: “COUNTA” is related to COUNT.

6. How many required arguments does =COUNT have?

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

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

7. Is argument “value2” required in =COUNT?

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

Explanation: “value2” is optional.

8. Which is the correct syntax of =COUNT?

A. =COUNT(value1, [value2], ..., 0)
B. =COUNTA(value1, [value2], ...)
C. =COUNT(value1, [value2], ...) ✓
D. COUNT(value1, [value2], ...)

Explanation: Correct syntax: =COUNT(value1, [value2], ...)

9. In =COUNT, which is argument #1?

A. criteria
B. range
C. value2
D. value1 ✓

Explanation: Argument #1 is “value1”.

10. Which statement about =COUNT is correct?

A. Arguments that are numbers, dates, or a text representation of numbers (for example, a number enclosed in quotation marks, such as "1") are counted. ✓
B. If you want to count logical values, text, or error values, use the COUNTA function.
C. If you want to count only numbers that meet certain criteria, use the COUNTIF function or the COUNTIFS function.
D. Select entire column for best performance

Explanation: Correct: Arguments that are numbers, dates, or a text representation of numbers (for example, a number enclosed in quotation marks, such as "1") are counted.