
Conditional Formatting in Excel
Authored by Kristy Griffiths
Computers
12th Grade
Used 71+ times

AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
10 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
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
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which tab in Excel contains the conditional formatting option?
Home
Insert
View
Data
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
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
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which of the following is NOT a formatting option mentioned for highlighting cells?
Purple text
Red border
Yellow green
Light red fill
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
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
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
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
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What feature helps to identify duplicate values in a list?
Data Validation
Data Sorting
Conditional Formatting
Remove Duplicates
Access all questions and much more by creating a free account
Create resources
Host any resource
Get auto-graded reports

Continue with Google

Continue with Email

Continue with Classlink

Continue with Clever
or continue with

Microsoft
%20(1).png)
Apple
Others
Already have an account?
Similar Resources on Wayground
0 questions
EXCEL CHAPTER 1-2
Quiz
•
0 questions
Excel 1-11 Review Quiz
Quiz
•
0 questions
MS WORD: Table Tools
Quiz
•
0 questions
Excel Quiz 2
Quiz
•
0 questions
Word Moude 4 Quiz
Quiz
•
0 questions
Excel Lesson 2 Expert
Quiz
•
0 questions
Chapter 5 Excel sections 2-5
Quiz
•
0 questions
5.5 Excel Quizizz
Quiz
•
Popular Resources on Wayground
5 questions
This is not a...winter edition (Drawing game)
Quiz
•
1st - 5th Grade
25 questions
Multiplication Facts
Quiz
•
5th Grade
10 questions
Identify Iconic Christmas Movie Scenes
Interactive video
•
6th - 10th Grade
20 questions
Christmas Trivia
Quiz
•
6th - 8th Grade
18 questions
Kids Christmas Trivia
Quiz
•
KG - 5th Grade
11 questions
How well do you know your Christmas Characters?
Lesson
•
3rd Grade
14 questions
Christmas Trivia
Quiz
•
5th Grade
20 questions
How the Grinch Stole Christmas
Quiz
•
5th Grade
Discover more resources for Computers
26 questions
Christmas Movie Trivia
Lesson
•
8th Grade - Professio...
15 questions
Christmas Song Emoji Pictionary
Quiz
•
7th - 12th Grade
20 questions
Christmas Movies
Quiz
•
1st - 12th Grade
55 questions
CHS Holiday Trivia
Quiz
•
12th Grade
20 questions
Christmas Movie Trivia
Quiz
•
9th - 12th Grade
29 questions
christmas facts
Lesson
•
5th - 12th Grade
20 questions
Christmas Trivia
Quiz
•
5th - 12th Grade
20 questions
Stages of Meiosis
Quiz
•
9th - 12th Grade