Multiple Choice
All of the following statements are TRUE about the DSUM function EXCEPT:
A) An advantage of using the DSUM function is that you can see the criteria on the worksheet and understand the calculation much easier.
B) The DSUM function is a database function that is ideal for setting up a criteria range and then calculating the sum based on the filters within that criteria range.
C) The criteria can be modified on the worksheet and the result is updated automatically.
D) The syntax of the DSUM function is =DSUM(database, field, [criteria]) where criteria is optional.
Correct Answer:

Verified
Correct Answer:
Verified
Q80: A pair of _ is needed around
Q81: The _ function allows for multiple criteria
Q82: _ is code that uses the structure
Q83: In the VLOOKUP function below,which of the
Q84: The ability to use MATCH and INDEX
Q86: Which of the following is the correct
Q87: The following function is an example of
Q88: A(n)_ is the strategic advantage that a
Q89: All of the following statements are TRUE
Q90: The COUNTIFS function allows for multiple criteria