Psion Teklogix 32M/64M Manual Do Utilizador

Sheet

RRRRRecalculation

ecalculation

Sheet automatically recalculates your worksheet every time you

change part of a calculation. You may want to turn this feature off

if you are making a large number of changes in the worksheet. To

do this:

•

Tap the

View Prefs

button on the Toolbar or select the

Preferences

command from the

Tools

menu, and set Auto

recalculation to off. When Auto recalculation is off, a ‘

?-’

symbol will be displayed at the right end of the input line

whenever you need to recalculate manually to update

results.

To make Sheet recalculate the worksheet, select the command

from the

Tools

menu.

FFFFFunctions

unctions

Sheet has a large number of functions, e.g. mathematical,

financial and trigonometric functions, that you can incorporate in

your calculations. See the built-in help on the netBook for a full

list and details of syntax.

•

To use a function in a calculation: just type it in.

Alternatively, tap the function button or select

Function

from the

Insert

menu. Choose the function you require.

Using ranges

A range is a rectangular block of cells. The reference for a range

consists of the cell references of the top left and bottom right

corners of the block, separated by a colon, e.g. B2:C6. You can

use ranges to define areas of the worksheet for applying

formatting, creating graphs, or include range references in

formulae, e.g. =SUM(B2:C6).

•

To select a range: highlight all the cells you want to be a

part of your range.

•

To use a range in a formula: highlight the range to be

inserted while entering the formula. For example, type

“=SUM(” then drag the highlight to cover the appropriate

range, type a “)” and press Enter.

Naming ranges

•

To name a range: highlight the range and add a name using

the

Add name

command from the

Name

commands on

the

Insert

menu. You can use this name in sums and

formulae, e.g. “=AVERAGE(Bills)”. You can edit the range

name using the

Edit name

command.