Database =DCOUNT(database, field, criteria)

Quiz =DCOUNT — 10 Questions

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

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

← DCOUNT ▦ Practice in Playground

Progress — 10 questions 1 of 10

Question 1 of 10 1/10

How many required arguments does =DCOUNT have?

Question 2 of 10 2/10

Is =DCOUNT volatile?

Question 3 of 10 3/10

Does =DCOUNT return a dynamic array?

Question 4 of 10 4/10

Since which Excel version is =DCOUNT available?

Question 5 of 10 5/10

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

Question 6 of 10 6/10

Which formula is a valid example of =DCOUNT?

Question 7 of 10 7/10

Is argument “field” required in =DCOUNT?

Question 8 of 10 8/10

In =DCOUNT, which is argument #1?

Question 9 of 10 9/10

Is argument “criteria” required in =DCOUNT?

Question 10 of 10 10/10

Which statement about =DCOUNT is correct?

Click a question to see the answer.

1. How many required arguments does =DCOUNT have?

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

Explanation: =DCOUNT has 3 required, 0 optional (3 total).

2. Is =DCOUNT volatile?

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

Explanation: DCOUNT is not volatile.

3. Does =DCOUNT return a dynamic array?

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

Explanation: DCOUNT does not spill.

4. Since which Excel version is =DCOUNT available?

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

Explanation: Version: “All versions”.

5. What is the type of argument “criteria” in =DCOUNT?

A. Number
B. Logical
C. Range ✓
D. Reference

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

6. Which formula is a valid example of =DCOUNT?

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

Explanation: Correct example: =DCOUNT(A4:E10, "Age", A1:F2)

7. Is argument “field” required in =DCOUNT?

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

Explanation: “field” is required.

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

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

Explanation: Argument #1 is “database”.

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

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

Explanation: “criteria” is required.

10. Which statement about =DCOUNT is correct?

A. 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. ✓
B. Requires add-in
C. Volatile and recalculates every time
D. To perform an operation on an entire column in a database, enter a blank line below the column labels in the criteria range.

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.