Database =DCOUNTA(database, field, criteria)

Quiz =DCOUNTA — 10 Questions

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

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

← DCOUNTA ▦ Practice in Playground

Progress — 10 questions 1 of 10

Question 1 of 10 1/10

How many arguments does =DCOUNTA have in total?

Question 2 of 10 2/10

Which statement about =DCOUNTA is correct?

Question 3 of 10 3/10

Which is the correct syntax of =DCOUNTA?

Question 4 of 10 4/10

Which use case fits =DCOUNTA?

Question 5 of 10 5/10

What is the output type of =DCOUNTA?

Question 6 of 10 6/10

Does =DCOUNTA return a dynamic array?

Question 7 of 10 7/10

Which function is related to =DCOUNTA?

Question 8 of 10 8/10

In =DCOUNTA, which is argument #3?

Question 9 of 10 9/10

How many required arguments does =DCOUNTA have?

Question 10 of 10 10/10

Is =DCOUNTA volatile?

Click a question to see the answer.

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

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

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

2. Which statement about =DCOUNTA is correct?

A. Requires add-in
B. To perform an operation on an entire column in a database, enter a blank line below the column labels in the criteria range.
C. Volatile and recalculates every time
D. You can use any range for the criteria argument, as long as it includes at least one column label and at least one cell below the column label for specifying the condition. For example, if the range G1:G2 contains the column label Income in G1 and the amount $10,000 in G2, you could define the range as MatchIncome and use that name as the criteria argument in the database functions. ✓

Explanation: Correct: You can use any range for the criteria argument, as long as it includes at least one column label and at least one cell below the column label for specifying the condition. For example, if the range G1:G2 contains the column label Income in G1 and the amount $10,000 in G2, you could define the range as MatchIncome and use that name as the criteria argument in the database functions.

3. Which is the correct syntax of =DCOUNTA?

A. DCOUNTA(database, field, criteria)
B. =DCOUNTA(database, field, criteria) ✓
C. =DCOUNTA(database, field, criteria, 0)
D. =DCOUNT(database, field, criteria)

Explanation: Correct syntax: =DCOUNTA(database, field, criteria)

4. Which use case fits =DCOUNTA?

A. Conditional Aggregation ✓
B. Conditional Formatting & Validation
C. Data Cleaning
D. Dynamic Ranges & Dashboards

Explanation: Use case “Conditional Aggregation” fits DCOUNTA.

5. What is the output type of =DCOUNTA?

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

Explanation: Output is “Number”.

6. Does =DCOUNTA return a dynamic array?

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

Explanation: DCOUNTA does not spill.

7. Which function is related to =DCOUNTA?

A. LCM
B. SHEET
C. DCOUNT ✓
D. MAXA

Explanation: “DCOUNT” is related to DCOUNTA.

8. In =DCOUNTA, which is argument #3?

A. range
B. database
C. field
D. criteria ✓

Explanation: Argument #3 is “criteria”.

9. How many required arguments does =DCOUNTA have?

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

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

10. Is =DCOUNTA volatile?

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

Explanation: DCOUNTA is not volatile.