FUNDAMENTALS OF COMPUTER

Detailed explanation-1: -Answer: Conditional formatting is a feature in many spreadsheet applications that allows you to apply specific formatting to cells that meet certain criteria. It is most often used as color-based formatting to highlight, emphasize, or differentiate among data and information stored in a spreadsheet.

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.