The ____ Function Tests a Condition and Returns One of Two

question 11

Multiple Choice

The ____ function tests a condition and returns one of two values;the function returns the first value if the condition is true and the second value if the condition is false.

• A)IIf
• B)Pmt
• C)IsNull
• D)NPV

---

Definitions:

Purchase Account

An account used in accounting to record the total purchases of goods and services by a company.

Inventory Account

An account used to record the value of inventory held by a company, including raw materials, work-in-progress, and finished goods.

Cost of Goods Available

The total cost of goods a company has to sell during a specific period, calculated by adding the beginning inventory to the cost of goods purchased.

Purchase Returns

Refers to the process of returning goods previously bought to the supplier due to various reasons like defects or dissatisfaction.