Excel Conditional Formatting

What is the primary purpose of conditional formatting in Excel?

• Adding new data to a worksheet

• Formatting cells based on specific criteria

• Sorting data in ascending order

• Creating charts and graphs

How can you remove conditional formatting from a cell or range of cells in Excel?

• Format the cells manually.

• Delete the cell contents.

• Use the "Clear Rules" option from the conditional formatting menu.

• You cannot remove conditional formatting once applied.

Which of the following is NOT a type of conditional formatting rule in Excel?

• Data Bars

• Icon Sets

• Colour Scales

• Merge Cells

In conditional formatting, what is a "rule" or "condition" that you define to format cells?

• A chart

• A cell reference

• A formula or expression

• A pivot table. Please give me the answer

How can you identify triplicates in a range of cells using conditional formatting in Excel?

• Use the "Highlight Duplicates" feature under the "Data" tab.

• ) Enter a formula that counts the occurrences and equals 3

• Apply the "Triplicate Checker" option from the "Format" menu.

• None of the options