Conditional Formatting - Quiz
1. 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
The rules are removed from the whole column
It is filled red because it did not match either rule
It shows an error message in the cell
2. A cell is green because it contains Pass. The value is changed to Fail, and a Fail rule also exists. What happens?
The cell stays green until the rule is applied again
The cell shows an error until the sheet is refreshed
The cell loses all formatting and stays plain
The cell turns red automatically
Log in or sign-up to access the quiz
Don't have a login?
You can still revise this topic