Which of the following database functions is best suited to add total salaries from a database that are higher than $30,000?
A)DMIN
B)DSUM
C)DMAX
D)DCOUNTA

Question

Quizplus · Accepted Answer

DSUM is the best choice as it allows for the selection of a specific criterion to sum, in this case the salaries higher than $30,000. ADMIN and DMAX are not suitable as they respectively return the minimum and maximum values, rather than a sum. DCOUNTA counts non-blank cells, so it is also not suitable for this task.

Which of the Following Database Functions Is Best Suited to Add