MS Excel Pivot Table Quiz 18

Test your Excel Pivot Table skills with this 20-question MCQ quiz! This MS Excel Pivot Table Quiz is perfect for students, statisticians, data analysts, and data scientists preparing for exams or job interviews. Master Excel Pivot Table concepts like grouping, filtering, calculations, and custom lists to boost your data analysis efficiency. Excel Pivot Table Quiz, PivotTable MCQ, data analysis test, Excel interview questions, PivotTable exam prep. Let us start MS Excel Pivot Table Quiz now.

Online MS Excel Pivot Table Quiz with Answers

1. You can choose to display a sub-total as a sum and as an average, and both these items will appear separately at the bottom of the respective section in your PivotTable.

 
 

2. If you choose Show Report Filter Pages after having selected multiple items in a filter, what would happen?

 
 
 
 

3. One way to filter which columns and which rows appear in your PivotTable is to use the drop-down menu that appears next to Row Labels and Column Labels.

 
 

4. Rather than seeing discrete values, if you want to see percentages instead, you should go to

 
 
 

5. Which of the following buttons would we need to click to group a few rows from our PivotTable?
MS Excel PivotTable Quiz

 
 
 
 
 

6. When in PivotTable Fields, if you tick a field that contains non-numeric data, it will automatically populate which quadrant?

 
 
 
 

7. If you want to filter by a field that you do not necessarily want to show in the PivotTable itself, you should move this field to which quadrant?

 
 
 
 

8. If you have full dates and you create a PivotTable, Excel will group these dates, such as grouping by month. You can remove this by choosing Ungroup.

 
 

9. Which of these are correct statements about custom lists in Excel?

 
 
 
 

10. A PivotTable currently occupies some of Columns A and B as per the screenshot. The formula that is displayed is typed into cell D4. What would happen to the result of the formula if the filters of the PivotTable were modified?
MS Excel Pivot Table Quiz 4

 
 
 

11. Before you create a PivotTable, you need to ensure that you have nice clean data with

 
 
 

12. When does Excel automatically give you sub-totals for your PivotTable?

 
 
 
 

13. What would moving the Europe cell to elsewhere in the PivotTable do?
MS Excel Pivot Table Quiz

 
 
 

14. Choosing the option Rank Smallest to Largest will result in the PivotTable being sorted and displayed from smallest to largest values.

 
 

15. To clear a filter in a PivotTable, you could:

 
 
 
 

16. Converting your data into a Table before creating a PivotTable is a good idea because:

 
 
 

17. To change the calculation within your PivotTable, you get more options by right-clicking one of the values, compared to customizing the calculation in the Values quadrant.

 
 

18. When in PivotTable Fields, if you tick a field that contains numeric data, it will automatically populate which quadrant?

 
 
 

19. The main difference between Label Filters and Value Filters is that Label Filters are for filtering based on text.

 
 

20. Which of the following buttons would we need to click to group the dates below?
MS Excel PivotTable

 
 
 
 
 

Question 1 of 20

Online MS Excel Pivot Table Quiz with Answers

  • Before you create a PivotTable, you need to ensure that you have nice clean data with
  • Converting your data into a Table before creating a PivotTable is a good idea because:
  • When in PivotTable Fields, if you tick a field that contains numeric data, it will automatically populate which quadrant?
  • When in PivotTable Fields, if you tick a field that contains non-numeric data, it will automatically populate which quadrant?
  • To change the calculation within your PivotTable, you get more options by right-clicking one of the values, compared to customizing the calculation in the Values quadrant.
  • Rather than seeing discrete values, if you want to see percentages instead, you should go to
  • Choosing the option Rank Smallest to Largest will result in the PivotTable being sorted and displayed from smallest to largest values.
  • When does Excel automatically give you sub-totals for your PivotTable?
  • You can choose to display a sub-total as a sum and as an average, and both these items will appear separately at the bottom of the respective section in your PivotTable.
  • If you have full dates and you create a PivotTable, Excel will group these dates, such as grouping by month. You can remove this by choosing Ungroup.
  • Which of the following buttons would we need to click to group the dates below?
  • Which of the following buttons would we need to click to group a few rows from our PivotTable?
  • What would moving the Europe cell to elsewhere in the PivotTable do?
  • Which of these are correct statements about custom lists in Excel?
  • One way to filter which columns and which rows appear in your PivotTable is to use the drop-down menu that appears next to Row Labels and Column Labels.
  • To clear a filter in a PivotTable, you could:
  • The main difference between Label Filters and Value Filters is that Label Filters are for filtering based on text.
  • If you want to filter by a field that you do not necessarily want to show in the PivotTable itself, you should move this field to which quadrant?
  • If you choose Show Report Filter Pages after having selected multiple items in a filter, what would happen?
  • A PivotTable currently occupies some of Columns A and B as per the screenshot. The formula that is displayed is typed into cell D4. What would happen to the result of the formula if the filters of the PivotTable were modified?
Online MS Excel Pivot Table Quiz 4

Try Macroeconomics MCQs Test

Leave a Comment

Discover more from Statistics for Data Science & Analytics

Subscribe now to keep reading and get access to the full archive.

Continue reading