Conditional Formatting (Flipped Lesson)

What is conditional formatting?

• a) A feature that allows you to format cells based on specific conditions or criteria.
• b) A method of formatting cells that requires manual adjustments.
• c) A way to format cells randomly without any specific rules.
• d) A feature used only for formatting text in cells

Which of the following is NOT a type of conditional formatting option?

• a) Color scales
• b) Data bars
• c) Icon sets
• d) Font styles

In Excel, how can you apply conditional formatting to a range of cells?

• a) Select the cells, go to the "Format" menu, and choose "Conditional Formatting."
• b) Right-click on the cells and choose "Conditional Formatting" from the context menu.
• c) Use the "Conditional Formatting" button in the "Home" tab of the ribbon.
• d) Conditional formatting cannot be applied to a range of cells.

Conditional formatting is a useful tool for visually highlighting data patterns and trends in large datasets.

• True
• False

Which of the following formatting options can be used in conditional formatting?

• a) Font color and size
• b) Cell borders
• c) Fill color
• d) All of the above

Which formatting option allows you to display colored bars within cells based on the cell values?

• a) Color scales

• b) Data bars

• c) Icon sets

• d) Conditional color fill

Which of the following file formats supports conditional formatting?

• a) CSV (Comma-Separated Values)

• b) PDF (Portable Document Format)

• c) XLSX (Excel Workbook)

• d) TXT (Plain Text)