Pivot Tables - Crossword

Clues

1. Spreadsheet tool that groups, filters and summarises large amounts of data automatically. (10)
2. Editor area holding the field you group records by, one label per line. (4)
3. Editor area holding the field that will be calculated or summarised. (6)
4. Editor area that adds a second grouping across the top of the grid. (7)
5. Editor area that narrows the data down, for example to one year group. (7)
6. Summary type that adds up the numbers in a group. (3)
7. Summary type that finds the mean and is fairer when groups are different sizes. (7)
8. Summary type that works out how many numbers a group holds. (5)
9. Summary type that gives how many records exist, including those holding text. (6)