Note

Selection of non-contiguous rows and columns can be used for selection of up to two rows or two columns only. You cannot select more than two non-contiguous rows or columns.

These operations are not supported when selecting rows or columns for non-graphing operations, such as statistical calculations, etc. Attempting these operations for a non-graphing operation will cause an error.

Inputting Data into a Cell

The following are the basic steps you need to perform whenever inputting or editing cell data.

uClassPad Operation

 

Data input toolbar

 

1.Tap a cell and then tap the edit box.

This will change the toolbar to a data input toolbar like the one shown in the nearby screenshot.

2.Input the data you want.

You can input data using the keypad, the soft keyboard, the [Calc] menu, and the data input toolbar. See the following sections for more information.

3.After you are finished, tap the s button 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 S button next to the edit box or tap lon the icon panel.

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 equals sign (=), and can contain values, mathematical expressions, cell references, and functions.

The screenshot to the right shows a simple example where a formula in cell B5 calculates the mean of the values in cells B1 through B3. Formulas are calculated dynamically whenever related values are changed, and the latest result is always displayed in the spreadsheet.

uTo input formula “=mean(B1:B3)” in cell B5

1.Tap cell B5 to select it.

2.On the [Calc] menu, tap [List-Statistics] and then [mean].

This will cause “=mean(” to be input into the edit box.

3.Drag from cell B1 to cell B3.

This will input “B1:B3”.

4.Tap the s button next to the edit box or press the Ekey. This will finalize input of “=mean(B1:B3)”.

If you do not input the closing parenthesis ( ) ) it will be input automatically.

Chapter 13: Spreadsheet Application

222