Excel Data Analysis Quiz
Authored by Darshankumar Chauhan
Computers
Professional Development
Used 1+ times
AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
15 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which Excel chart type is most suitable for displaying the proportion of different categories within a whole?
Line chart
Pie chart
Scatter plot
Area chart
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the primary function of a Pivot Table in Excel?
To create colourful charts
To summarise and analyse large datasets
To clean data by removing duplicates
To apply conditional formatting
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which Excel function would you use to calculate the average of a range of numbers?
=SUM()
=COUNT()
=AVERAGE()
=MEDIAN()
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
If you want to highlight all cells in a column that are greater than 100, which Excel feature should you use?
Data Validation
Conditional Formatting
Data Filter
Flash Fill
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which of the following is NOT a method for cleaning data in Excel?
Removing duplicates
Using the TRIM function
Applying a Pivot Table
Find and Replace
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What does the Excel function =STDEV.P() calculate?
The sum of a range
The standard deviation of a population
The product of a range
The percentage change
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which chart type is best for visualising trends over time?
Pie chart
Line chart
Column chart
Doughnut chart
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 Microsoft
or continue with
%20(1).png)
Apple
Others
Already have an account?
