Excel | Pivot tables exercise | Roller Coaster - Pivot Table

This exercise is provided to allow potential course delegates to choose the correct Wise Owl Microsoft training course, and may not be reproduced in whole or in part in any format without the prior written consent of Wise Owl.

The answer to the exercise will be included and explained if you attend the course listed below!

Software ==> Excel  (145 exercises)
Version ==> Excel 2010 and later
Topic ==> Pivot tables  (4 exercises)
Level ==> Average difficulty
Course ==> Excel Advanced
Before you can do this exercise, you'll need to download and unzip this file (if you have any problems doing this, click here for help).

You need a minimum screen resolution of about 700 pixels width to see our exercises. This is because they contain diagrams and tables which would not be viewable easily on a mobile phone or small laptop. Please use a larger tablet, notebook or desktop computer, or change your screen resolution settings.

Open the spreadsheet in the folder above :

Excel 2010 exercise - Pivot tables (image 1)

You should see this list of UK rides

Convert this data into a pivot table and find the overall average speed of all rides that satisfy the following criteria:

  • The Type is Steel
  • The Design is Sit Down
  • The Amusement Park has the word adventure somewhere in the title

Having narrowed your data down, you should get to this point

Excel 2010 exercise - Pivot tables (image 2)

These rides sound appealing!

Once finished, save you file as Rollercoasters Pivot

This page has 0 threads Add post