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

Quiz =COUNTA — 10 Questions

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

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

← COUNTA ▦ Practice in Playground

Progress — 10 questions 1 of 10

Question 1 of 10 1/10

How many optional arguments does =COUNTA have?

Question 2 of 10 2/10

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

Question 3 of 10 3/10

How many required arguments does =COUNTA have?

Question 4 of 10 4/10

Is argument “value1” required in =COUNTA?

Question 5 of 10 5/10

Which function is NOT related to =COUNTA?

Question 6 of 10 6/10

Which use case fits =COUNTA?

Question 7 of 10 7/10

Is =COUNTA volatile?

Question 8 of 10 8/10

What is the type of argument “value1” in =COUNTA?

Question 9 of 10 9/10

Which statement about =COUNTA is correct?

Question 10 of 10 10/10

What is the output type of =COUNTA?

Click a question to see the answer.

1. How many optional arguments does =COUNTA have?

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

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

2. What is the type of argument “value2” in =COUNTA?

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

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

3. How many required arguments does =COUNTA have?

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

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

4. Is argument “value1” required in =COUNTA?

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

Explanation: “value1” is required.

5. Which function is NOT related to =COUNTA?

A. COUNT
B. COUNTBLANK
C. T ✓
D. ROWS

Explanation: “T” is not related to COUNTA.

6. Which use case fits =COUNTA?

A. Comparation
B. Daily Tasks ✓
C. Forecasting & Trends
D. Workdays & Due Dates

Explanation: Use case “Daily Tasks” fits COUNTA.

7. Is =COUNTA volatile?

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

Explanation: COUNTA is not volatile.

8. What is the type of argument “value1” in =COUNTA?

A. Reference
B. Value
C. Any type ✓
D. Date

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

9. Which statement about =COUNTA is correct?

A. The COUNTA function counts cells containing any type of information, including error values and empty text (""). For example, if the range contains a formula that returns an empty string, the COUNTA function counts that value. The COUNTA function does not count empty cells. ✓
B. If you want to count only cells that meet certain criteria, use the COUNTIF function or the COUNTIFS function.
C. If you do not need to count logical values, text, or error values (in other words, if you want to count only cells that contain numbers), use the COUNT function.
D. Select entire column for best performance

Explanation: Correct: The COUNTA function counts cells containing any type of information, including error values and empty text (""). For example, if the range contains a formula that returns an empty string, the COUNTA function counts that value. The COUNTA function does not count empty cells.

10. What is the output type of =COUNTA?

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

Explanation: Output is “Number”.