A student selects their data and inserts a pivot table, leaving the default choice to place it on a new sheet. Where does the pivot table appear?
On a new sheet, on a tab of its own
A student puts Holiday Type in Rows and Gender in Columns. What does this create?
A two-dimensional table comparing two sets of data
A student adds Tickets to the Values area. Which summary should be chosen to give a total for each genre?
SUM, which adds the values together
A student wants to know how many customers visited each day, using a column of customer names. Which summary should they choose?
COUNTA
Two groups of different sizes are being compared. Why is AVERAGE of Price Paid fairer than SUM?
A bigger group has a bigger total even if each person pays less
A pivot table of tickets per genre has a Grand Total row showing 105. What does this number mean?
The total tickets sold across all of the genres
A student wants to find which genre has the best average star rating. Which setup gives the answer?
Row: Genre, Value: Star Rating, Summarise by AVERAGE
Why does a pivot table save time compared with writing formulas and functions to summarise the same data?
It groups the data and works out the totals, averages or counts
A pivot table has Holiday Type in Rows, Gender in Columns and COUNTA of Holiday Type in Values. How does a student find the most popular holiday type with men?
Look down the M column for the highest count
A student has a table of data with headings and wants to make a pivot table. What should they do first?
Select all of the data, including the headings
A pivot table counts the tickets sold on each day. Monday 24, Tuesday 31, Wednesday 18, Thursday 27. Which day sold the fewest tickets?
Wednesday
A student creates a pivot table from a table of data. What happens to the original data?
It stays the same on its own sheet
In the pivot table editor, which area is used to narrow down which records are summarised, for example to show only one year group?
Filters
Which of these best describes what a pivot table does?
It groups and summarises the data
We use cookies to enhance your experience. You can manage your preferences or learn more in our Cookie Policy.