Home
Excel Questions
Word Questions
PowerPoint Test
>
PowerPoint
Contact Us
Excel Knowledge Test
Basic Level 4
Pivot Tables
The following links will open training videos containing Pivot Table creation information if you need assistance in answering the following questionnaire:
https://youtu.be/ucZHTG3-Jkg
Part 1 - A 10-minute guide to creating and using Excel Pivot Tables
https://youtu.be/Q1uUzXwkqv8
Part 2 - A further guide on the creation and use of Excel Pivot Tables
*
Indicates required field
Name
*
First
Last
Email
*
The main purpose of a Pivot Table is to:
*
Draw a graph of data
Analyse data
Edit text in the spreadsheet
You have created a Pivot Table. Can you change data in cells directly in the Pivot Table?
*
Yes
No
Select the 3 rules needed to create a pivot table
*
Must have headers in columns
Select any cell within the data
Remove blank rows and columns wherever possible
Use Shift-F8 to create the pivot table
Use VLOOKUP to decide which fields to include
Where must data be edited and which command must be used to update the Pivot Table?
*
Copy data in a cell in the original data and then paste in the Pivot Table
Edit the original data, go to the Pivot Table and use the Refresh command
Data in a pivot table can never be refreshed
How do you insert a pivot table?
*
Press Alt-Ctrl
Insert>Pivot Table
Press Ctrl-Home
Can you have more than one Pivot Table in an Excel file?
*
No
Yes
There are four boxes into which fields are dragged and dropped. Name the box which is used for numbers
*
Row
Value
Column
Filter
How does Excel handle numbers in Pivot Tables by default?
*
It shows them in red
It creates a chart
It adds numbers using the SUM function
Click to subscribe
Submit my answers
Use the audio player above to hear answers and helpful tips
Home
Excel Questions
Word Questions
PowerPoint Test
>
PowerPoint
Contact Us