Pivot Tables

Question 1

Create pivot table

Answer 1

ALT + N, V

Question 2

Select entire pivot table

Answer 2

CTRL + A

Question 3

Group pivot table items

Answer 3

ALT + SHIFT + >

Question 4

Ungroup pivot table items

Answer 4

ALT + SHIFT + <

Question 5

Hide (filter out) pivot table item

Answer 5

CTRL + -

Question 6

Unhide (clear filter on) pivot table item

Answer 6

ALT + H, S C

Question 7

Insert pivot chart

Answer 7

ALT + N, S Z C