Casio Spreadsheet Application Uživatelský manuál stáhnout pdf (Strana 11)

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

Editing a Formula:

(eg Calculating the Median starting with a Mean formula):

Using the same spreadsheet let's change the first Mean to a Median.

Change the label in cell B1 to MEDIAN.

Place the cursor into Cell C1 (If the Mean formula does not display, press EDIT (F2) CELL (F3))

Rather than enter a whole new formula let's just edit the one we have.

Arrow right two places, press DEL (next to AC/ON) CEL (F5) Med (F4) EXE (Fig46)

Calculations Using Pythagoras' Theorem:

Can you do it?

The task is to build a spreadsheet which will calculate the hypotenuse given the two short sides of a right angled triangle

AND the unknown short side given the hypotenuse and the first short side. See if you can make such a spreadsheet.

Creating a Pythagorean Calculator:

One example of this spreadsheet:

Type in the labels as shown in Fig47:

The lengths of Short Sides 1 and 2 will be entered into Cells A2 and B2 respectively and the solution for the Hypotenuse

will be entered in Cell C2.

The bottom section is a rearrangement of the top section with the length of Short Side 2 being calculated in Cell C5.

Calculating the Hypotenuse in Cell C2:

Place the cursor in Cell C2

Press SHIFT = SHIFT

( ALPHA A2

+ ALPHA B2

) (Fig48)

Press EXE.

Calculating the Unknown Short Side in Cell C5:

Place the cursor in Cell C5.

Press SHIFT = SHIFT

( ALPHA B2

– ALPHA A2

) (Fig49)

Fig46

Fig47

Fig48

Fig49

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

Žádné komentáře

Casio Spreadsheet Application Uživatelský manuál Strana 11