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:
