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

Quiz =COUNTA — 15 Questions

15 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 — 15 questions 1 of 15

Question 1 of 15 1/15

How many arguments does =COUNTA have in total?

Question 2 of 15 2/15

In =COUNTA, which is argument #2?

Question 3 of 15 3/15

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

Question 4 of 15 4/15

Is =COUNTA volatile?

Question 5 of 15 5/15

Which use case fits =COUNTA?

Question 6 of 15 6/15

Which statement about =COUNTA is correct?

Question 7 of 15 7/15

Since which Excel version is =COUNTA available?

Question 8 of 15 8/15

How many optional arguments does =COUNTA have?

Question 9 of 15 9/15

Does =COUNTA return a dynamic array?

Question 10 of 15 10/15

Which function is related to =COUNTA?

Question 11 of 15 11/15

In =COUNTA, which is argument #1?

Question 12 of 15 12/15

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

Question 13 of 15 13/15

Which formula is a valid example of =COUNTA?

Question 14 of 15 14/15

Which function is NOT related to =COUNTA?

Question 15 of 15 15/15

Is argument “value2” required in =COUNTA?

Click a question to see the answer.

1. How many arguments does =COUNTA have in total?

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

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

2. In =COUNTA, which is argument #2?

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

Explanation: Argument #2 is “value2”.

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

A. Date
B. Mixed
C. Logical
D. Any type ✓

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

4. Is =COUNTA volatile?

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

Explanation: COUNTA is not volatile.

5. Which use case fits =COUNTA?

A. Sort, Filter & Dedupe
B. Daily Tasks ✓
C. Advanced Formulas
D. Data Cleaning

Explanation: Use case “Daily Tasks” fits COUNTA.

6. 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 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.
C. Volatile and recalculates every time
D. Only works in old versions

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.

7. Since which Excel version is =COUNTA available?

A. All versions ✓
B. Excel 365
C. Excel 2019
D. Excel 2007 (Compatibility)

Explanation: Version: “All versions”.

8. How many optional arguments does =COUNTA have?

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

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

9. Does =COUNTA return a dynamic array?

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

Explanation: COUNTA does not spill.

10. Which function is related to =COUNTA?

A. T.TEST
B. PRICEMAT
C. STDEV
D. COUNT ✓

Explanation: “COUNT” is related to COUNTA.

11. In =COUNTA, which is argument #1?

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

Explanation: Argument #1 is “value1”.

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

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

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

13. Which formula is a valid example of =COUNTA?

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

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

14. Which function is NOT related to =COUNTA?

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

Explanation: “TDIST” is not related to COUNTA.

15. Is argument “value2” required in =COUNTA?

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

Explanation: “value2” is optional.