Which of the Following Conditional Formats Can You Apply to Display

question 365

Multiple Choice

Which of the following conditional formats can you apply to display small graphics in a cell that vary based on the cell's value?

• A) icon sets
• B) data bars
• C) Highlight Cells Rules
• D) color scales

---

Definitions:

Market Price

The price at which an asset or service is traded in the open market.

Treasury Bills

Short-term government securities issued at a discount from the face value and maturing at par, representing a form of borrowing by the government.

Real Rate Of Return

The annual percentage return realized on an investment, adjusted for changes in the price level due to inflation or other external factors.

Inflation

The speed at which the overall price level for goods and services increases, gradually diminishing the buying power.