
Excel 2019 Certification
Authored by Aimee Dalton
Computers
9th Grade
Used 6+ times

AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
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
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
15 questions
Excel Chapter 12 Charts
Quiz
•
8th - 9th Grade
20 questions
INTERNET
Quiz
•
9th Grade
12 questions
Number Format and Text Orientation in Khmer
Quiz
•
9th Grade
20 questions
Diagnostico recursos digitales
Quiz
•
9th Grade
15 questions
Preguntas sobre Excel 2016
Quiz
•
6th Grade - University
11 questions
Microsoft Word
Quiz
•
2nd - 10th Grade
14 questions
Google Docs and Google Slides Review
Quiz
•
KG - University
20 questions
Excel Vocabulary and Screen Parts
Quiz
•
8th - 12th Grade
Popular Resources on Wayground
15 questions
Fractions on a Number Line
Quiz
•
3rd Grade
20 questions
Equivalent Fractions
Quiz
•
3rd Grade
25 questions
Multiplication Facts
Quiz
•
5th Grade
22 questions
fractions
Quiz
•
3rd Grade
20 questions
Main Idea and Details
Quiz
•
5th Grade
20 questions
Context Clues
Quiz
•
6th Grade
15 questions
Equivalent Fractions
Quiz
•
4th Grade
20 questions
Figurative Language Review
Quiz
•
6th Grade