Microsoft Excel
Lists exercise
Harder than average exercise

This Microsoft Excel LISTS 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: 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 Advanced Excel training course!

All content � Wise Owl Business Solutions Ltd 2007.  All rights reserved.  Design by Branches.