Which of the Following Is a Difference Between Relative Addressing

question 31

Multiple Choice

Which of the following is a difference between relative addressing and absolute addressing when using cell formulas in Excel?

• A) A relative address uses a dollar sign before either the row or column label; an absolute address uses the ampersand symbol before either the row or column label.
• B) A relative address uses a dollar sign before either the row or column label; an absolute address uses just the row and column label in the cell reference.
• C) A relative address uses just the row and column label in the cell reference; an absolute address uses a dollar sign before either the row or column label.
• D) A relative address uses only the column label in the cell reference; an absolute address uses the row.

---

Definitions:

Par Value

Par Value is the nominal or face value of a security as stated by the issuer, and it's the price at which bonds are to be redeemed at maturity.

Coupon Payment

The periodic interest payment made to bondholders during the life of the bond.

Eurobonds

International bonds issued in a currency not native to the country where it is issued, allowing companies and governments to raise capital in the international market.

Pound-Denominated

Refers to financial assets or transactions valued or conducted in British pounds sterling.