Microsoft Office
Pivot tables exercise
Average difficulty

This Microsoft Office PIVOT TABLES exercise is provided to allow potential course delegates to assess their suitability for the Wise Owl ADVANCED EXCEL course only, and may not be reproduced in whole or in part in any format without the prior written consent of Wise Owl.

Exercise: Plants - pivot tables

1)	Download the files needed to start this exercise: exercise-192.zip (and click here if you experience any problems unzipping this file after downloading it).
2)	Delete one row to make this spreadsheet into a list.
3)	Create a pivot table showing the average price of plants by type and category:
	Soil and Colour are additional page fields
4)	Use this pivot table to show: That there are actually 4 plants of category Flower and type Annual, whose average price is £0.94 That the average price of evergreen pink acidic shrubs (!) is £15.99.
5)	Close this file down without saving any changes.

Thank you for showing an interest in this Advanced Excel training course!

Return to the list of exercises for this topic