Excel - Conditional Formating

What is conditional format?

• A format of Colour etc applied to cells to make them stand out

• A list in which you can choose from various options

• A Pattern which you need to set up and drag to cells

• A built in pattern

What Must all formulas start with?

• =

• +

• #

• /

Why would you put  FILTER on your Spreadsheet?

• To View the top row at all times

• To view specific Criteria in your spreadsheet

• To help with Formulas

• In order to freeze the columns

Where will you find the Conditional Formatting command?

• Home>Styles

• Home>Format

• Home>Alignment

• Home>Number

The Conditional Formatting function in Excel allows you to?

• Automatically apply formatting based on specific rules or conditions being met.

• Automatically apply highlighting to selected cell ranges based on specific rules or conditions being met

• Automatically change the font of selected cell ranges based on specific rules or conditions being met.

• All of the options listed above are correct.

Which of the following formatting options can you set for Conditional Formatting rules?

• Light Red Fill With Dark Red Text, Yellow Fill With Dark Yellow Text and Green Fill With Dark Green Text

• Light Red Fill With Dark Red Text.

• Light Red Fill, Light Yellow Fill and Light Green Fill.

• You can apply any of the formatting detailed in the options above as well as number, border, shading and font formatting.

How do you change the range of cells that a Conditional Formatting rule applies to?

• You cannot change the range, you have to clear the rule first and then reapply it

• In the Conditional Formatting Rules Manager dialogue box, edit the cell range for the rule in the Applies To section.

• Select the cell range and reapply the rule. This will automatically delete the previous rule and create a new one.

• Right click the cell range and select Update Conditional Formatting Rule from the menu list.

Immediately after applying a conditional formatting rule, you realize it is a mistake. How do you fix it? Choose the best answer: .

• You have to clear the rule you created by going to the Conditional Formatting Rules Manager dialogue box and deleting the rule

• You have to clear all rules that have been applied to the worksheet or selected range, by clicking on the Clear Rules button.

• You can simply press the Undo button or use the shortcut Ctrl+Z to undo the last rule created.

• You can right click the area where the conditional formatting rule has been applied and select Clear Rule from the menu list.

You can check the conditions against __________ when applying conditional formatting.

• Cell Value

• Formula

• Both A & B

• None of the above

Which option is used for Creating Rules in Conditional formatting on Excel?

• New Rules

• Manage Rules

• Clear Rules

• All of the Options