Within a Given Range of Cells, the Number of Times

question 43

Multiple Choice

Within a given range of cells, the number of times a particular condition is satisfied is computed by using the __________ function.

• A)SUMIF
• B)IF
• C)VLOOKUP
• D)COUNTIF

---

Definitions:

Yield To Maturity

The total return expected on a bond if held until its maturity date, accounting for its current price, interest payments, and face value.

Maturity

The date on which a financial instrument (e.g., bond, loan) reaches its final installment, and the principal is due to be paid to investors.

Expectations Theory

A theory related to interest rates stating that the long-term interest rates are geometric averages of present and future short-term interest rates, reflecting market assumptions about future rates.

Forward Rate

The agreed-upon interest rate for a financial transaction that will occur at a future date, often used in the context of foreign exchange or interest rates.