Casio Spreadsheet Application User Manual download pdf (Page 1)

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

Casio 9860 Self-guided Instructions - Spreadsheet Mode

Instructions Screenshots

Getting Started … naming a new sheet:

Go to Menu 4 (S-SHT) and press EXE. Note: You will either have a blank sheet or a sheet with some numbers.

Let's assume we want to make a new sheet. We will call this S1 for Sheet One.

Press File (F1) then NEW (F1)

In Spread Sheet Name:

Press S (X key) then ALPHA 1. Then EXE. (Fig1)

NOTE: when typing Spread Sheet Name the ALPHA button does not need to be pressed to type a letter. ALPHA is already

'ON'.

NOTE: There is a 'Save As' function. If you forget to name your first spreadsheet, you can use 'Save As'. It is under File

(F1), then F3.

Before we enter values please do this:

Place your cursor in Cell A1. Press left arrow (FigA)

Note this hi-lights the Row1.

Now return the cursor to A1 (right arrow) and press up arrow. This hi-lights Column A.

Entering values:

Now make the spreadsheet in Fig2. Do this by scrolling to cell A1 and pressing 1 EXE then 2 EXE etc. Enter the

numbers into all six cells.

Overwriting:

Now, in Column A move the cursor back to A1 and press 3 EXE etc. to over-write 1, 2, 3 with 3 6 9 (Fig 3)

Now, in Column B over-write 2, 4, 6 with 4 8 12 (Fig 4)

Deleting Values:

Let's delete just the 8 for now. Place the cursor over the 8 and press CLR (F5) (Fig 5)

Fig1

FigA

Fig2

Fig3

Fig4

Fig5

1 2 3 4 5 6 ... 21 22

Summary of Contents

Page 1 - Deleting Values:

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

Page 2

Casio 9860 Graphic Calculator Self – Guided Instructions SPREADSHEET Mode © Richard Andrew 2008 10 The GRAB func

Page 3 - A common mistake:

Casio 9860 Graphic Calculator Self – Guided Instructions SPREADSHEET Mode © Richard Andrew 2008 11 Editing a Fo

Page 4 - How to do it:

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

Page 5 - Can you do it?

Casio 9860 Graphic Calculator Self – Guided Instructions SPREADSHEET Mode © Richard Andrew 2008 13 Press EDIT (

Page 6 - Building a Wage Calculator:

Casio 9860 Graphic Calculator Self – Guided Instructions SPREADSHEET Mode © Richard Andrew 2008 14 Sort Row 2

Page 7

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

Page 8

Casio 9860 Graphic Calculator Self – Guided Instructions SPREADSHEET Mode © Richard Andrew 2008 16 Press EXE (

Page 9 - Deleting Spreadsheets:

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

Page 10 - Calculating a Mean:

Page 11 - Editing a Formula:

Page 12 - Cutting and Pasting:

Page 13 - Sorting a column of scores:

Page 14

Page 15

Page 16

Page 17 - Frequency Histograms:

Page 18

Casio 9860 Graphic Calculator Self – Guided Instructions SPREADSHEET Mode © Richard Andrew 2008 5 Press EXE (Fi

Page 19

Casio 9860 Graphic Calculator Self – Guided Instructions SPREADSHEET Mode © Richard Andrew 2008 6 Then EXE The R

Page 20

Casio 9860 Graphic Calculator Self – Guided Instructions SPREADSHEET Mode © Richard Andrew 2008 7 Now we need t

Page 21 - Conditional Commands:

Casio 9860 Graphic Calculator Self – Guided Instructions SPREADSHEET Mode © Richard Andrew 2008 8 Building an S

Page 22 - Logarithm Tester:

Casio 9860 Graphic Calculator Self – Guided Instructions SPREADSHEET Mode © Richard Andrew 2008 9 A quality act

Casio Spreadsheet Application User Manual Page 1

Browse online or download User Manual for Water pumps Casio Spreadsheet Application. Casio 9860 Self-guided Instructions - Spreadsheet Mode

Summary of Contents

More documents for Water pumps Casio Spreadsheet Application

Comments to this Manuals

Casio Spreadsheet Application User Manual Page 1

Browse online or download User Manual for Water pumps Casio Spreadsheet Application. Casio 9860 Self-guided Instructions - Spreadsheet Mode

Summary of Contents

More documents for Water pumps Casio Spreadsheet Application

Comments to this Manuals

Related products and manuals for Water pumps Casio Spreadsheet Application