All of the Following Statements Are TRUE About the SUMIF

question 39

Multiple Choice

All of the following statements are TRUE about the SUMIF and SUMIFS functions EXCEPT:

• A)The SUMIF and SUMIFS functions select values from a range of data based on criteria, and then add those values.
• B)SUMIF functions are based on one criterion.
• C)The SUMIF and SUMIFS arguments are very dissimilar.
• D)The SUMIFS function allows for more than one filtering criteria.

---

Definitions:

Coupon Rate

The annual interest rate paid on a bond, expressed as a percentage of the bond's face value, and paid to bondholders at specified intervals until maturity.

Coupon Bond

A bond that entitles the holder to a fixed interest payment, or coupon, periodically until the bond matures.

Interest-Rate Risk

The potential for investment losses due to changes in interest rates, affecting the value of interest-bearing assets like bonds.

Yield To Maturity

The total return expected on a bond if the bond is held until its maturity date.