Conditional formatting

Resizing column widths

• i can

• i need help

• need more practice

• i dont know

identify the condition for formatting

• i can

• i need help

• i need more practice

• i dont know

When we want to show the Value in bar Chart which option of conditional formatting is used?

• Data Bar

• Colour Scales

• Icons sets

When we want to show the Value in bar Chart which option of conditional formatting is used?

• Data Bar

• Colour Scales

• Icons sets

Which of the following are examples of using the Conditional Formatting command

• Turn text red if the number is above 1000.

• Turn the number to green if the number is in the bottom 10

• all of these

• Insert a red triangle before the number if it falls in the lower 3rd.

  All of these are good examples

​ (a)   option is used for Creating Rules in Conditional formatting in excel

• New Rules
• Conditional Rules
• Formatting Rules

What is the purpose of using the Conditional Formatting command?

• To highlight specific data based on certain conditions

• To change the font style of the entire worksheet

• To create new data sets

Which conditional formatting option is used to display data in the form of bars?

• Data Bar

• Colour Scales

• Icon Sets

What is an example of using the Conditional Formatting command?

• Changing the cell color based on the value

• Inserting a new row in the worksheet

• Creating a pivot table

What is the purpose of using the VLOOKUP function?

• To search for a value in the first column of a table and return a value in the same row from another column

• To change the font style of the entire worksheet

• To create new data sets