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
Q25: The first argument of the AVERAGEIFS function
Q26: The _ function is a useful tool
Q27: The third argument of the VLOOKUP function
Q28: The first argument of the AVERAGEIF function
Q29: The _ function looks for a value
Q31: All of the following statements are TRUE
Q32: Which of the following is NOT a
Q33: The _ function is a database function
Q34: The _ function is used when the
Q35: Which of the following is NOT an
Unlock this Answer For Free Now!
View this answer and more for free by performing one of the following actions
Scan the QR code to install the App and get 2 free unlocks
Unlock quizzes for free by uploading documents