Question

In MS Excel ............ changes the appearance of cells based on certain conditions.

• A. Conditional Formatting
• B. Data validation
• C. Mail merging
• D. None of these

Answer 1

Answer:

A. Conditional Formatting

Conditional Formatting

• Conditional Formatting changes the appearance of cells based on certain conditions.

- Method: Select the data range, go to the "Home" tab, and click "Conditional Formatting."

- Example: To highlight cells in range A1:A10 that are greater than 50, select the range, go to "Home > Conditional Formatting > Highlight Cells Rules > Greater Than," and enter 50

Creating Formulas