Page 53 - Ones and Zeros 5 (Student Book)

Tables and Styles

‘Table’ button
headers ‘Table Styles’ menu
filters

Let’s Learn

Spreadsheets can become more presentable and easier to use if we add tables. Tables
make cells pop out and easier to find, especially when working with large worksheets.
Tables also help us sort, analyse, and filter our data within the worksheet.
If your data isn’t sorted, you may find it difficult to find exactly what you are searching for!

Let’s Practise

Adding a table.
1 Open the file ‘Shopping List.xlsx’

in your ‘Documents’ folder.

2
To add a table to cells ‘C3:D7’, click on
one of the cells you wish to add to a table.

3
From the ‘Insert’ tab, click
on the ‘Table’ button.

4 A menu appears asking if the app
has selected the correct cells. It
also asks if the table has headers.

5
Click ‘OK’ to continue.

50