NEW
Font size
WorksheetsExcel Data Analysis Quiz
Total questions: 15
Worksheet time: 8mins
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
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
Which Excel function would you use to calculate the average of a range of numbers?
=SUM()
=COUNT()
=AVERAGE()
=MEDIAN()
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
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
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
Which chart type is best for visualising trends over time?
Pie chart
Line chart
Column chart
Doughnut chart
In a Pivot Table, what is the purpose of the 'Values' area?
To filter data
To display summary calculations like sum or average
To group data by categories
To sort data alphabetically
Which function would you use to count only the non-empty cells in a range?
=COUNT()
=COUNTA()
=COUNTBLANK()
=COUNTIF()
What is the main purpose of using Conditional Formatting in Excel?
To change the font size
To automatically format cells based on their values
To insert new rows
To merge cells
Which of the following is a quick way to remove all duplicate rows from a dataset in Excel?
Use the Remove Duplicates tool
Apply a filter
Use the CONCATENATE function
Insert a Pivot Table
If you want to display the distribution of a single variable, which chart type is most appropriate?
Histogram
Pie chart
Scatter plot
Bubble chart
Which Excel function would you use to find the most frequently occurring value in a dataset?
=AVERAGE()
=MODE()
=MEDIAN()
=MAX()
What does the 'Format as Table' feature in Excel help you do?
Automatically apply filters and styles to a range
Create a Pivot Table
Insert a chart
Remove duplicates
Which of the following is a valid use of Conditional Formatting?
To highlight all dates in the past week
To calculate the sum of a column
To remove blank rows
To create a Pivot Chart
