Solved

Which Database Function Will Return the Smallest Value from a Dataset

Question 42

Multiple Choice

Which database function will return the smallest value from a dataset based on preset criteria?


A) DCOUNT
B) DSUM
C) DMIN
D) DMAX

Correct Answer:

verifed

Verified

Unlock this answer now
Get Access to more Verified Answers free of charge

Related Questions

Q12: A(n)_ is a schedule that calculates the

Q37: The PV function would be best suited

Q38: What is the purpose of an amortization

Q39: When the DAVERAGE function returns #DIV/0:<br>A)there are

Q40: If a nested IF statement has 6

Q43: Which database function should be used to

Q44: =INDEX(A2:<br>B5,MATCH(MAX(B2:<br>B5),B2:<br>B5,0),1)is an example of a nested function.

Q45: The MATCH function match_type must be set

Q46: In the function =IF(E5&lt;J7,F5*K7,IF(E5&lt;=J8,F5*K8,F5*K9)),F5*K7 is the:<br>A)Value_if_true.<br>B)Value_if_false.<br>C)Logical_test.<br>D)Modifier.

Q47: When using Advanced Filtering,the criteria range must