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 that meet certain criteria in a database. It takes three arguments: the database range, the field to count, and the criteria range. In this case, A6:F357 is the database range, A3 is the field to count (which is a "wildcard" or placeholder field indicating that we're just counting records, not looking at a specific field), and A363:F365 is the criteria range. This means we're counting the number of records in the database that meet the criteria specified in that range, which is presumably a set of filters based on client data.

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