Page 14 - Ones and Zeros 3 (Workbook)

4 Spreadsheets
4

Lesson 3

Line Charts

1. Open the file ‘My Toys.xlsx’.
2. Select the cells B3:G4.

3. Use these cells to make a line chart like the one below.

4. Move the line chart you made so that it doesn’t cover the picture under the cells.

5. Save the file and exit.

Lesson 4

Multiple Lines in Graphs

1. Open the file ‘My Toys.xlsx’.

2. Click on the line chart and press the ‘Delete’ key to remove it.

3. Now, select cells B3:G5 and create a new multiple line graph.
4. Change the graph title to ‘My Toys’.

5. Save the file and exit.

12