Psion Teklogix netBook, 32M/64M manual Using ranges, Recalculation, Functions, Naming ranges

Recalculation

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.

Sheet 49

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.

Functions

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.

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.