Row - going across - rows are numbered
Column - going down - columns are lettered
Copy - Apple-C (or Flower-C)
Paste - Apple-V (or Flower-V)
* - Asterisk (or Splat or Star) - used in computers to indicate multiplication
Formulas
=A1+1 - displays the value of cell A1 plus 1
=A1*2 - displays the value of cell A1 times 2
=SUM(A1:A6) - displays the value of the sum of cells A1 through A6
Exercise 1 - Create a speadsheet, using formulas, which looks like the following, but extend the table to 20 rows:
| 1 | 1 |
| 2 | 2 |
| 3 | 4 |
| 4 | 8 |
| 5 | 16 |
Exercise 2 - Create a two-dimensional column chart from the above spreadsheet.
Exercise 3 - Create a two-dimensional line chart from the above spreadsheet.
Exercise 4 - Create a spreadsheet, using formulas, which looks like the following, but extend the table to 12 rows:
| 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 |
| 2 | 4 | 6 | 8 | 10 | 12 | 14 | 16 | 18 | 20 | 22 | 24 |
| 3 | 6 | 9 | 12 | 15 | 18 | 21 | 24 | 27 | 30 | 33 | 36 |
| 4 | 8 | 12 | 16 | 20 | 24 | 28 | 32 | 36 | 40 | 44 | 48 |
Exercise 5 - Create a 3-D column chart from the above spreadsheet.
Exercise 6 - Create a 3-D line chart from the above spreadsheet.