You need to know how many clients you have in a dataset with these fields in these ranges.Criteria are in A363:
F365.

Which function would accomplish this task?
A)DCOUNT(A6:F357,A3,A363:F365)
B)DCOUNT(A6:F357,A365:F363:G365)
C)DMIN(A6:F357,G365,A363:F365)
D)DMAX(A6:F357,G365,A363:F365)

Question

You need to know how many clients you have in a dataset with these fields in these ranges.Criteria are in A363:
F365.

Which function would accomplish this task?
A)DCOUNT(A6:F357,A3,A363:F365) 
B)DCOUNT(A6:F357,A365:F363:G365) 
C)DMIN(A6:F357,G365,A363:F365) 
D)DMAX(A6:F357,G365,A363:F365)

Quizplus · Accepted Answer

The function DCOUNT is used to count the number of records in a database that meets specific criteria. In this case, the criteria are in cell A363:F365, which contains the field names and ranges. The range of data to be counted is A6:F357, which contains the client information. Option A is the only one that correctly uses the DCOUNT function with the appropriate arguments, so it is the best choice.

You Need to Know How Many Clients You Have in a Dataset