Conditional Formatting in Excel

What is the primary purpose of using conditional formatting in Microsoft Excel?

• To encrypt data for security purposes

• To correct errors in data automatically

• To merge data from different spreadsheets

• To visualize data and see trends and patterns

Which tab in Excel contains the conditional formatting option?

• Home

• Insert

• View

• Data

What can conditional formatting highlight about students' grades?

• Students who scored below 80

• Students who scored above 90

• Students who scored exactly 100

• Students who missed the exam

Which of the following is NOT a formatting option mentioned for highlighting cells?

• Purple text

• Red border

• Yellow green

• Light red fill

How can conditional formatting be used in a restaurant review scenario?

• To email customers who left bad reviews

• To identify duplicate menu items

• To highlight reviews in the last seven days

• To calculate the average rating

What does the 'Highlight Cells Rules' option in conditional formatting allow you to do?

• Change the spreadsheet's background color

• Highlight cells based on specific criteria like greater than or less than a value

• Automatically sort data alphabetically

• Create pivot tables based on cell values

What feature helps to identify duplicate values in a list?

• Data Validation

• Data Sorting

• Conditional Formatting

• Remove Duplicates

Which conditional formatting option allows you to see the top 10% of values?

• Color Scales

• Data Bars

• Top/Bottom Rules

• Icon Sets

What can 'Data Bars' in conditional formatting help visualize?

• The frequency of duplicate values

• The numeric value of a cell in comparison to others

• The alphabetical order of data

• The length of text in a cell

What version of Excel is being used in the example?

• Office 365

• Excel 2010

• Excel 2016

• Excel 2007