Click here for great value web hosting.

ALL ABOUT OFFICE

HOME

ACCESS

EXCEL

WORD

OUTLOOK

POWERPOINT




Search for
 

help


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