
Excel 2019 Certification
Quiz
•
Computers
•
9th Grade
•
Easy
Aimee Dalton
Used 5+ times
FREE Resource
Enhance your content in a minute
16 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
1 min • 6 pts
What is the function used to sum a range of cells in Excel?
MERGE
SUM
ADD
TOTAL
2.
MULTIPLE CHOICE QUESTION
1 min • 6 pts
How can you create a pie chart in Excel?
Click on the Home tab, select Pie Chart from the dropdown menu
Use the Paint tool to draw a pie chart manually
Select data, go to Insert tab, click on Pie Chart, choose style
Copy and paste a pie chart image from the internet
3.
MULTIPLE CHOICE QUESTION
1 min • 6 pts
What is the purpose of a PivotTable in Excel?
The purpose of a PivotTable in Excel is to create animations
The purpose of a PivotTable in Excel is to format text
The purpose of a PivotTable in Excel is to play music
The purpose of a PivotTable in Excel is to summarize and analyze data.
4.
MULTIPLE CHOICE QUESTION
1 min • 6 pts
Explain the concept of conditional formatting in Excel.
Conditional formatting in Excel is only available in the online version
Conditional formatting in Excel enables users to format cells based on specified conditions, making it easier to identify trends, outliers, and important data points within a dataset.
Conditional formatting in Excel is used for creating pivot tables
Conditional formatting in Excel is used for spell-checking
5.
MULTIPLE CHOICE QUESTION
1 min • 6 pts
What formula would you use to find the average of a range of cells in Excel?
=SUM(range)
=MIN(range)
=AVERAGE(range)
=MAX(range)
6.
MULTIPLE CHOICE QUESTION
1 min • 6 pts
Describe the difference between a line chart and a bar chart in Excel.
The difference between a line chart and a bar chart in Excel is that a line chart shows trends over time with connected data points, while a bar chart uses bars to represent data values for easy comparison.
A line chart displays data horizontally, while a bar chart displays data vertically.
A line chart is used for qualitative data, while a bar chart is used for quantitative data.
A line chart uses bars to represent data values, while a bar chart shows trends over time with connected data points.
7.
MULTIPLE CHOICE QUESTION
1 min • 6 pts
How can you apply conditional formatting to highlight cells that contain specific text?
You can apply conditional formatting to highlight cells that contain specific text by selecting the range, going to Conditional Formatting > Highlight Cells Rules > Text that Contains, entering the text, choosing the format, and confirming.
Highlighting cells with specific text can be done by merging cells
Conditional formatting for specific text involves deleting the cells
You can apply conditional formatting by changing the font color of the text
Create a free account and access millions of resources
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
By signing up, you agree to our Terms of Service & Privacy Policy
Already have an account?
Similar Resources on Wayground
15 questions
Mengenal Jendela dan Ikon Microsoft Excel
Quiz
•
7th Grade - University
12 questions
MAC KEYBOARD
Quiz
•
3rd - 9th Grade
11 questions
Tics
Quiz
•
5th Grade - University
11 questions
Excel
Quiz
•
1st - 10th Grade
17 questions
Ergonomics and Keyboard
Quiz
•
9th Grade
20 questions
BAB 3 : TIK KLS 9
Quiz
•
9th Grade
15 questions
Chapter : 9 Working with tables
Quiz
•
5th Grade - University
15 questions
BAB III: Perangkat untuk Akses Internet
Quiz
•
9th Grade
Popular Resources on Wayground
10 questions
Ice Breaker Trivia: Food from Around the World
Quiz
•
3rd - 12th Grade
20 questions
Halloween Trivia
Quiz
•
6th - 8th Grade
25 questions
Multiplication Facts
Quiz
•
5th Grade
4 questions
Activity set 10/24
Lesson
•
6th - 8th Grade
22 questions
Adding Integers
Quiz
•
6th Grade
10 questions
How to Email your Teacher
Quiz
•
Professional Development
15 questions
Order of Operations
Quiz
•
5th Grade
30 questions
October: Math Fluency: Multiply and Divide
Quiz
•
7th Grade
Discover more resources for Computers
10 questions
Exploring Digital Citizenship Essentials
Interactive video
•
6th - 10th Grade
20 questions
Six Weeks Test 2 Review
Lesson
•
9th - 12th Grade
12 questions
Overview of Mexico Part 1
Lesson
•
9th - 12th Grade
10 questions
Exploring Computer Hardware and Software Components
Interactive video
•
6th - 10th Grade
