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:

Healthcare Prices

The cost associated with medical services and products, which can vary widely depending on a variety of factors.

Economize

The act of using resources efficiently, especially to reduce costs.

Payroll Tax

A tax imposed on employers or employees, and is usually calculated as a percentage of the salaries that employers pay their staff.

Medicare Beneficiaries

Individuals who are eligible to receive health care benefits under the Medicare program, typically those aged 65 and over or with certain disabilities.