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:

Joint Venture

A business arrangement where two or more parties agree to pool their resources for the purpose of accomplishing a specific task or project.

Selling Price

The amount of money for which a product or service is sold to the customer, often after considering costs and desired profit margins.

Global Marketplace

Refers to the international trading environment where goods and services are bought and sold across national borders.

Infrastructure

The fundamental physical and organizational structures and facilities (e.g., buildings, roads, power supplies) needed for the operation of a society or enterprise.