EXCEL
Entering Data
The table below shows the daily
rainfall in the UK in 1990:
|
1990
|
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
|
1
|
0.8
|
9.7
|
1.6
|
9.1
|
0.0
|
6.3
|
0.0
|
0.0
|
0.0
|
3.9
|
3.1
|
0.0
|
|
2
|
1.1
|
0.1
|
0.2
|
1.2
|
0.0
|
0.6
|
0.0
|
0.3
|
0.6
|
8.8
|
1.8
|
0.0
|
|
3
|
6.7
|
3.1
|
0.8
|
0.0
|
0.0
|
0.5
|
10.9
|
1.1
|
0.2
|
3.4
|
0.1
|
0.0
|
|
4
|
0.5
|
1.8
|
0.0
|
0.1
|
0.1
|
2.5
|
0.5
|
0.1
|
1.7
|
7.1
|
0.0
|
0.0
|
|
5
|
0.0
|
13.3
|
0.0
|
0.0
|
0.0
|
3.1
|
0.1
|
0.0
|
1.5
|
17.7
|
0.0
|
0.0
|
|
6
|
2.1
|
17.7
|
0.5
|
0.0
|
1.1
|
7.6
|
6.5
|
0.0
|
1.3
|
1.4
|
0.0
|
12.4
|
|
7
|
0.3
|
10.0
|
9.4
|
0.0
|
11.6
|
7.2
|
0.6
|
0.0
|
0.0
|
0.0
|
0.0
|
5.6
|
|
8
|
3.5
|
1.4
|
8.1
|
0.5
|
5.5
|
0.1
|
1.3
|
3.0
|
4.5
|
0.0
|
0.0
|
0.2
|
|
9
|
5.3
|
0.1
|
3.8
|
0.3
|
0.8
|
0.0
|
0.9
|
0.8
|
0.0
|
1.8
|
1.5
|
0.0
|
|
10
|
0.4
|
4.0
|
0.5
|
0.1
|
5.3
|
0.0
|
0.0
|
0.0
|
0.0
|
16.8
|
0.2
|
0.0
|
|
11
|
0.0
|
4.6
|
0.0
|
1.4
|
0.0
|
0.0
|
0.3
|
1.2
|
0.0
|
1.0
|
1.7
|
1.0
|
|
12
|
0.0
|
5.3
|
3.6
|
3.4
|
0.1
|
0.0
|
0.1
|
4.6
|
0.0
|
0.0
|
0.6
|
0.0
|
|
13
|
0.5
|
4.8
|
0.6
|
0.2
|
0.0
|
0.0
|
0.0
|
0.1
|
0.0
|
0.0
|
0.0
|
0.0
|
|
14
|
0.5
|
1.4
|
0.2
|
4.3
|
4.6
|
0.0
|
0.1
|
6.5
|
0.0
|
14.2
|
0.2
|
0.0
|
|
15
|
2.9
|
0.0
|
0.0
|
2.2
|
3.0
|
0.0
|
2.4
|
2.1
|
0.0
|
22.7
|
3.2
|
0.0
|
|
16
|
1.7
|
5.3
|
0.0
|
8.5
|
6.9
|
0.0
|
0.0
|
0.1
|
1.6
|
7.0
|
5.9
|
1.3
|
|
17
|
0.2
|
1.4
|
0.0
|
4.3
|
0.1
|
1.7
|
0.0
|
0.4
|
1.4
|
8.6
|
3.2
|
0.0
|
|
18
|
3.9
|
3.2
|
3.9
|
4.4
|
0.0
|
7.0
|
0.0
|
23.1
|
6.5
|
0.6
|
1.7
|
0.8
|
|
19
|
0.0
|
1.1
|
0.0
|
2.1
|
0.0
|
3.0
|
0.0
|
0.1
|
0.0
|
1.0
|
3.8
|
1.6
|
|
20
|
0.1
|
0.1
|
1.6
|
0.1
|
0.0
|
0.0
|
0.0
|
0.2
|
0.3
|
1.7
|
2.1
|
2.3
|
|
21
|
1.9
|
0.2
|
0.9
|
0.0
|
0.0
|
0.0
|
0.0
|
0.0
|
0.0
|
0.0
|
0.0
|
0.1
|
|
22
|
13.3
|
0.0
|
0.2
|
0.0
|
0.0
|
3.5
|
0.0
|
0.0
|
0.1
|
0.0
|
2.5
|
15.2
|
|
23
|
3.4
|
13.7
|
1.0
|
0.1
|
0.0
|
4.0
|
0.0
|
7.5
|
0.6
|
1.5
|
19.2
|
7.4
|
|
24
|
16.9
|
9.6
|
2.3
|
0.0
|
0.0
|
0.1
|
0.0
|
11.6
|
0.0
|
0.0
|
0.1
|
9.8
|
|
25
|
8.7
|
8.3
|
0.2
|
5.5
|
0.0
|
1.9
|
0.0
|
0.7
|
0.0
|
5.1
|
0.0
|
10.2
|
|
26
|
0.1
|
13.2
|
0.0
|
0.5
|
0.0
|
8.9
|
0.0
|
2.2
|
0.0
|
0.7
|
0.0
|
12.7
|
|
27
|
0.0
|
10.4
|
0.3
|
0.2
|
0.0
|
0.0
|
4.1
|
2.6
|
0.5
|
15.3
|
0.0
|
4.4
|
|
28
|
4.4
|
9.9
|
0.1
|
0.0
|
2.4
|
0.3
|
2.9
|
15.6
|
0.1
|
0.1
|
0.0
|
7.7
|
|
29
|
2.0
|
|
0.0
|
0.0
|
1.1
|
8.2
|
1.1
|
5.2
|
2.2
|
2.6
|
0.1
|
1.5
|
|
30
|
5.5
|
|
0.0
|
0.0
|
0.0
|
3.0
|
0.0
|
1.5
|
0.0
|
4.6
|
0.0
|
1.3
|
|
31
|
1.4
|
|
0.0
|
|
0.0
|
|
0.0
|
0.0
|
|
0.1
|
|
1.8
|
This data can be entered into a
spreadsheet as shown below:
Notice the labels on the columns and
rows of the spreadsheet, each box within the spreadsheet is called a ‘cell’
and the combination of column letter and row number are used to obtain the
‘cell reference’ for use in calculations, etc.
In the spreadsheet shown above, cell B1 contains the text ‘Rainfall
(mm)’, notice that the column letter is written before the row number.
It is wrong to refer to this cell as ‘1B’.
When entering data (text or numbers) in a cell, simply click on the cell
and enter the information. If you
want to force a line break in the text in a cell you can do this by holding down
the ALT key and pressing
ENTER at the same time instead of
pressing Enter on its own as the Enter key will normally place your data in the
cell and move to the next cell.
If you look at the bottom of the
current worksheet you will see a tab containing the word ‘Sheet1’.
This denotes the ‘worksheet’, a spreadsheet workbook may contain many
worksheets and these can be labelled on the tabs at
the bottom of the sheet. You should
be aware that a spreadsheet workbook may contain more than one sheet, you may
miss some data if you do not notice this.
Click here to
return to the Excel index.
webmaster@allaboutoffice.co.uk |
