Which of the Following Formulas Contains an Absolute Cell Reference

question 45

Multiple Choice

Which of the following formulas contains an absolute cell reference?

• A) =$B4
• B) =B$4
• C) =$B$4
• D) =B4

---

Definitions:

Treasury Bond

U.S. government debt instruments featuring fixed interest rates and long-term maturity periods exceeding ten years.

Subprime Mortgages

Loans granted to borrowers with poor credit histories, which carry higher interest rates than standard mortgages to compensate for the higher risk.

Mortgage-backed CDOs

Complex structured finance products that pool together cash flow-generating assets and repackages this asset pool into tranches that can be sold to investors, specifically focusing on mortgage-backed securities.

Variable Rate Loans

Loans with interest rates that can fluctuate over time based on an underlying benchmark rate or index.