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:

Mean Cholesterol Level

The average value of cholesterol measurements across a group of individuals or samples, used in assessing health and disease risk.

Standard Deviation

A statistical metric that quantifies the spread of data points in a dataset relative to their average value.

Confidence Interval

A repository of values, extracted from the evaluation of sample data, seen as likely to encapsulate the value of an enigmatic population parameter.

Random Sample

A subset of a statistical population where each member has an equal chance of being chosen, ensuring the sample's representativeness.