Data Cleaning Quiz

What is conditional formatting used for in Excel?

• Changing cell appearance based on specified conditions

• Calculating formulas

• Sorting data alphabetically

• Creating charts and graphs

Which of the following is NOT an appearance option for conditionally formatted cells in Excel?

• Light Red Fill with Dark Red Text

• Green Fill with Dark Green Text

• Blue Fill with Dark Blue Text

• Red Border

What is the purpose of TOP/BOTTOM rules in Excel?

• To add colored bars to cells

• To change font styles

• To change cell borders

• To change cell alignment

What do Data Bars indicate in Excel?

• Cell hyperlinks

• Cell comments

• Cell formulas

• Cell values compared to other values

What do Colour Scales highlight in Excel?

• Cell values compared to other values

• Cell formatting

• Cell validation

• Cell protection

What do Icon Sets add to cells in Excel?

• Icons to indicate cell values compared to other values

• Icons for cell hyperlinks

• Icons for cell comments

• Icons for cell formulas

How can Conditional Formatting rules be managed and removed in Excel?

• Using the Insert tab

• Using the Home tab

• Using the Clear Rules and Manage Rules features

• Using the Review tab

What menu options can be used to remove all rules from a selected range of cells or the entire spreadsheet in Excel?

• Format Cells and Protect Sheet

• Clear Data and Clear Formatting

• Clear Rules and Manage Rules

• Delete and Remove