Menu

Pivot Tables - Categories

Drag answers into the correct category. Once all of the answers have been categorised press submit to check your answers.

Rows, Values, Columns or Filters? (round 1 of 2)

Rows
Values
Columns
Filters

Answers
Leaves out unwanted data
Main grouping down the side
Chooses how to summarise the data
Hides records you do not want
Each value gets its own heading across the top
Lists each value once, one under another
The field that gets calculated
Adds a second grouping across the top
Narrows the data down
Log in or sign-up to access the categorising activity



Don't have a login?

You can still revise this topic