Match the Following Conditional Formatting Options with Their Description

question 69

Essay

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:

Maslow's Hierarchy

A theory in psychology proposed by Abraham Maslow, structured as a pyramid with the most fundamental needs at the bottom and self-actualization at the top.

Perceived Inequity

A feeling of unfairness that arises when individuals compare their own effort-reward ratio to others'.

Equity Theory

A theory of motivation that focuses on the fairness of the distribution of rewards and resources within interpersonal relationships.

Distort

To twist or alter information or perception in a way that misrepresents the truth or reality.