Statistics for Data Science & Analytics

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. Choosing the option Rank Smallest to Largest will result in the PivotTable being sorted and displayed from smallest to largest values.

 False

 True

2. 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?

 Filters

 Columns

 Rows

 None of these

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

 Some come standard with Excel

 You can create your own custom lists

 When sorting Excel favours custom lists over any other data

 You can only create custom lists for date-related data

4. Which of the following buttons would we need to click to group a few rows from our PivotTable?

 Group Field

 +

 –

 Group Selection

 Ungroup

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

 Show Values As

 Value Field Settings

 Summarize Values By

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

 You have more than one field in your Values

 You have more than one field in your Rows

 You have more than one field in your Filters

 You have more than one field in your Columns

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

 It is more efficient to update the PivotTable

 It is not possible to create a PivotTable without the data being in a Table

 It is easier to refer to the data when creating the PivotTable

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

 Filters

 Columns

 Rows

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

 Go back into the Row Label or Column Label dropdown menus and choose Clear Filter

 Go to the PivotTable Analyze tab and select Clear Filters

 Go to the Data tab and select Clear

 Go to the Home tab and select Clear Filter

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

 No blank rows

 No blank columns

 No blank cells

11. 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.

 True

 False

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

 True

 False

13. 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.

 True

 False

14. 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.

 False

 True

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

 Columns

 Values

 Filters

 Rows

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

 You would get separate PivotTables for each filter item on separate sheets in your Excel file

 You would get separate PivotTables which are presented underneath each filter item on one sheet of your Excel file

 You would get one PivotTable that aggregates the multiple filters by Sum on one sheet of your Excel file

 You would get separate PivotTables which are presented side-by-side each filter item on one sheet of your Excel file

17. What would moving the Europe cell to elsewhere in the PivotTable do?

 It would move Europe but not the associated summary data

 It would move Europe and the associated summary data

 It would not work – you would have to select the entire row

18. 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.

 False

 True

19. Which of the following buttons would we need to click to group the dates below?

 Group Selection

 Group Field

 Ungroup

 +

 –

20. 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?

 The result would be re-calculated if the filters in cell A3 changed

 The original answer would remain unchanged even if the filters in cell A3 changed

 The contents of cell D4 would be automatically moved to another cell, depending on the output of the new PivotTable

 Loading …

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?

Try Macroeconomics MCQs Test