![background image](http://html.mh-extra.com/html/sharp/zaurus-zr-5700/zaurus-zr-5700_operation-manual_371075296.webp)
33
Two ways to enter cell and range references in
formulas
As you enter a formula, you have two ways to insert a
cell or range reference:
• Type the reference, such as B2:E5, using the key-
board.
• If the blinking edit cursor is at a position to the right of
an arithmetic operator (like “+” or “-”) or a parenthesis,
then touching a cell or range causes that cell or range
reference to be inserted in the formula.
PenCell automatically assumes you want to insert a cell
or range reference if you touch or drag through
worksheet cells when inserting a cell reference would
be appropriate.
Using the built-in functions
PenCell supports certain mathematic business, statisti-
cal and miscellaneous functions. You can include built-in
functions in your worksheet by typing them or, more
simply, by inserting them using
. See Appendix B,
“
Function Reference
,” for the syntax and examples of
built-in functions.
To use a built-in function:
1.
Select a cell.
2.
Touch
(or touch UTILS and select “Insert
Function....”)
3.
Scroll through the list by touching the up and
down arrow. Touch the white area above or
below the scrolling button to move one page
up or down.
4.
Touch a function to select it or touch SUM(),
AVERAGE(), or COUNT() for the
respective function.
Summary of Contents for Zaurus ZR-5700
Page 34: ...34 ...
Page 46: ...46 ...
Page 96: ...96 ...
Page 118: ...118 ...
Page 244: ...244 ...
Page 263: ...viii ...
Page 267: ...4 ...
Page 285: ...22 ...
Page 323: ...60 ...
Page 339: ...76 ...
Page 366: ...103 Communication Applications ...
Page 367: ...104 ...
Page 371: ...108 ...
Page 379: ...116 ...
Page 395: ...132 ...
Page 401: ...144 ...
Page 403: ...146 ...
Page 413: ...156 ...
Page 439: ...182 ...
Page 445: ...188 ...
Page 459: ...202 ...
Page 483: ...226 ...
Page 489: ...232 ...
Page 499: ...242 ...
Page 500: ...243 Terminal Introduction 245 Using Terminal 251 Troubleshooting 258 ...
Page 501: ...244 ...
Page 518: ...261 Index Spreadsheet 263 CompuServe 266 Pager Access 268 AT T Mail 270 Terminal 271 ...
Page 519: ...262 ...
Page 529: ...272 ...