MS EXCEL-CONDITIONAL FORMATTING

1.Where will you find the Conditional Formatting command?

• Home>Styles

• Insert>Data

• Home>Number

• Home>Alignment

• Home>Format

2. Which of the following are examples of using the Conditional Formatting command?

• Turn text red if the number is above 1000.

• Change the fill color of a cell to yellow if the number is below 500.

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

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

• All of these are good examples.

Which statement best describes Conditional Formatting?

• Adding decimal places to numbers.

• Adding a preceding dollar sign to numbers.

• Changing the font color.

• Applying a rule to a cell or range of cells.

• None of these answers are correct.

Study the screenshot above. Which option on the Conditional Formatting menu should you click to find the Text That Contains… option?

• Click on the Data Bars option.

• Click on the Highlight Cells Rules option.

• Click on the Top/Bottom Rules option.

• You can click on any of the options in the Conditional Formatting menu to access this option.

Which of the following functions can you NOT perform using the Conditional Formatting option?

• a) Insert icons that visually display the ranking or rating of values in a selected range.

• b) Apply conditional formatting to dates that fall within specified date ranges.

• c)Use conditional formatting to highlight any duplicate values or data in a worksheet.

• d) Use conditional formatting to dynamically underline in red and green any language or spelling errors on a worksheet.