In MS-EXCEL, suppose you want to quickly highlight all of the cells in your worksheet with a value less than 100 . Which of the following is the fastest way to accomplish this?

Correct option is A

1. Conditional formatting is the fastest and most effective way to highlight cells in MS Excel based on specific criteria, such as values less than 100. It allows users to apply formatting (like color fills, borders, or text styles) to cells automatically, depending on their values or conditions set by the user. To achieve this:

• Select the range of cells.
• Go to the Home tab, click on Conditional Formatting, and choose New Rule.
• Specify the condition (e.g., "Format only cells that contain values less than 100") and select the desired formatting.

Other options are incorrect because:

• Quick formatting is not a feature in Excel.
• Cell alignment adjusts the position of content within cells and doesn't handle value-based formatting.
• Number formatting changes the display style of numbers (e.g., currency, percentage) without applying conditions.

1. Information Booster:
   ● Conditional formatting helps identify trends, outliers, or important data points quickly.
   ● It supports various rules, such as highlighting top/bottom values, specific text, or duplicate data.
   ● Conditional formatting can be found in the Styles group under the Home tab.
   ● You can create custom rules using formulas in conditional formatting.
   ● Formatting updates dynamically when data changes, making it a powerful visualization tool.