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 syntax of the DSUM function is =DSUM(field, database, [criteria]) where criteria is optional.
C) 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.
D) The criteria can be modified on the worksheet and the result is updated automatically.
B
You might also like to view...
Which of the following is the Statement interface method that should be used to execute an INSERT statement.
a. executeSQL b. executeStatement c. executeUpdate d. executeQuery
How does a de facto exclusion differ from a regular exclusion?
What will be an ideal response?
Encapsulation is similar to using a device you use without regard for the internal mechanisms. What is the common term for this type of device?
A. white box B. black box C. gray box D. blue box
Which of the following processes determines the quality standards that are relevant to a project?
a. Quality assurance b. Quality planning c. Quality control d. Quality analysis