CPA 3NT SST 1a

___________ __________ allows us to format the appearance of data in a range of cells based on conditions

Conditional formatting helps us to better identify data

• true

• false

Conditional formatting recalculates the data in the cell

• true

• false

Conditional formatting can change the fill and font colour of cells automatically based on their contents

• true
• false

In row D, which type of conditional formatting rules are applied?

• 
• 
• 
• 
• 

To use conditional formatting, we can highlight cells with rules such as (select all that apply)

• 
• 
• 
• 

Conditional formatting is applied to the cells in column G. Which rule is used?

• 
• 
• 
• 

Conditional formatting is applied to the cells in column G. Which preset formatting is applied?

• light red fill with dark red text

• yellow fill with dark yellow text

• green fill with dark green text

• red border

Format cells C6:C12 to automatically show light red fill with dark red text if the value is more than or equal to 1.39. Which should you click?

• 
• 
• 
• 

How do you remove conditional formatting rules?

• 
•