A Color Scale

question 77

Multiple Choice

A color scale:

• A)highlights cells meeting specified criteria with a specified color,font,or border.
• B)is a conditional format that displays an colored icon representing a value in the top third,quarter,or fifth based on colors in the selected range.
• C)calculates an aggregate for values in a range or database.
• D)is a conditional format that displays a color based on the relative value of the cell contents.

---

Definitions:

Upward Sloping

Describes a line on a graph that represents an increase in a variable over time or another metric.

Yield Curve

The yield curve is a graphical representation of the interest rates on debt for a range of maturities, showing the relationship between interest rates and the time to maturity.

Semiannually

Occurring twice a year; typically used in finance to describe payments, compounding interest, or other events that happen every six months.

Market Rate of Interest

The prevailing rate of interest determined by supply and demand in the money market, influencing the cost of borrowing or the return on investment.