Page 11 - Ones and Zeros 5 (Workbook)

4 Spreadsheets
4

Lesson 1

Tables and Styles

1. Open a new spreadsheet in Microsoft Excel.
2. Add the data displayed to cells ‘B4:C8’.

3. Now, create a table for cells ‘B4:C8’.
4. Change the style of table to ‘Green, Table Style Medium 14’.
5. When you’re done, save the file as ‘Toy-cars.xlsx’ and exit.

Lesson 2

Cell Borders

1. Open the file ‘Toy-cars.xlsx’.
2. Select the table and from the ‘Table Styles’ menu, choose ‘None’ to remove the
table style.
3. Select cells ‘B4:C8’ and select the ‘Border’ tab from the ‘Format Cells’ menu.
4. Apply the dotted borders.

5. When you’re done, save the file and exit.

Lesson 3
Filtering Data

1. Open the file ‘Gary’s Phones.xlsx’ found in your ‘Documents’ folder.

2. Add filters to cells ‘B4:D9’.
3. Sort the data by ‘Colour’. Choose ‘White’.
4. Now, sort the data by the colour ‘Black’.

5. Finally, display all data without filtering it.
6. Save the file and exit.

9 9