Casio Spreadsheet Application Manual do Utilizador descarregar pdf (Página 21)

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

Now let's transfer an entire file.

This demonstration is using File 5 on the software version of the 9860.

You will need to choose a Stat File that you wish to transfer. To determine which STAT File your calculator is in, return to

STAT and check the SETUP. The 3

line down will tell you the file number (1 – 6). Seek help with this step if stuck.

Delete the data in the spreadsheet (DEL (F3) ALL (F3) YES (F1))

Press RCL (F4) Note: you may need to press F6 to get to RCL (Fig101)

Press FILE (F2)

Insert your desired File number (this demonstration is choosing File 5)

Leave 1

Cell at A1

Press EXE (or F6) (Fig102)

Fig 103 shows that STAT file 5 (Fig97) has been recalled into the spreadsheet.

If I want to save this I can using EXIT F6 FILE (F1) SV-AS (F3) etc

Conditional Commands:

These are quite fun to use when constructing simple spreadsheets that can enhance students understanding of various

concepts. We will start by making a percentages worksheet.

Percentage Tester:

Open a new spreadsheet and name it PERCNT

Enter the labels as in Fig115

Enter 40 into B1, 10 into B2 and 4 into B3 as in Fig 116

With the cursor in Cell B4 type: = If (F4) B1 x B2 ÷ 100 = B3 , 1 , 0 ) (Fig 117)

What this formula is 'saying' is: If the percentage in B2 of the number in B1 = the number in B3 then a 1 will appear in B4.

If the result is false a zero will be placed in B4.

Fig101

Fig102

Fig103

Fig115

Fig116

Fig117

1 2 ... 16 17 18 19 20 21 22

Sem comentários

Casio Spreadsheet Application Manual do Utilizador Página 21