Microsoft Office
Lists exercise
Harder than average exercise

This Microsoft Office LISTS exercise is provided to allow potential course delegates to assess their suitability for the Wise Owl INTRODUCTION TO 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: Market stall - difficult filtering, numbers of records shown

1) Download the files needed to start this exercise: exercise-187.zip (and click here if you experience any problems unzipping this file after downloading it).
2) Make this spreadsheet into a list by adding the appropriate column heading.
3) Use filtering to show that there are:
  • 8 purchases in November 2005
  • 7 purchases in the top 20 percent by price, but only 5 purchases in the bottom 20% by price (how do you explain this discrepancy)
  • 3 purchases in the MS area for code 2 where the price is more than £100
4) Close this file without saving any changes.

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

All content copyright Wise Owl Business Solutions Ltd 2008.  All rights reserved..