Which of the Following Lookup Functions Returns the Relative Position

question 23

Multiple Choice

Which of the following Lookup functions returns the relative position of an item in an array that equals a specified value in a specified order?

• A) HLOOKUP(lookup_value, table_array, row_index_num)
• B) MATCH(lookup_value, lookup_array, match_type)
• C) INDEX(array, row_num, col_num)
• D) VLOOKUP(lookup_value, table_array, col_index_num)

---

Definitions:

Service Cost

The actual cost incurred to provide a service, including labor, materials, and overhead expenses.

Cumulative Unrecognized

Accumulated amounts of certain expenses or revenues that have not yet been recognized in a company's financial statements.

Amortization

The process of gradually writing off the initial cost of an asset over a period, often used for intangible assets.

Corridor

A method used in pension accounting to amortize certain actuarial gains and losses over time.