In Excel, ___________________ References Are Indicated by a Dollar Sign

question 24

Multiple Choice

In Excel, ___________________ references are indicated by a dollar sign character preceding the column and the row reference.

• A) absolute
• B) comparative
• C) analogous
• D) relative
• E) correlative

---

Definitions:

Coupon Rate

The interest rate that a bond issuer will pay to a bondholder, typically expressed as an annual percentage of the bond's face value.

Duration

A measure of the sensitivity of the price of a bond or other debt instrument to a change in interest rates, usually expressed in years.

Perpetuity

A financial term for a constant stream of identical cash flows with no end.

Yield

The earnings from an investment, like dividends or interest, shown as a percentage of the investment's original cost or its current market valuation.