Pass and Fail rules cover a column, and one cell in that column contains Merit. What happens to that cell?
It keeps its normal formatting and gets no colour
A cell is green because it contains Pass. The value is changed to Fail, and a Fail rule also exists. What happens?
The cell turns red automatically
A Position column holds 1, 2, 3, 10 and 11. Which rule colours only the cells holding 1?
Is equal to 1
A green rule already covers a column and you want to add a red rule to the same cells. What should you do?
Add another rule for the same range of cells
A teacher wants to spot every score below 40 in a long list of results. Which use of conditional formatting is best?
Fill cells below 40 with a chosen colour
In a self-marking quiz, column C shows Correct or Incorrect. Which rule colours the wrong answers red?
Text contains Incorrect, with a red fill
A student wants every cell in column D that contains the word Late to be filled amber. They select column D and open the conditional formatting settings. What should they do next?
Choose Text contains and set an amber fill
A student selects only cell B2 and adds a conditional formatting rule. Which cells does the rule format?
Only cell B2
A Text contains rule looks for Pass and fills the cell green. Which cell will turn green?
The cell showing Passed
A Cost column holds values from 5 to 200. Which rule colours only the cells whose value is above 100?
Is greater than 100
Which term describes a feature that automatically changes how cells look when their values meet a rule you set?
Conditional formatting
What is meant by the Text contains rule?
A rule that formats any cell whose text includes the given word
What is the name for a rule that formats a cell only when its value is exactly the same as the number you set?
Is equal to
What does it mean that the Text contains rule is not case sensitive?
It matches pass, Pass and PASS in exactly the same way
What does the Fill colour setting do when you build a conditional formatting rule?
It sets the background colour applied to cells that match the rule
Which term describes formatting that stays the same whatever value is stored in a cell?
Normal formatting
Which setting decides what a conditional formatting rule checks for, such as text or a number?
The type of rule you choose
In conditional formatting, what is a rule?
A test that a cell must meet for formatting to appear
In a self-marking quiz, an IF statement puts the word Correct in a cell. Which part colours that cell green?
A conditional formatting rule that looks for Correct
A coach records how many laps each player runs each week and colours every value over 20 in green. What is the main benefit of this rule?
Strong weeks stand out so patterns are easy to spot
We use cookies to enhance your experience. You can manage your preferences or learn more in our Cookie Policy.