Microsoft Excel
Lists exercise
Relatively easy

This Microsoft Excel 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: Holidays - sorting and filtering

1)	Download the files needed to start this exercise: exercise-185.zip (and click here if you experience any problems unzipping this file after downloading it).
2)	Turn this spreadsheet into a list by deleting any rows or columns that you think aren't needed.
3)	Sort the list of holidays into country order (where two holidays go to the same country, they should appear in resort name order):
	The holidays to America are listed in resort name order
4)	Now apply filtering so that you can only see the holidays which: go to France; and cost less than £300
5)	Your answer should look like this:
	Only 3 holidays meet both criteria
6)	Save this file as Cheap French holidays, and close it down.

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

Return to the list of exercises for this topic