Pivot Tables Shortcut keys Mix n Match Activity

This resource contains a worksheet that can be printed out. It has a list of short cut keys pertaining to pivot tables and data management in Excel. The activity is a mix and match. Students are required to match the shortcut with the Description. The answer page is included as well as a blank sheet for further shortcut keys to be added.

I generally use this at the beginning of a lesson, once I’ve covered off a bit of general knowledge around pivot tables. I then encourage students to put these short cuts into practice during the session.

Included is a word document and a pdf file, so further editing is permitted. This activity can be carried out individually, in pairs, or groups to add a competitive edge.

Save for later
  • Pivot-Tables-shortcut-keys-list-mix-and-match.docx
  • Pivot-Tables-shortcut-keys-list-mix-and-match.pdf

About this resource


Created: Jul 26, 2018

docx, 24 KB


pdf, 178 KB


Report a problem

Tes Paid Licence

How can I re-use this?