Excel - Basic 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

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

Use the audio player above to hear answers and helpful tips