Unit 6 - Task 3: Sorting and Filtering the spreadsheet


Pass

A1 - Sort the data using one field

Sort the data to organise your spreadsheet.

A2 - Filter data using one field

Use the auto-filter tool to select certain data


Merit

B1 - Sort data using at least two fields

B2 - Filter the data using at least two fields

Sorting Help Sheet
Filtering Help Sheet


Distinction

C1 - Customise at least one filter