WorksheetsConditional Formatting in Excel
Total questions: 1
Worksheet time: 7mins
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
