Open the applet and sort the numbers from the smallest to the largest.

Give examples of ordering that you can see every day. What data can be sorted in Excel and how?

Enter any 5 numbers, dates and texts (words or sentences) into separate columns in the worksheet. Sort them using the ‘Sort’ tool. Learn how to change the orderorderorder of sortingsortingsorting: ascending/descending (A‑Z/Z‑A).

Now enter any 5 numbers in one row in the worksheet. Sort them in an ascending and descending orderorderorder.

Check how texts including lowercase and uppercase letters are sorted - how the cells containing for example: ala, Ala, aLA, aLa, AlA will be sorted.

Sort orderorderorder ascending (A‑Z):

1. numbers – from the smallest to the largest,

2. text – alphabetical from A to Z,

3. dates – from the oldest to the newest.

Sort orderorderorder descending (Z‑A):

1. numbers – from the largest to the smallest,

2. text – alphabetical from Z to A,

3. dates – from the newest to the oldest.

SortingsortingSorting according to the partial valuepartial valuepartial value in the column.

If Excel cannot sort given data itself, we can select particular parts of the data by using other functions. These parts can be sorted separately.

Describe a selected method of sorting in English.