Excel Conditional Formatting Quiz

Which Excel feature allows you to automatically change the cell's background colour based on its value?

• Data Validation

• Conditional Formatting

• Pivot Table

• Freeze Panes

What is the first step to create a dropdown list in a cell in Excel?

• Click on Conditional Formatting

• Select the cell and go to Data Validation

• Insert a Pivot Table

• Use the SUM function

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

• Highlight Cell Rules

• Data Bars

• Icon Sets

• Data Validation List

If you want to restrict the values entered in a cell to a specific list, which feature should you use?

• Conditional Formatting

• Data Validation

• Flash Fill

• Sort & Filter

Which menu tab do you use to access Conditional Formatting in Excel?

• Home

• Insert

• Data

• Review

How can you customise a conditional formatting rule to highlight cells greater than 100?

• Use Data Validation with a list

• Use Conditional Formatting > Highlight Cell Rules > Greater Than

• Use the SUM function

• Use Freeze Panes

Which of the following is a valid source for a dropdown list in Data Validation?

• A range of cells containing the list items

• A chart

• A Pivot Table

• A formula in the cell

What happens if you enter a value not in the dropdown list created by Data Validation?

• The value is accepted without warning

• An error message appears

• The cell turns red automatically

• The worksheet closes

Which of the following can you NOT do with Conditional Formatting?

• Add a dropdown list to a cell

• Change font colour based on value

• Add data bars to cells

• Use icon sets to indicate value

Which of the following is NOT a valid option in the Data Validation settings?

• Whole number

• List

• Date

• Chart