Excel Data Analysis Quiz

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