QUESTION IMAGE
Question
matching database functions
match the database function to its purpose.
daverage
dmax
dmin
dcount
dsum
adds the numbers in a field of records in a
database that matches conditions
finds the largest number in a database that
matches conditions
averages values in a field of records in a
database that matches conditions
counts the cells that contain numbers in a
database that matches conditions
finds the smallest number in a database that
matches conditions
Step1: Analyze DAVERAGE
DAVERAGE is a database function. The "AVERAGE" part implies it calculates the average. So it should match "averages values in a field of records in a database that matches conditions".
Step2: Analyze DMAX
The "MAX" part means maximum. So DMAX finds the largest number in a database that matches conditions.
Step3: Analyze DMIN
The "MIN" part means minimum. So DMIN finds the smallest number in a database that matches conditions.
Step4: Analyze DCOUNT
The "COUNT" part means counting. So DCOUNT counts the cells that contain numbers in a database that matches conditions.
Step5: Analyze DSUM
The "SUM" part means sum. So DSUM adds the numbers in a field of records in a database that matches conditions.
Snap & solve any problem in the app
Get step-by-step solutions on Sovi AI
Photo-based solutions with guided steps
Explore more problems and detailed explanations
DAVERAGE - averages values in a field of records in a database that matches conditions
DMAX - finds the largest number in a database that matches conditions
DMIN - finds the smallest number in a database that matches conditions
DCOUNT - counts the cells that contain numbers in a database that matches conditions
DSUM - adds the numbers in a field of records in a database that matches conditions