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

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

Deleting a row:

Let's delete Row 2. leave the cursor anywhere in Row 2 and press DEL (F3) then ROW (F1) (Fig 6)

NOTE: When you delete a row, the rows below 'jump up' one place.

Deleting a column:

Let's delete Column A. Note that we are still in delete mode the delete options ROW, COL and ALL

still displayed at F1, F2 and F3. Place the cursor anywhere in Column A and press COL (F2) (Fig 7)

Note:

When you delete a row, the rows to the right 'jump left' one place.

Deleting all values

: Press ALL (F3) then YES (F1).

Saving Your Work:

It is important to note that the sheets 'save-as-you-go'. This has its advantages and disadvantages. It means you don't need to

do anything to save a sheet. But it also means that if you accidentally delete part of an already produced sheet, you cannot

return to the original.

The Sum Formula:

Enter 1 2 3 4 5 and 2 4 6 8 10 into columns A and B respectively as shown. (Fig 8)

We will put the sum of 1 and 2 into C1, the sum of 2 and 4 into C2, and so on. In other words Column 3 will be the sum of

Column 1 and Column 2.

Just as in excel the = sign turns a command into a formula that will work for all prescribed situations.

You should still be in the delete screen. Press EXIT to return to the 'initial' screen.

Press EDIT (F2) then (F6) then FILL (F1).

In the Formula line type =A1+B1 (SHIFT then ALPHA A 1 + ALPHA B 1 EXE)

In Cell Range type C1:C5 (ALPHA C 1 (F1) ALPHA C 5) (Fig 9)

Then EXE EXE

Fig6

Fig7

Fig8

Fig9

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

Pas de commentaire

Casio Spreadsheet Application Manuel d'utilisateur Page 2