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:
Artist
Title
Price
There is lots of information available online
to help you with putting spreadsheets
together. Have a look at: Please note that the Â鶹Éç is not responsible
for the content of other websites.
