Which Type of Conditional Formatting Rule Would You Create to Add

question 261

Multiple Choice

Which type of conditional formatting rule would you create to add a horizontal bar to a cell background, where the length of the bar reflects the value in the cell?

• A) Top Values
• B) Data Bar
• C) Icon Sets
• D) Color Scales

---

Definitions:

Constant Income

A situation where an individual's or entity's income remains unchanged over a period of time, despite changes in economic conditions or inflation.

Prices of Goods

The amount of money required to purchase specific products or commodities in the market.

Total Satisfaction

The complete or maximum level of well-being or happiness that a consumer derives from consuming goods and services.

Marginal Rate of Substitution

The rate at which a consumer is willing to substitute one good for another while maintaining the same level of satisfaction.