Database =DCOUNTA(database, field, criteria)

Quiz =DCOUNTA — 15 Questions

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

Question 1 of 15 1/15

Which use case fits =DCOUNTA?

Question 2 of 15 2/15

Since which Excel version is =DCOUNTA available?

Question 3 of 15 3/15

What is the type of argument “database” in =DCOUNTA?

Question 4 of 15 4/15

Which function is NOT related to =DCOUNTA?

Question 5 of 15 5/15

Which formula is a valid example of =DCOUNTA?

Question 6 of 15 6/15

Is argument “database” required in =DCOUNTA?

Question 7 of 15 7/15

What is the output type of =DCOUNTA?

Question 8 of 15 8/15

In =DCOUNTA, which is argument #2?

Question 9 of 15 9/15

Is argument “criteria” required in =DCOUNTA?

Question 10 of 15 10/15

Which category does =DCOUNTA belong to?

Question 11 of 15 11/15

In =DCOUNTA, which is argument #1?

Question 12 of 15 12/15

Which statement about =DCOUNTA is correct?

Question 13 of 15 13/15

What is the type of argument “criteria” in =DCOUNTA?

Question 14 of 15 14/15

How many arguments does =DCOUNTA have in total?

Question 15 of 15 15/15

Is =DCOUNTA volatile?

Click a question to see the answer.

1. Which use case fits =DCOUNTA?

A. External Data, Web & Cube
B. Daily Tasks
C. Conditional Aggregation ✓
D. Reporting

Explanation: Use case “Conditional Aggregation” fits DCOUNTA.

2. Since which Excel version is =DCOUNTA available?

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

Explanation: Version: “All versions”.

3. What is the type of argument “database” in =DCOUNTA?

A. Range ✓
B. Date
C. Logical
D. Value

Explanation: Type of “database” is “Range”.

4. Which function is NOT related to =DCOUNTA?

A. ODDFYIELD ✓
B. DCOUNT
C. DSUM
D. DGET

Explanation: “ODDFYIELD” is not related to DCOUNTA.

5. Which formula is a valid example of =DCOUNTA?

A. DCOUNTA(A4:E10, "Profit", A1:F2)
B. =DCOUNT(A4:E10, "Profit", A1:F2)
C. =DCOUNTA(A4:E10, "Profit", A1:F2, 0)
D. =DCOUNTA(A4:E10, "Profit", A1:F2) ✓

Explanation: Correct example: =DCOUNTA(A4:E10, "Profit", A1:F2)

6. Is argument “database” required in =DCOUNTA?

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

Explanation: “database” is required.

7. What is the output type of =DCOUNTA?

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

Explanation: Output is “Number”.

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

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

Explanation: Argument #2 is “field”.

9. Is argument “criteria” required in =DCOUNTA?

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

Explanation: “criteria” is required.

10. Which category does =DCOUNTA belong to?

A. Financial
B. Database ✓
C. Engineering
D. Information

Explanation: Category is “Database”.

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

A. database ✓
B. range
C. value
D. lookup_value

Explanation: Argument #1 is “database”.

12. Which statement about =DCOUNTA is correct?

A. Output is always a dynamic array
B. 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. ✓
C. Make sure that the criteria range does not overlap the list.
D. Only works in old versions

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.

13. What is the type of argument “criteria” in =DCOUNTA?

A. Text
B. Range ✓
C. Logical
D. Date

Explanation: Type of “criteria” is “Range”.

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

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

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

15. Is =DCOUNTA volatile?

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

Explanation: DCOUNTA is not volatile.