Conditional Formatting in Excel Quiz

What is the primary purpose of conditional formatting in Excel?

• To change the font of the text

• To apply different formatting based on cell values

• To sort data in ascending order

• To create charts and graphs

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

• Highlight Cells Rules

• Top/Bottom Rules

• Data Bars

• Pivot Table Rules

How can you access the Conditional Formatting menu in Excel?

• Home tab > Styles group > Conditional Formatting

• Insert tab > Charts group > Conditional Formatting

• Data tab > Sort & Filter group > Conditional Formatting

• Review tab > Comments group > Conditional Formatting

Which of the following options can be used to create a conditional formatting rule based on a formula?

• Use a formula to determine which cells to format

• Format only cells that contain

• Format only top or bottom ranked values

• Format only unique or duplicate values

What happens when you apply a conditional formatting rule to a range of cells?

• The rule applies to the entire worksheet

• The rule applies only to the selected range

• The rule applies to all worksheets in the workbook

• The rule applies to the selected range and all adjacent cells

Which of the following is TRUE about Conditional Formatting in Excel?

• It only changes the text color

• It allows you to format cells based on specific conditions

• It permanently changes the value of the cells

• It can only be applied to numbers

How do you access Conditional Formatting in Excel?

• File > Options > Conditional Formatting

• View > Formatting > Conditional Formatting

• Home > Styles > Conditional Formatting

• Data > Tools > Conditional Formatting

Which of these is NOT a type of Conditional Formatting rule?

• Highlight Cell Rules

• Data Bars

• Color Scales

• Pivot Table Rules

Which Conditional Formatting option would you use to highlight cells greater than a specific value?

• Data Bars

• Icon Sets

• Highlight Cell Rules

• Color Scales

What happens if multiple Conditional Formatting rules apply to the same range of cells?

• Only the first rule is applied

• All rules are ignored

• The rules are applied in the order they are listed

• Excel displays an error