Casio Spreadsheet Application User manual

RJA510188-4
E
For ClassPad 300
Spreadsheet
Application
User’s Guide
Version 2.0
http://classpad.net/

20040801
Using the Spreadsheet Application
The Spreadsheet application provides you with powerful, take-along-anywhere spreadsheet
capabilities on your ClassPad.

20040801
Contents
1Spreadsheet Application Overview .................................................................... 1-1
Starting Up the Spreadsheet Application ....................................................................... 1-1
Spreadsheet Window ..................................................................................................... 1-1
2Spreadsheet Application Menus and Buttons ................................................... 2-1
3Basic Spreadsheet Window Operations ............................................................ 3-1
About the Cell Cursor ..................................................................................................... 3-1
Controlling Cell Cursor Movement ................................................................................. 3-1
Navigating Around the Spreadsheet Window ................................................................. 3-2
Hiding or Displaying the Scrollbars ................................................................................ 3-4
Selecting Cells ............................................................................................................... 3-5
Using the Cell Viewer Window ....................................................................................... 3-6
4Editing Cell Contents ........................................................................................... 4-1
Edit Mode Screen ........................................................................................................... 4-1
Entering the Edit Mode ................................................................................................... 4-2
Basic Data Input Steps ................................................................................................... 4-3
Inputting a Formula ........................................................................................................ 4-4
Inputting a Cell Reference .............................................................................................. 4-6
Inputting a Constant ....................................................................................................... 4-8
Using the Fill Sequence Command ................................................................................ 4-8
Cut and Copy ............................................................................................................... 4-10
Paste ............................................................................................................................. 4-11
Specifying Text or Calculation as the Data Type for a Particular Cell .......................... 4-13
Using Drag and Drop to Copy Cell Data within a Spreadsheet .................................... 4-14
Using Drag and Drop to Obtain Spreadsheet Graph Data ........................................... 4-16
5Using the Spreadsheet Application with the eActivity Application ................. 5-1
Drag and Drop ................................................................................................................ 5-1
6Using the Action Menu ........................................................................................ 6-1
Spreadsheet [Action] Menu Basics ................................................................................ 6-1
Action Menu Functions ................................................................................................... 6-4
7Formatting Cells and Data................................................................................... 7-1
Standard (Fractional) and Decimal (Approximate) Modes ............................................. 7-1
Plain Text and Bold Text ................................................................................................. 7-1
Text and Calculation Data Types .................................................................................... 7-1
Text Alignment ................................................................................................................ 7-2
Number Format .............................................................................................................. 7-2
Changing the Width of a Column ................................................................................... 7-3
8Graphing ............................................................................................................... 8-1
Graph Menu ................................................................................................................... 8-1
Graph Window Menus and Toolbar ................................................................................ 8-8
Basic Graphing Steps ................................................................................................... 8-11
Other Graph Window Operations ................................................................................. 8-13
Contents
1

20040801
1-1
Spreadsheet Application Overview
1Spreadsheet Application Overview
This section describes the configuration of the Spreadsheet application window, and
provides basic information about its menus and commands.
Starting Up the Spreadsheet Application
Use the following procedure to start up the Spreadsheet application.
uClassPad Operation
(1) On the application menu, tap R.
•This starts the Spreadsheet application and displays its window.
Spreadsheet Window
The Spreadsheet window shows a screen of cells and their contents.
Row numbers (1 to 999)
Column letters (A to BL)
Edit buttons
Edit box
Cell cursor
Status area
•Each cell can contain a value, expression, text, or a formula. Formulas can contain a
reference to a specific cell or a range of cells.

20040801
2-1
Spreadsheet Application Menus and Buttons
2Spreadsheet Application Menus and Buttons
This section explains the operations you can perform using the menus and buttons of the
Spreadsheet application window.
•For information about the Omenu, see “Using the OMenu” on page 1-5-4 of your
ClassPad 300 User’s Guide.
kFile Menu
To do this:
Select this
[File] menu item:
Create a new, empty spreadsheet New
Open an existing spreadsheet Open
Save the currently displayed spreadsheet Save
kEdit Menu
To do this:
Select this
[Edit] menu item:
Undo the last action, or redo the action you have just undone Undo/Redo
Display a dialog box that lets you show or hide scrollbars, and specify the
direction the cursor advances when inputting data
Options
Automatically resize columns to fit the data into the selected cells AutoFit Selection
Display a dialog box for specifying column width Column Width
Display a dialog box for specifying the number format of the selected cell(s) Number Format
Display or hide the Cell Viewer window Cell Viewer
Display a dialog box for specifying a cell to jump to Goto Cell
Display a dialog box for specifying a range of cells to select Select Range
Display a dialog box for specifying cell contents and a range of cells to fill Fill Range
Display a dialog box for specifying a sequence to fill a range of cells Fill Sequence
Insert row(s) Insert - Rows
Insert column(s) Insert - Columns
Delete the currently selected row(s) Delete - Rows
Delete the currently selected column(s) Delete - Columns
Delete the contents of the currently selected cells Delete - Cells
Cut the current selection and place it onto the clipboard Cut
Copy the current selection and place it onto the clipboard Copy
Paste the clipboard contents at the current cell cursor location Paste
Select everything in the spreadsheet Select All
Clear all data from the spreadsheet Clear All

20040801
kGraph Menu
You can use the [Graph] menu to graph the data contained in selected cells. See “8 Graphing”
for more information.
kAction Menu
The [Action] menu contains a selection of functions that you can use when configuring a
spreadsheet. See “6 Using the Action Menu” for more information.
kSpreadsheet Toolbar Buttons
Not all of the Spreadsheet buttons can fit on a single toolbar, tap the u/tbutton on the far
right to toggle between the two toolbars.
2-2
Spreadsheet Application Menus and Buttons
To do this: Tap this button:
Toggle the selected cell(s) between decimal (floating point) and exact .
/ ,
display*1
Toggle the selected cell(s) between bold and normal M / B
Toggle the data type of the selected cell(s) between text and calculation u / <
Specify left-justified text and right-justified values for selected cell(s) [
(default)
Specify left-justified for selected cell(s) p
Specify centered for selected cell(s) x
Specify right-justified for selected cell(s) ]
Display or hide the Cell Viewer window A
Display the Spreadsheet Graph window (page 8-1) o
Delete the currently selected row(s) H
Delete the currently selected column(s) J
Insert row(s) K
Insert column(s) a
*1When cell(s) are calculation data types.
Tip
•During cell data input and editing, the toolbar changes to a data input toolbar. See “Edit Mode
Screen” on page 4-1 for more information.

20040801
3-1
Basic Spreadsheet Window Operations
3Basic Spreadsheet Window Operations
This section contains information about how to control the appearance of the Spreadsheet
window, and how to perform other basic operations.
About the Cell Cursor
The cell cursor causes the current selected cell or group of cells to become highlighted. The
location of the current selection is indicated in the status bar, and the value or formula
located in the selected cell is shown in the edit box.
•You can select multiple cells for group formatting, deletion, or insertion.
•See “Selecting Cells” on page 3-5 for more information about selecting cells.
Controlling Cell Cursor Movement
Use the following procedure to specify whether the cell cursor should stay at the current cell,
move down to the next line, or move right to the next column when you register data in a
Spreadsheet cell.
uClassPad Operation
(1) On the [Edit] menu, tap [Options].

20040801
(2) On the dialog box that appears, tap the [Cursor Movement] down arrow button, and
then select the setting you want.
To have the cell cursor behave this way when you register Select this
input: setting:
Remain at the current cell Off
Move to the next row below the current cell Down
Move to the next column to the right of the current cell Right
(3) After the setting is the way you want, tap [OK].
Navigating Around the Spreadsheet Window
The simplest way to select a cell is to tap it with the stylus. You can also drag the stylus
across a range of cells to select all of them. If you drag to the edge of the screen, it will scroll
automatically, until you remove the stylus from the screen.
The following are other ways you can navigate around the Spreadsheet window.
kCursor Keys
When a single cell is selected, you can use the cursor key to move the cell cursor up, down,
left, or right.
3-2
Basic Spreadsheet Window Operations

20040801
kJumping to a Cell
You can use the following procedure to jump to a specific cell on the Spreadsheet screen by
specifying the cell’s column and row.
uClassPad Operation
(1) On the [Edit] menu, select [Goto Cell].
3-3
Basic Spreadsheet Window Operations
(2) On the dialog box that appears, type in a letter to specify the column of the cell to
which you want to jump, and a value for its row number.
(3) After the column and row are the way you want, tap [OK] to jump to the cell.

20040801
(2) On the dialog box that appears, tap the [Scrollbars] down arrow button, and then select
the setting you want.
To do this: Select this setting:
Display the scrollbars On
Hide the scrollbars Off
(3) After the setting is the way you want, tap [OK].
Hiding or Displaying the Scrollbars
Use the following procedure to turn display of Spreadsheet scrollbars on and off.
By turning off the scrollbars, you make it possible to view more information in the spreadsheet.
uClassPad Operation
(1) On the [Edit] menu, tap [Options].
3-4
Basic Spreadsheet Window Operations

20040801
Selecting Cells
Before performing any operation on a cell, you must first select it. You can select a single cell,
a range of cells, all the cells in a row or column, or all of the cells in the spreadsheet.
3-5
Basic Spreadsheet Window Operations
Tap a row heading to
select the row.
Tap a column
heading to select
the column.
Tap a cell to select it.
Tap here to select the
entire spreadsheet.
•To select a range of cells, drag the stylus across them.

20040801
Using the Cell Viewer Window
The Cell Viewer window lets you view both the formula contained in a cell, as well as the
current value produced by the formula.
While the Cell Viewer window is displayed, you can select or clear its check boxes to toggle
display of the value and/or formula on or off. You can also select a value or formula and then
drag it to another cell.
uTo view or hide the Cell Viewer window
On the Spreadsheet toolbar, tap A. Or, on the Spreadsheet [Edit] menu, select [Cell
Viewer].
•The above operation toggles display of the Cell Viewer window on and off.
•You can control the size and location of the Cell Viewer window using the rand S
icons on the icon panel below the touch screen. For details about these icons, see “1-3
Using the Icon Panel” of the ClassPad 300 User’s Guide.
3-6
Basic Spreadsheet Window Operations

20040801
4-1
Editing Cell Contents
4Editing Cell Contents
This section explains how to enter the edit mode for data input and editing, and how to input
various types of data and expressions into cells.
Edit Mode Screen
The Spreadsheet application automatically enters the edit mode whenever you tap a cell to
select it and input something from the keypad.
Entering the edit mode (see page 4-2) displays the editing cursor in the edit box and the data
input toolbar.
Tap to apply your input
or edits.
Tap to cancel input or
editing without making
any changes.
Data input toolbar
Tap to scroll the
character buttons.

20040801
•You can tap the data input toolbar buttons to input letters and symbols into the edit box.
Entering the Edit Mode
There are two ways you can enter the edit mode:
•Tapping a cell and then tapping inside the edit box
•Tapping a cell and inputting something on the keypad
The following explains the difference between these two techniques.
kTapping a cell and then tapping the edit box
•This enters the “standard” edit mode.
•Tapping the edit box selects (highlights) all of the text in the edit box. Tapping the edit box
again deselects (unhighlights) the text and displays the editing cursor (a solid blinking
cursor).
•Be sure to use this standard editing mode when you want to correct or change the existing
contents of a cell.
•The following explains the operation of the cursor key after entering the standard editing
mode.
To move the editing cursor here in the edit box text: Press this cursor key:
One character left d
One character right e
To the beginning (far left) f
To the end (far right) c
4-2
Editing Cell Contents

20040801
kTapping a cell and then inputting something from the keypad
•This enters the “quick” edit mode, indicated by a dashed blinking cursor. Anything you input
with the keypad will be displayed in the edit box.
•If the cell you selected already contains something, anything you input with the quick edit
mode replaces the existing content with the new input.
•In the quick editing mode, pressing the cursor key registers your input and moves the cell
cursor in the direction of the cursor key you press.
•Note that you can change to the standard edit mode at any time during the quick edit mode
by tapping inside of the edit box.
Basic Data Input Steps
The following are the basic steps you need to perform whenever inputting or editing cell
data.
uClassPad Operation
(1) Enter the edit mode.
•Either tap a cell (quick edit), or tap a cell and then tap the edit box (standard edit).
•See “Selecting Cells” on page 3-5 for more information about selecting cells.
(2) Input the data you want.
•You can input data using the keypad, the [Action] menu, and the input toolbar. See
the following sections for more information.
(3) After you are finished, finalize the input using one of the procedures below.
If you are using this edit mode: Do this to finalize your input:
Standard Edit • Tap the sbutton next to the edit box.
•Press the Ekey.
Quick Edit • Press a cursor key.
•Or tap the sbutton next to the edit box.
•Or press the Ekey.
•This causes the entire spreadsheet to be re-calculated.
•If you want to cancel data input without saving your changes, tap the Sbutton next to
the edit box or tap on the icon panel.
Important!
•You can also finalize input into a cell by tapping a different cell, as long as the first
character in the edit box is not an equal sign (=). Tapping another cell while the first
character in the edit box is an equal sign (=) inserts a reference to the tapped cell into the
edit box. See “Inputting a Cell Reference” on page 4-6 for more information.
4-3
Editing Cell Contents

20040801
Inputting a Formula
A formula is an expression that the Spreadsheet application calculates and evaluates when
you input it, when data related to the formula is changed, etc.
A formula always starts with an equal sign (=), and can contain any one of the following.
•Values
•Mathematical expressions
•Cell references
•ClassPad soft keyboard functions (cat page of keyboard)
•[Action] menu functions (page 6-4)
Formulas are calculated dynamically whenever related values are changed, and the latest
result is always displayed in the spreadsheet.
The following shows a simple example where a formula in cell B5 calculates the average of
the values in cells B1 through B3.
4-4
Editing Cell Contents
Important!
•Tapping another cell while the first character in the edit box is an equal sign (=) inserts a
reference to the tapped cell into the edit box. Dragging across a range of cells will input a
reference to the selected range. See “Inputting a Cell Reference” on page 4-6 for more
information.
•When a cell is set to text data type, formulas are displayed as text when they are not
preceded by an equal sign (=).
•When a cell is set to calculation data type, an error occurs when a formula is not preceded
by an equal sign (=).
uTo use the soft keyboards to input a function
Example: To input the following
Cell A1: x^row(A1)
Cell B1: diff(A1, x, 1)
(1) Tap cell A1 to select it.
(2) Press =, x, and then {.

20040801
(3) Press kto display the soft keyboard.
(4) Tap the 0tab and then tap r, o, w, or on the [Action] menu, tap [row].
(5) Press (, tap cell A1, and then press ).
(6) Press E.
(7) Tap cell B1 and then press =.
(8) On the soft keyboard, tap the 9tab, tap -,
and then tap -.
(9) Tap cell A1, press ,, x, ,, 1, and then press ).
(10) Press E.
(11) Press kto hide the soft keyboard.
(12) Select (highlight) cells A1 and B1.
(13) On the [Edit] menu, tap [Copy].
(14) Select cells A2 and B2.
(15) On the [Edit] menu, tap [Paste].
•Learn more about cell referencing on the next page.
4-5
Editing Cell Contents

20040801
Inputting a Cell Reference
A cell reference is a symbol that references the value of one cell for use by another cell. If
you input “=A1 + B1” into cell C2, for example, the Spreadsheet will add the current value of
cell A1 to the current value of cell B1, and display the result in cell C2.
There are two types of cell references: relative and absolute . It is very important that you
understand the difference between relative and absolute cell references. Otherwise, your
spreadsheet may not produce the results you expect.
kRelative Cell Reference
A relative cell reference is one that changes according to its location on the spreadsheet.
The cell reference “=A1” in cell C2, for example, is a reference to the cell located “two
columns to the left and one cell up” from the current cell (C2, in this case). Because of this, if
we copy or cut the contents of cell C2 and paste them into cell D12, for example, the cell
reference will change automatically to “=B11”, because B11 is two columns to the left and
one cell up from cell D12.
Be sure to remember that relative cell references always change dynamically in this way
whenever you move them using cut and paste, or drag and drop.
Important!
•When you cut or copy a relative cell reference from the edit box, it is copied to the
clipboard as text and pasted “as-is” without changing. If “=A1” is in cell C2 and you copy
“=A1” from the edit box and paste it into cell D12, for example, D12 will also be “=A1”.
kAbsolute Cell References
An absolute cell reference is the one that does not change, regardless of where it is located
or where it is copied to or moved to. You can make both the row and column of a cell
reference absolute, or you can make only the row or only the column of a cell reference
absolute, as described below.
This cell reference: Does this:
$A$1 Always refers to column A, row 1
$A1 Always refers to column A, but the row changes dynamically when
moved, as with a relative cell reference
A$1 Always refers to row 1, but the column changes dynamically when
moved, as with a relative cell reference
Let’s say, for example, that a reference to cell A1 is in cell C1. The following shows what
each of the above cell references would become if the contents of cell C1 were copied to cell
D12.
$A$1 →$A$1
$A1 →$A12
A$1 →B$1
4-6
Editing Cell Contents

20040801
(4) Tap the cell you want to reference (which will input its name into the edit box
automatically) or use the editing toolbar and keypad to input its name.
Important!
• The above step always inputs a relative cell reference. If you want to input an
absolute cell reference, use the stylus or cursor keys to move the editing cursor to the
appropriate location, and then use the editing toolbar to input a dollar ($) symbol. See
“Inputting a Cell Reference” on page 4-6 for more information about relative and
absolute cell references.
(5) Repeat step (4) as many times as necessary to input all of the cell references you
want. For example, you could input “=A1 + A2”. You can also input a range of cells into
the edit box by dragging across a group of cells.
(6) After your input is the way you want, tap the sbutton next to the edit box or press the
Ekey to save it.
uTo input a cell reference
(1) Select the cell where you want to insert the cell reference.
(2) Tap inside the edit box.
(3) If you are inputting new data, input an equal sign (=) first. If you are editing existing
data, make sure that its first character is an equal sign (=).
•Inputting a cell name like “A3” without an equal sign (=) at the beginning will cause
“A” and “3” to be input as text, without referencing the data in cell A3.
4-7
Editing Cell Contents
Incorrect cell reference (no “=” sign) Correct cell reference

20040801
Inputting a Constant
A constant is data whose value is defined when it is input. When you input something into a
cell for which text is specified as the data type without an equal sign (=) at the beginning, a
numeric value is treated as a constant and non-numeric values are treated as text.
Note the following examples for cells of utype:
This input: Is interpreted as: And is treated as:
sin(1) A numeric expression A constant value
1+1/2 A numeric expression A constant value
1.02389 A numeric expression A constant value
sin(x)Asymbolic expression Text
x+yA symbolic expression Text
Result A string expression Text
sin( Invalid expression context Text
•When text is too long to fit in a cell, it spills over into the next cell to the right if the
neighboring cell is empty. If the cell to the right is not empty, the text is cut off and “...” is
displayed to indicate that non-displayed text is contained in the cell.
Using the Fill Sequence Command
The Fill Sequence command lets you set up an expression with a variable, and input a range
of values based on the calculated results of the expression.
uTo input a range of values using Fill Sequence
Example: To configure a Fill Sequence operation according to the following parameters
Expression: 1/x
Change of xValue: From 1 to 25
Step: 1
Input Location: Starting from A1
(1) On the [Edit] menu, tap [Fill Sequence].
4-8
Editing Cell Contents