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. Which of the following buttons would we need to click to group the dates below?

 Group Field

 –

 Ungroup

 +

 Group Selection

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

 It would move Europe but not the associated summary data

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

 It would move Europe and the associated summary data

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

 False

 True

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

 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

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

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

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

 True

 False

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

 You have more than one field in your Columns

 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 Values

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

 Columns

 Rows

 Filters

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

 False

 True

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

 You would get separate PivotTables which are presented side-by-side 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 underneath each filter item on one sheet of your Excel file

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

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

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

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

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

 True

 False

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

 Columns

 Rows

 Filters

 Values

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

 Columns

 None of these

 Filters

 Rows

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

 +

 Ungroup

 Group Field

 –

 Group Selection

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

 You can create your own custom lists

 You can only create custom lists for date-related data

 When sorting Excel favours custom lists over any other data

 Some come standard with Excel

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

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

 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