Casio Spreadsheet Application Manual do Utilizador descarregar pdf (Página 4)

Casio 9860 Graphic Calculator Self – Guided Instructions SPREADSHEET Mode © Richard Andrew 2008

Generating the Fibonacci Sequence:

Open a new spreadsheet and name it FIB1 (Press EXIT if necessary, then FILE NEW FIB1 EXE)

Enter 1 in A1 and 1 in A2 (Fig 17)

Can you generate the Fibonacci Sequence?

Without looking at the next instructions see if you can generate the Fibonacci Sequence utilizing the skills you have just

used.

How to do it:

To generate the Fibonacci sequence we need the calculator to add cells A1 and A2 and place the result in A3 and to do that

for each successive pair.

Press EDIT F6 FILL

Enter =A1+A2 into the Formula line.

Enter A3:A20 in the Cell Range line. (Fig 18)

Then EXE EXE Here we have the first 20 terms of the Fibonacci sequence! (Fig 19)

Further Fibonacci Investigation:

When we divide a Fibonacci number by the previous Fibonacci number the quotient apparently approaches the golden ratio

with successive divisions.

See if you can show this phenomenon on the calculator. Make the first quotient appear in Cell B2.

How to do it:

Go to Fill by pressing EDIT (F2) (F6) FILL (F1)

In the Formula line enter =A2÷A1 EXE (Fig19B)

In the Cell Range line enter B2:B20 EXE (Fig19C), using F1 for the colon.

Fig17

Fig18

Fig19

Fig19B

Fig19C

1 2 3 4 5 6 7 8 9 ... 21 22

Sem comentários

Casio Spreadsheet Application Manual do Utilizador Página 4