FUNDAMENTALS OF COMPUTER

Detailed explanation-1: -Conditional formatting can help make patterns and trends in your data more apparent. To use it, you create rules that determine the format of cells based on their values, such as the following monthly temperature data with cell colors tied to cell values.

Detailed explanation-2: -Conditional formatting makes it easy to highlight certain values or make particular cells easy to identify. This changes the appearance of a cell range based on a condition (or criteria). You can use conditional formatting to highlight cells that contain values which meet a certain condition.

Detailed explanation-3: -The correct answer is Conditional formatting. Conditional formatting allows users to automatically apply formattings such as colours, icons, and data bars to one or more cells based on the cell value.

Detailed explanation-4: -Answer: The difference is that conditional formatting is more flexible, it allows you to format only the data that meets certain criteria, or conditions. You can apply conditional formatting to one or several cells, rows, columns or the entire table based on the cell contents or based on another cell’s value.

Detailed explanation-5: -Excel’s predefined conditional formatting, such as Data Bars, Color Scales and Icon Sets, are mainly purposed to format cells based on their own values. If you want to apply conditional formatting based on another cell or format an entire row based on a single cell’s value, then you will need to use formulas.