Match the Following Five Terms to Their Meanings

question 31

Multiple Choice

Match the following five terms to their meanings:
i.DAVERAGE
II.DSUM
III.DCOUNT
IV.syntax
v.compound criteria

• A)A function that counts the number of occurrences of a specified condition in a database.
• B)A function that calculates an average in a database range.
• C)An arrangement of elements in the database function arguments.
• D)The use of two or more criteria on the same row.
• E)A function that calculates a total in a database range.

---

Definitions:

Merchandise Inventory

The total value of goods held by a company for the purpose of resale to customers.

Sales Dollars

This refers to the total amount of revenue generated from the sale of goods or services, expressed in monetary terms.

Finished Goods Inventory

Finished goods awaiting sale that have not been sold yet.

Raw Materials Inventory

The total value of all the materials that have not yet been used in the production process.