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

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

Press EXE (Fig19D)

We can see that the Golden Ratio does appear to be approached with successive divisions in this way. For closer inspection

we could repeat this exercise using a computer spreadsheet.

A Retainer-Plus-Commission Investigation:

Can you do it?

Consider the following challenge: Find three different combinations of

• Retainer Amount

• Sales Made and

• Percentage Rate of Commission

which earn a salesperson $2850 in a week.

Your task is to build a spreadsheet which will assist you in this investigation.

Building the Retainer-plus-Commission Calculator:

Create a new spreadsheet and name it suitably… Press File (F1) then NEW (F1).

Now we will enter the labels as shown in Fig20.

NOTE: When entering text into a cell speech quotations (ALPHA EXP) need to be entered first!

Writing RTNR in Cell A1:

Place the cursor in Cell A1. Press ALPHA EXP ALPHA R APLPHA T ALPHA N ALPHA R EXE

Writing SALES in Cell A2

Place the cursor in Cell A2. Press ALPHA EXP ALPHA S APLPHA A ALPHA L ALPHA E ALPHA S EXE

NOTE: A faster way to write is to use the ALPHA-LOCK function (SHIFT ALPHA)

Writing CMSN in Cell A3

Place the cursor in Cell A3. Press ALPHA EXP SHIFT ALPHA C APLPHA M ALPHA S ALPHA N EXE

Now write TOTAL in Cell A4

Calculating the TOTAL in Cell B4:

Place the cursor in B4.

Type SHIFT = ALPHA B 1 + ALPHA B 2 x ALPHA B 3 (Fig 21)

Fig19D

Fig 20

Fig 21

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

Brak uwag

Casio Spreadsheet Application Instrukcja Użytkownika Strona 5