Filter
Top Products
49Sheet
RR
RR
R
ecalculationecalculation
ecalculationecalculation
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.
FF
FF
F
unctionsunctions
unctionsunctions
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 rangesUsing ranges
Using rangesUsing ranges
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 rangesNaming ranges
Naming rangesNaming ranges
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.