facebook twitter pinterest google plus Youtube
www.TestsTestsTests.com

www.TestsTestsTests.com

Pivot Table Excel Test
Excel 2010 Training - Working with Data
Free Online Microsoft Excel Test

* What is a Pivot Table?
* Inserting a Pivot Table
* Pivot Table Fields
* Using a Report Filter

10 Question Multiple Choice Quiz with Answers
and Answer Explanations

Pivot Tables Excel Test


1) What is a Pivot Table?
a) A table containing data that is organized horizontally.
b) A table used to calculate financial pivot values.
c) A tool used to summarize data.
d) A table containing only black, grey and white formatting.

Question 2 - Excel Pivot Tables Test
2) Study the screenshot above.  Under which tab and in which function group will you find the option to insert a Pivot Table?
a) Under the Insert tab in the Tables group.
b) Under the Formulas tab in the Data Analysis group.
c) In the Data group in the Pivot Tables group.
d) In the Data group in the Tables group.



3) Where is a Pivot Table inserted?
a) Below the last row of data in your worksheet.
b) Next to the last column of data in your worksheet.
c) It depends on whether you select to insert the Pivot Table in the current worksheet or a new worksheet and where your cursor is.
d) Above the first row of data in your worksheet.

4) Which of the following is NOT a box in the PivotTable Fields List?
a) Column Labels
b) Report Filter
c) Values
d) Formulas


Question 5 - Excel Pivot Tables Test
5) Study the screenshot above.  What function does this represent?  Choose the most correct option.
a) This is a Pivot Table Chart.
b) This is a Pivot Table Filter.
c) This is a Pivot Table Report.
d) This is a Pivot Table.



6) What is the first step for creating a Pivot Table?
a) Clicking on the Insert Tab and inserting a Pivot Table.
b) Create or select data that needs to be analyzed.
c) Deciding on which fields (column and row labels) to use to analyze the data.
d) None of the above options are correct.


Question 7 - Excel Pivot Tables Test
7) Study the screenshot above.  The tabs circled in yellow are not ordinarily visible.  What do you need to do in order to access these tabs and the functions they contain?
a) These are called contextual tabs.  To display them click anywhere within a Pivot Table.
b) These are called contextual tabs.  To display them click on the Pivot Table tab on the Ribbon.
c) These are called PivotTable Tools tabs.  To display them tick the PivotTable Tools tick box in the Tables group.
d) These are called PivotTable Tools tabs.  To display them hover your mouse above the normal tabs on the Ribbon.


8) The Sum function is applied to values in a Pivot Table by default.  How can I change this so that values are automatically counted and not summed?
a) Insert the COUNT formula (=Count()) into the PivotTable.
b) Change the format of the values in the Pivot Table to General Numbers.
c) In the Calculations group, change the Summarize Values By to Count.
d) All of the options listed above are correct.


9) After inserting a Pivot Table, the Pivot Table Field List does not automatically appear.  How can you activate this area?
a) Click on the Field List button in the Show group, under Options in the PivotTable Tools contextual tab.
b) Click on the Insert Pivot Table button and select PivotTable Fields List.
c) Go to the Backstage View and in the Options dialogue box, click on the PivotTable tab.  Check the box for PivotTable Fields List.
d) All of the options listed above are correct.

10) How do you remove or delete a Pivot Table?
a) Select the Pivot Table and press Clear All in the Actions group under the Options tab on the PivotTable Tools contextual tabs.
b) Delete the worksheet that contains the Pivot Table.
c) Select the columns and/or rows containing the Pivot Table and press Delete on your keyboard.
d) All of the options listed above are correct.