Casio Spreadsheet Application Manuel d'utilisateur télécharger pdf (Page 8)

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

Building an SI/CI Spreadsheet:

Here is one example of a SI/CI spreadsheet.

Enter the headings as shown in Fig30

Calculating the Simple Interest Future Value in Cell D1:

Place the cursor into cell D1

Enter =B1+B1xB2xB3 EXE (Fig 32)

Calculating the Compount Interest Future Value in Cell D2:

Place the cursor into cell D2

Enter =B1(1+B2)^B3 EXE (Fig33)

Compare the Future Values with P=1000, I=0.12, T=5 (Fig34)

Compare the Future Values with P=1000, I=0.12, T=50 (Fig35)

Fig 30

Fig 31

Fig 32

(Fig33)

Fig34

Fig35

1 2 3 4 5 6 7 8 9 10 11 12 13 ... 21 22

Pas de commentaire

Casio Spreadsheet Application Manuel d'utilisateur Page 8