The _____ Function Returns the Value from a Range of Data

question 548

Multiple Choice

The _____ function returns the value from a range of data at the intersection of a specified row and column.

• A) INDEX
• B) MATCH
• C) LOOKUP
• D) ARRAY

---

Definitions:

Inventory costing method

A system or technique used by companies to assign costs to inventory and goods sold; common methods include FIFO, LIFO, and average cost.

Ending inventory

The total value of goods available for sale at the end of an accounting period after all sales transactions have been accounted for.

Current prices

Prices at which goods and services are being sold in the present market, reflecting the current economic conditions.

LIFO

The "last in, first out" method of inventory valuation, where the most recently acquired items are considered sold first, used in periods of inflation to increase cost of goods sold and reduce taxes.