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:

Par Value

The face value of a bond or the stock value stated in the corporate charter, not necessarily reflecting the market value.

Coupon Bond

A type of bond that offers periodic interest payments to its holder, typically paid semi-annually, until maturity.

Duration

Duration is a measure of the sensitivity of the price of a financial asset to a change in interest rates, often used in the context of bonds to describe how price is affected by changes in rates.

Annual Coupon

The yearly interest payment paid to bondholders, typically expressed as a fixed percentage of the bond's face value.