In Microsoft Excel,the Function That Looks Up a Value in a Table

question 44

Multiple Choice

In Microsoft Excel,the function that looks up a value in a table is ________.

• A)AVERAGE(condition 1,condition 2 ...)
• B)IF(condition,value if true,value if false)
• C)VLOOKUP(value,table range,column number)
• D)COUNTIF(range,criteria)

---

Definitions:

Gross Profit Ratio

The gross profit ratio is a financial metric that measures the proportion of money left over from revenues after accounting for the cost of goods sold (COGS), expressed as a percentage.

Estimated Cost

An approximation of the cost or expenditure associated with an activity, project, product, or service, made in the absence of precise information.

Gross Profit Ratio

A financial metric expressing the gross profit as a percentage of net sales, indicating the efficiency of production or service delivery.

Inventory Destroyed

Refers to stock items that have been damaged, expired, or cannot be sold, leading to a loss for the business.