Casio Spreadsheet Application Bedienungsanleitung PDF herunterladen (Seite 10)

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

The GRAB function:

You may be aware that when using excel there are two ways to enter cell names into a formula: 1) Writing the name eg C1,

D3, etc, and 2) clicking on the required cell.

With the Casio 9860 there are also two ways. We have already used the 'writing the cell name' method.

Now we will look at the 'GRAB' method.

Create the spreadsheet in Fig40 by

entering the numbers 1 to 5 as shown and TOTAL entered into B1.

We will calculate the total in C1.

Place the cursor in C1.

Start entering the formula by pressing SHIFT = CELL (F5) SUM (F5) (Fig41)

Now to use the GRAB function:

Press EXIT GRAB (F1) place the cursor on cell A1 EXE

(F3) GRAB (F1) place the cursor in cell A5 EXE

close bracket ) EXE (Fig42)

Although the advantage of using the GRAB function is only minor most would agree its use is warranted.

Calculating a Mean:

Create a new spreadsheet by entering the 5 values in Column A as shown in Fig43.

We will calculate the mean in Cell C1.

Let's use the GRAB function to help create the formula.

Place the cursor in Cell C1.

Press SHIFT = CELL (F5) MEAN (F3) EXIT GRAB (F1) scroll to A1 EXE : (F3) GRAB (F1) scroll to A5 EXE

close bracket ) EXE (Fig44)

Let's check this by calculating the MEAN the long way.

Into Cell B3 type MEAN2

Place the cursor in Cell C3 and enter the formula shown in Fig45 (Fig45)

Fig40

Fig41

Fig42

Fig43

Fig44

Fig45

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

Keine Kommentare

Casio Spreadsheet Application Bedienungsanleitung Seite 10