Casio Spreadsheet Application Instrukcja Użytkownika Pobierz pdf (Strona 7)

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

Now we need to enter the formula for the Grand Total into cell D6.

Place the cursor in cell D6.

Press SHIFT = CEL (F5) Sum (F5) ALPHA D 2 (Fig 25)

Now we need the colon.

Press EXIT, F3 ALPHA D 5 ) (Fig 26)

Then EXE.

Now let's test the Wage Calculator:

Find the gross amount for a worker on $14.97 per hour who works 14 normal hours, 3 hours at x1.5, 1 hour at x2

and 2 hours at x2.5

Enter the values as shown in Fig27 The final total is $381.73

Let's recalculate this for $12.81 per hour BUT without writing 12.81 five times!

Enter 12.81 into cell B2.

Press EDIT, F6, FILL and enter the values shown in Fig28

Press EXE EXE. Note that 12.81 has been filled into all required cells (Fig29)

Try different values in your Wages Calculator.

Simple Interest vs Compound Interest Investigation:

Can you do it?

The task here is to make a spreadsheet that will give a simultaneous read-out of two Future Values; one for a Simple Interest

scenario and the second for a Compound Interest scenario. You need to allocate 3 cells in which to enter the 3 variables

PRINCIPAL, INTEREST RATE (as a decimal; pa) and TIME (in years). See if you can make such a spreadsheet.

(See Fig30 for layout)

Fig 25

Fig 26

Fig 27

Fig 28

Fig 29

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

Brak uwag

Casio Spreadsheet Application Instrukcja Użytkownika Strona 7