Case 3-2 Susan Is in Charge of the Inventory Reports for Her

question 27

Multiple Choice

Case 3-2
Susan is in charge of the inventory reports for her company.  She will need to find specific inventory items as well as project increases in inventory costs.  To get ready she will create a worksheet and use the Microsoft Excel 2016 Analysis tools.
-Susan needs to use a lookup function to find an exact match of an inventory item, so she will set the range_lookup value to _______ .

• A) EXACT
• B) 1
• C) TRUE
• D) FALSE

---

Definitions:

Shortage

A market condition where the demand for a product exceeds the supply of that product, often leading to higher prices.

Effective Price Ceiling

A government-imposed limit on how high the price of a product can be charged, set below the market equilibrium to be effective.

Equilibrium Price

The price at which the quantity of a good or service demanded meets the quantity supplied, resulting in a stable market condition.

Surplus

An excess of production or supply over demand, often resulting in lower prices or wasted resources.