Page 57 - Ones and Zeros 5 (Student Book)

Filtering Data

Heads Up!
Heads Up!
Heads Up!
Heads Up!
adding filters

‘Sort & Filter’ button

‘Filter’ option

Let’s Learn

Spreadsheets allow us to filter data. This is helpful when we want to see specific data,
making it easier to read and find the information we are looking for.

Alphabetical order Numeral order

Let’s Practise

Adding filters.

1
Open the file ‘Filters.xlsx’ in
your ‘Documents’ folder. Click
on a cell in the table.

2
In the ‘Home’ tab, click on the
‘Sort & Filter’ button and then
choose the ‘Filter’ option.

3 The table now has
filters for you to use.

54