Font size
WorksheetsSpreadsheet - Conditional Formating
Total questions: 10
Worksheet time: 8mins
What is conditional formatting used for in a spreadsheet?
To change the spreadsheet layout
To sort and filter data
To change how a cell looks based on its value
To protect data
Which of the following is NOT an example of conditional formatting?
Making numbers greater than 100 turn red
Coloring cells with the word “Absent” in yellow
Hiding columns
Highlighting top 3 values
You want all marks below 50 to appear in red. Which tool should you use?
Data validation
Conditional formatting
Sort & Filter
Merge cells
Which of these is a correct condition for formatting a cell?
If cell is red
If cell is equal to "Pass"
If cell is column A
If cell is merged
Conditional formatting can change...
Text color
Cell background color
Cell value
Font style (bold/italic)
If you apply conditional formatting to show green fill for values greater than 90, what happens to the cell with value 85?
It turns green
It stays the same
It disappears
It turns red
You want to highlight all students who scored exactly 100. What condition should you apply?
Cell value > 100
Cell value = 100
Text contains “100”
Format all cells
Which menu tab usually contains the Conditional Formatting option in most spreadsheet software (e.g., Excel or Google Sheets)?
File
View
Format
Home
Write a rule to highlight all cells in column C if they are equal to "Fail".
Text contains "Pass"
Format only cells greater than 60
Format cells if text is exactly "Fail"
Format cells that are blank
You created a rule: “If the value is less than 60, make the text red.” Your class scores are: 80, 72, 58, 95, 43. Which two values will be red?
