Sort Data in Spreadsheets | IGCSE Information and Communication Technology Preparation - Year 11 PDF Download

Sort Data in Spreadsheets

• Sorting data is a powerful feature in spreadsheets.
  • It organizes your data according to specific criteria.
  • You can sort data in ascending or descending order.
• You can sort data using a single criterion.
  • For instance, you could alphabetically sort a list of names.
  • In Excel, select the column you want to sort and choose 'Sort A to Z' for ascending order or 'Sort Z to A' for descending order.

• You can also sort data using multiple criteria:
  • Sorting data by multiple criteria involves arranging information based on different factors.
  • For instance, in a list of students, you could first sort them by grade and then alphabetically by name within each grade.
  • In Excel, this can be done by selecting the data and choosing the 'Sort' option, adding levels for each criterion.

Consider the following example spreadsheet:

• If you sort the spreadsheet by 'Name' only (A to Z), the data will be organized in a certain way.

• If you first sort by 'Name' (A to Z) and then by 'Age' (Smallest to Largest), the spreadsheet will have a different layout.