Practice Conditional Formatting (3.2.3) - Information and Communication

Practise this section

10 questions

Flashcard drill
2 cards from this section. Quick, good the night before a test.
Exercise
6 questions · about 4 min · pass mark 70%. Hints available.
Sign up to start the exercise
Quiz
4 questions · about 3 min · pass mark 70%. Hints available.
Sign up to start the quiz

6 sample questions

Question 1.
What is conditional formatting?
Show hintHide hint
Think about how you can visually represent data.
Question 2.
Can you apply conditional formatting to a single cell?
Show hintHide hint
Remember it’s flexible for choices.
3Question 3.
What does conditional formatting do?
- Changes cell colors based on formula
- Adds background images
- Formats text only
Show hintHide hint
Remember its purpose in enhancing data visibility.
4Question 4.
True or False: You can apply conditional formatting to one cell at a time.
- True
- False
Show hintHide hint
Think about flexibility in applying rules.
Question 5.
Create a monthly sales report and highlight cells in red if the sales figures drop below monthly targets.
Show hintHide hint
Set your criteria based on target sales.
Question 6.
Design a leaderboard showing top 10 performers with conditional formatting to display the top 3 in green, middle performers in yellow, and lowest in red.
Show hintHide hint
Consider making use of ranking functions.

6 more questions in this section. Enroll free to practise them all.