Casio Spreadsheet Application User Manual download pdf (Page 9)

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

A quality activity for students could include the investigation

"Using the results from your spreadsheet investigate which variable (P, I or T) has the greatest effect in

creating the greatest difference between FVSI and FVCI. Justify your findings mathematically".

Inserting Rows and Columns:

Commonly when working with spreadsheets we need to insert extra rows and/or columns.

Set up a new spreadsheet and enter the values shown in Fig36.

Inserting a row above Row 1:

Place the cursor somewhere in Row 1.

Press INS (F4) then ROW (F1) (Fig37)

Now follow the same procedure and insert a row between rows 2 and 3.

Now we will insert a column before Column A and another between Columns A and B.

Place the cursor in Column A, press COL (F2)

Place the cursor in Column C, press COL (F2)

Your spreadsheet should look like Fig38.

Opening Created Spreadsheets:

By now you should have created a number of spreadsheets. To go back and open a saved spreadsheet …

From the screen in Fig38 press EXIT then press FILE (F1) then OPEN (F2)

I will open the FIBI sheet. (You choose any of your saved sheets).

With the cursor over FIBI (Fig39) and pressing EXE the Fibonacci spreadsheet opens.

Deleting Spreadsheets:

Any spreadsheet that has been saved can be deleted from the list of spreadsheets.

Press FILE (F1) then OPEN (F2). Place the cursor on the file to be deleted and press DEL (F1)

Fig36

Fig37

Fig38

Fig39

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

No comments

Casio Spreadsheet Application User Manual Page 9