How it Works
Casio
Loading...
Spreadsheet Application 2.0
Application User Manual
74 pgs817.11 Kb0
Table of contents
Loading...

Casio Spreadsheet, Spreadsheet Application 2.0 Application User Manual

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

Using the Spreadsheet Application

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

Contents

1
Contents
1 Spreadsheet Application Overview .................................................................... 1-1
Starting Up the Spreadsheet Application ....................................................................... 1-1
Spreadsheet Window ..................................................................................................... 1-1
2 Spreadsheet Application Menus and Buttons................................................... 2-1
3 Basic 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
4 Editing 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
5 Using the Spreadsheet Application with the eActivity Application ................. 5-1
Drag and Drop ................................................................................................................ 5-1
6 Using the Action Menu ........................................................................................ 6-1
Spreadsheet [Action] Menu Basics ................................................................................ 6-1
Action Menu Functions ................................................................................................... 6-4
7 Formatting 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
Spreadsheet Application Overview
1-1

1 Spreadsheet 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.
u ClassPad 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.
Column letters (A to BL)
Row numbers (1 to 999)
Edit box
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.
Cell cursor
Edit buttons
Spreadsheet Application Menus and Buttons
2-1

2 Spreadsheet 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 O menu, see “Using the O Menu” on page 1-5-4 of your ClassPad 300 User’s Guide.
k File Menu
To do this:
Create a new, empty spreadsheet New
Open an existing spreadsheet Open
Save the currently displayed spreadsheet Save
k Edit Menu
To do this:
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
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)
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
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
Select this [File] menu item:
Select this [Edit] menu item:
Options
Number Format
Fill Range
Spreadsheet Application Menus and Buttons
2-2
k Graph Menu
You can use the [Graph] menu to graph the data contained in selected cells. See “8 Graphing” for more information.
k Action 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.
k Spreadsheet Toolbar Buttons
Not all of the Spreadsheet buttons can fit on a single toolbar, tap the u/t button on the far
right to toggle between the two toolbars.
To do this: Tap this button:
Toggle the selected cell(s) between decimal (floating point) and exact
1
display*
Toggle the selected cell(s) between bold and normal M /
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
*1 When cell(s) are calculation data types.
.
/
[
,
B
<
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.
Basic Spreadsheet Window Operations
3-1

3 Basic 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.
u ClassPad Operation
(1) On the [Edit] menu, tap [Options].
Basic Spreadsheet Window Operations
3-2
(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.
k Cursor Keys
When a single cell is selected, you can use the cursor key to move the cell cursor up, down, left, or right.
Basic Spreadsheet Window Operations
3-3
k Jumping 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.
u ClassPad Operation
(1) On the [Edit] menu, select [Goto Cell].
(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.
Basic Spreadsheet Window Operations
3-4

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.
u ClassPad Operation
(1) On the [Edit] menu, tap [Options].
(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].
Basic Spreadsheet Window Operations
3-5

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.
Tap here to select the entire spreadsheet.
Tap a row heading to select the row.
•To select a range of cells, drag the stylus across them.
Tap a column heading to select the column.
Tap a cell to select it.
Basic Spreadsheet Window Operations
3-6

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.
u To 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 r and 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.
Editing Cell Contents
4-1

4 Editing 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.
Data input toolbar
Ta p to apply your input or edits.
Tap to cancel input or editing without making any changes.
Tap to scroll the character buttons.
Editing Cell Contents
4-2
•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.
k Tapping 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
Editing Cell Contents
4-3
k Tapping 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.
u ClassPad 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 s button next to the edit box.
•Press the E key.
Quick Edit • Press a cursor key.
•Or tap the s button next to the edit box.
•Or press the E key.
• This causes the entire spreadsheet to be re-calculated.
• If you want to cancel data input without saving your changes, tap the S button 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.
Editing Cell Contents
4-4

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.
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 (=).
u To use the soft keyboards to input a function
Example: To input the following
(1) Tap cell A1 to select it. (2) Press =, x, and then {.
Cell A1: x^row(A1) Cell B1: diff(A1, x, 1)
Editing Cell Contents
4-5
(3) Press k to display the soft keyboard.
(4) Tap the 0 tab 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 9 tab, tap -,
and then tap -.
(9) Tap cell A1, press ,, x, ,, 1, and then press ). (10) Press E. (11)Press k to 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.
Editing Cell Contents
4-6

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: understand the difference between relative and absolute cell references. Otherwise, your spreadsheet may not produce the results you expect.
k Relative 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”.
relative
and
absolute
. It is very important that you
k Absolute 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
A$1 Always refers to row 1, but the column changes dynamically when
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
moved, as with a relative cell reference
moved, as with a relative cell reference
Editing Cell Contents
4-7
u To 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.
Incorrect cell reference (no “=” sign) Correct cell reference
(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 s button next to the edit box or press the
E key to save it.
Editing Cell Contents
4-8

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 u type:
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)A symbolic expression Text
x+y A 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.
u To input a range of values using Fill Sequence
Example: To configure a Fill Sequence operation according to the following parameters
(1) On the [Edit] menu, tap [Fill Sequence].
Expression: 1/x Change of x Value: From 1 to 25 Step: 1 Input Location: Starting from A1
Editing Cell Contents
4-9
(2) Use the dialog box that appears to configure the Fill Sequence operation as described
below.
Parameter Description
Expr. Input the expression whose results you want to input.
Var.
Specify the name of the variable whose value will change with each step.
Low Specify the smallest value to be assigned to the variable.
High Specify the greatest value to be assigned to the variable.
Step
Start
• The following shows how the Fill Sequence dialog box should appear after
Specify the value that should be added to the variable value with each step.
Specify the starting cell from which the results of the expression should be inserted.
configuring the parameters for our example.
4-10
Editing Cell Contents
(3) After everything is the way you want, tap [OK].
• This performs all the required calculations according to your settings, and inserts the
results into the spreadsheet.
• The following shows the results for our example.

Cut and Copy

You can use the [Cut] and [Copy] commands on the Spreadsheet application [Edit] menu to cut and copy the contents of the cells currently selected (highlighted) with the cell cursor. You can also cut and copy text from the edit box. The following types of cut/copy operations are supported.
•Single cell cut/copy
•Multiple-cell cut/copy
•Selected edit box text cut/copy
•Cell Viewer values and formulas copy only
Cutting or copying data places it onto the clipboard. You can use the [Paste] command to paste the clipboard contents at the current cell cursor or editing cursor location.
4-11
Editing Cell Contents

Paste

The [Edit] menu’s [Paste] command lets you paste the data that is currently on the clipboard at the current cell cursor or editing cursor location.
Important!
•Pasting cell data will cause all relative cell references contained in the pasted data to be changed in accordance with the paste location. See “Inputting a Cell Reference” on page 4-6 for more information.
•Relative cell references in data copied or cut from the edit box do not change when pasted into another cell.
The following summarizes how different types of data can be pasted.
k When the clipboard contains data from a single cell or the edit box
If you do this: Executing the [Paste] command will do this:
Select a single cell with the cell cursor Paste the clipboard data into the selected cell
Select multiple cells with the cell cursor Paste the clipboard data into each of the
selected cells
Locate the editing cursor inside the edit Paste the clipboard data at the editing cursor box location
k When the clipboard contains data from multiple cells
If you do this: Executing the [Paste] command will do this:
Select a single cell with the cell cursor Paste the clipboard data starting from the
Select multiple cells with the cell cursor Paste the clipboard data starting from the first
Locate the editing cursor inside the edit Paste the clipboard data at the editing cursor box location in matrix format
selected cell
(top left) cell
Loading...
+ 51 hidden pages
Buy Points How it Works FAQ Contact Us Questions and Suggestions Privacy Policy Cookie Policy Terms of Use