A(n)____ Circular Reference Occurs When a Formula in a Cell

question 1

Multiple Choice

A(n) ____ circular reference occurs when a formula in a cell refers to another cell or cells that include a formula that refers back to the original cell.

• A) contiguous
• B) indexed
• C) direct
• D) indirect

---

Definitions:

Annual Coupon

The annual interest payment paid to bondholders, usually expressed as a percentage of the bond's face value.

Yield to Maturity

The total return anticipated on a bond if the bond is held until its maturity date, taking into account both interest payments and capital gain.

Zero-Coupon Bond

A debt security that does not pay interest (coupon) during its life but is traded at a deep discount, offering a profit at maturity when the bond is redeemed for its full face value.

Market Price

Market Price is the current price at which an asset or service can be bought or sold in a competitive marketplace.