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:

Floodplain

A flat area of land adjacent to a river or stream that experiences occasional or periodic flooding.

Real Danger

Real danger denotes a genuine threat to an individual's safety or well-being, necessitating an appropriate response.

Unlikely

Having a low probability of occurring; not likely to happen.

Attitude Stability

The degree to which an individual's attitudes, opinions, and beliefs remain consistent over time, despite external factors or influences.