Match the Following Conditional Formatting Options with Their Description

question 21

Multiple Choice

Match the following Conditional Formatting Options with their description:
i. Highlight Cells Rules
II. Top / Bottom Rules
III. Data bars
IV. Color Scales
v. Icon Sets

• A) Formats cells if they fall in the lowest % (% determined by the user)
• B) Formats cells with gradients of color depending on the cell's value compared to the other values in the range
• C) Formats cells with colors whose width is proportional to the other values in the range
• D) Formats cells if a date falls in a certain range
• E) Uses symbols to represent the comparison of values

---

Definitions:

Demographic Characteristics

Attributes of a population such as age, race, gender, income, and education that are used in market segmentation and sociological research.

Echo-boom

A demographic pattern characterized by a significant increase in birth rates, following an earlier baby boom, particularly seen in Millennials.

Generational Cohort

A group of individuals born in the same period, who share similar cultural experiences, attitudes, and values.

Retirement Plans

Financial strategies and savings products aimed at providing individuals with income during their retirement years.