Quiz

Quiz: Conditional Formatting

Cambridge Nationals IT Level 1/Level 2

10 Steps8 Questions

Students also studied

Text

Building on what you've learned about data validation and cell formatting, let's test your knowledge of conditional formatting!

Multiple ChoiceInteractive

What is the purpose of conditional formatting in spreadsheets?

Start the lesson to answer this multiple choice question

Multi-SelectInteractive

Which of the following can be done using conditional formatting? (Select all that apply)

Start the lesson to answer this multi-select question

Fill in the BlankInteractive

Conditional formatting applies rules based on the {{blank0}} of a cell's {{blank1}}.

Start the lesson to answer this fill in the blank question

MatchingInteractive

Match the items on the left with their correct pairs on the right

Start the lesson to answer this matching question

Math EquationInteractive

You are applying conditional formatting to highlight numbers greater than 50. If a cell contains 75, will it be highlighted?

Start the lesson to answer this math equation question

Multiple ChoiceInteractive

Which of the following is an example of a conditional formatting rule?

Start the lesson to answer this multiple choice question

typedAnswer

Match the items on the left with their correct pairs on the right

Fill in the BlankInteractive

A {{blank0}} scale in conditional formatting applies shading based on the {{blank1}} of values in a range.

Start the lesson to answer this fill in the blank question

Multi-SelectInteractive

Which of the following are valid conditional formatting criteria? (Select all that apply)

Start the lesson to answer this multi-select question

Get personalised lessons, quizzes, and instant feedback from your AI tutor.