First, Alistair needs to create a new spreadsheet.
A spreadsheet consists of a series of rows and columns.Each row is identified by a number, each column by a letter of the alphabet.
Where a row and column intersect, the cell is given the reference of the row/column. For example, the cell where row 2 and column C meet is called C2. This reference is important, as it is needed when creating formulas.
In this example, cell B3 shows how many pens have been sold.
A
B
C
D
1
10 Dec 02
2
number sold
price
total
3
Pens
8
£1
£8.00
4
Pencils
6
50p
£3.00
Alistair makes a start on his spreadsheet by typing in the following headings:
