Page 54 - Ones and Zeros 4 (Student Book)

Sorting Data

alphabetical order
numerical order

‘Sort & Filter’ button

Let’s Learn

Spreadsheets allow us to sort data into alphabetical or numerical order. This is helpful
when we want to see data in a specific order, making it easier to read and find the
information we are looking for.

File Edit View Help

Name Age Name Age
Adam 12 Chione 11
Anna 14 Adam 12
Bill 13 Jabare 12
Chione 11 Jack 12
Ebonee 15 Joanna 12
George 13 Kimberly 12
Henry 13 Bill 13
Jabare 12 George 13
Jack 12 Henry 13
Joanna 12 Anna 14
Kimberly 12 Mark 14
Mark 14 Mary 14
Mary 14 Ebonee 15
Nephi 15 Nephi 15
Susan 15 Susan 15

Let’s Practise

Sorting data.

1 Open the file ‘Points Per Game.xlsx’. As you can

see, we have a list of players of a basketball
team in column ‘B’. In column ‘C’, we have their
average score per game.

52