What Is the Significance of an Absolute Cell Reference in Excel

question 42

Multiple Choice

What is the significance of an absolute cell reference in Excel?

• A) The cell reference will not change if the formula containing the reference is copied to another location
• B) The cell will always contain the absolute value of any number entered into it
• C) The cell reference changes if the formula containing the reference is copied to another location
• D) It is the only formula used to refer to a cell on another spreadsheet

---

Definitions:

Bonds

These are fixed-income investment products where an investor loans money to an entity (corporate or governmental) that borrows the funds for a defined period of time at a fixed interest rate.

Debt Instruments

Financial assets that represent a debtor's obligation to repay borrowed money or other forms of credit to the creditor according to stated terms.

Original Issue Discount

The difference between the par (face) value of a bond and the lower price at which it was originally sold, which must be reported as interest income over the life of the bond.

Tax-exempt Debt

Debt securities issued by state or municipal governments whose interest payments are exempt from federal income tax, and sometimes state and local taxes.