]> 0.1 What a Spreadsheet is

Exercise 0.1

Set this all up on your own machine.

Solution:

-3

=A1+1

=B1+1

=C1+1

=D1+1

=E1+1

=A1+1

0

       

=A2+1

1

       

=A3+1

=B3+B2

=B5/B4

     

=A4+1

=B4+B3

=B6/B5

     

=A5+1

=B5+B4

=B7/B6

     

=A6+1

=B6+B5

=B8/B7

     

=A7+1

=B7+B6

=B9/B8

     

=A8+1

=B8+B7

=B10/B9

     

=A9+1

=B9+B8

=B11/B10

     

=A10+1

=B10+B9

=B12/B11

     

=A11+1

=B11+B10

=B13/B12

     

=A12+1

=B12+B11

=B14/B13

     

=A13+1

=B13+B12

=B15/B14

     

=A14+1

=B14+B13

=B16/B15

     

=A15+1

=B15+B14

=B17/B16

     

=A16+1

=B16+B15

=B18/B17

     

=A17+1

=B17+B16

=B19/B18

     

=A18+1

=B18+B17

=B20/B19

     

=A19+1

=B19+B18

=B21/B20

     

=A20+1

=B20+B19

=B22/B21

     

=A21+1

=B21+B20

=B23/B22

     

=A22+1

=B22+B21

=B24/B23

     

which becomes

-3

-2

-1

0

1

2

3

4

5

-2

0

             

-1

1

             

0

1

2

           

1

2

1.5

           

2

3

1.66666667

           

3

5

1.6

           

4

8

1.625

           

5

13

1.61538462

           

6

21

1.61904762

           

7

34

1.61764706

           

8

55

1.61818182

           

9

89

1.61797753

           

10

144

1.61805556

           

11

233

1.61802575

           

12

377

1.61803714

           

13

610

1.61803279

           

14

987

1.61803445

           

15

1597

1.61803381

           

16

2584

1.61803406

           

17

4181

1.61803396

           

18

6765

1.618034

           

19

10946

1.61803399

           

20

17711

1.61803399