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

Which use case fits =COUNTA?

Question 3 of 10 3/10

In =COUNTA, which is argument #2?

Question 4 of 10 4/10

Which is the correct syntax of =COUNTA?

Question 5 of 10 5/10

How many arguments does =COUNTA have in total?

Question 6 of 10 6/10

Which function is related to =COUNTA?

Question 7 of 10 7/10

Which statement about =COUNTA is correct?

Question 8 of 10 8/10

In =COUNTA, which is argument #1?

Question 9 of 10 9/10

Is =COUNTA volatile?

Question 10 of 10 10/10

Does =COUNTA return a dynamic array?

Click a question to see the answer.

1. How many optional arguments does =COUNTA have?

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

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

2. Which use case fits =COUNTA?

A. Daily Tasks ✓
B. Descriptive Statistics
C. Financial Calculations
D. Reporting

Explanation: Use case “Daily Tasks” fits COUNTA.

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

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

Explanation: Argument #2 is “value2”.

4. Which is the correct syntax of =COUNTA?

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

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

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

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

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

6. Which function is related to =COUNTA?

A. LEFTB
B. RRI
C. COUNT ✓
D. TBILLPRICE

Explanation: “COUNT” is related to COUNTA.

7. Which statement about =COUNTA is correct?

A. 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.
B. 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. ✓
C. If you want to count only cells that meet certain criteria, use the COUNTIF function or the COUNTIFS function.
D. Output is always a dynamic array

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.

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

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

Explanation: Argument #1 is “value1”.

9. Is =COUNTA volatile?

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

Explanation: COUNTA is not volatile.

10. Does =COUNTA return a dynamic array?

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

Explanation: COUNTA does not spill.