In the IF Function, the Second Argument Determines the Value

question 5

Multiple Choice

In the IF function, the second argument determines the value that appears in the cell if the logical test is ____.

• A) false
• B) true
• C) an error
• D) none of the above

---

Definitions:

Maturity

The state or moment when a financial instrument, such as a bond or loan, reaches its due date and principal is to be paid back.

Zero-Coupon Bonds

Bonds that are issued at a discount to their face value and do not pay periodic interest, but rather pay the face value at maturity.

Yield

The income return on an investment, such as the interest or dividends received, typically expressed as an annual percentage rate based on the investment's cost, its current market value, or its face value.

Face Value

The nominal or dollar value stated on a security or financial instrument, such as a bond or stock.