Match Each of the Following Functions to Its Descriptions

question 71

Multiple Choice

Match each of the following functions to its descriptions:
i.SUM
II.MEDIAN
III.AVERAGE
IV.COUNTIF
v.COUNT

• A)counts the number of cells in a range that meet the given condition
• B)counts the number of cells in a range that contain numbers
• C)adds a range of cells and divides by the number of values in the range
• D)adds a range of cells
• E)locates the middle value in a range of cells

---

Definitions:

Cost of Goods Sold

The total cost of manufacturing and delivering a product to customers, typically including material, labor, and overhead expenses.

Inventory

Materials and goods a business holds for the purpose of resale or as input in its production process.

Debt-to-Equity Ratio

A measure of a company's financial leverage, determined by dividing its total liabilities by stockholders' equity.

Debt to Equity Ratio

A financial ratio indicative of the relative proportion of shareholders' equity and debt used to finance a company's assets.