Casio Spreadsheet Application User Manual download pdf (Page 3)

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

Your spreadsheet should look like Fig10

A common mistake:

Look at Column 3 in Fig11. This is the result of trying to make the last spreadsheet BUT making a common mistake in the

formula line. Can you discover/guess what the mistake is?

The mistake is to NOT include the equal sign when entering the formula.

In other words, Formula : A1+B1 is mistakenly written instead of Formula : =A1+B1

Therefore, the calculator will put the sum of A1 and A2 into each designated cell of Column C!!

Calculating Compound Interest:

Let's name a new spreadsheet.

Press EXIT FILE NEW and name the new sheet CI1 (Press C I ALPHA 1 Then EXE) (Fig 12)

Consider the situation of investing $500 at 6.5% pa compounding annually.

Fig 13 shows what the finished spreadsheet will look like:

Enter 500 into cell A1 (Fig 14)

Now we use a formula and fill down into cells A2 to A10.

Press EXIT EDIT F6 FILL

In the formula row type = A1x1.065

In the Cell Range use scroll and the delete button to enter A2:A10 (Fig 15)

Then EXE EXE. Scroll through the cells in column A and note that the formula displays in the bottom right of the screen.

(Fig 16)

Fig10

Fig11

Fig12

Fig13

Fig14

Fig15

Fig16

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

No comments

Casio Spreadsheet Application User Manual Page 3