i
Formatting cells .............................................. 13
Creating a chart .............................................. 14
Commonly Asked Questions & Answers ... 15
Introduction ................................................ 17
Starting PenCell.............................................. 17
Selecting display modes .................................18
Index mode ....................................................... 18
Sorting the index list.......................................... 18
Worksheet mode............................................... 19
Chart mode ....................................................... 19
Getting to know PenCell .................................20
Using PenCell with other applications............... 20
Tool bar ............................................................. 20
Creating a Worksheet................................. 23
Three ways to start a worksheet..................... 23
Starting with a new worksheet .......................... 23
Starting with a template .................................... 24
Starting with an existing worksheet .................. 25
Entering data .................................................. 26
Entering numbers.............................................. 27
Entering labels .................................................. 28
Selecting cells ................................................... 29
Entering formulas ........................................... 30
Guidelines for entering formulas ....................... 32
Contents
General.......................................................... 1
Disclaimer and warnings..................................... 1
Trademarks and copyrights ................................. 1
About this manual ............................................... 1
Important things to do ......................................... 2
Manual conventions ............................................ 2
Spreadsheet
Quick Start .................................................... 5
Starting PenCell................................................ 5
Creating a worksheet........................................6
Saving a worksheet .......................................... 6
Entering data in worksheet cells....................... 7
Entering formulas ............................................. 8
Using built-in functions .....................................9
Creating a worksheet from a template............ 10
Editing data in a cell ....................................... 10
Selecting cells and ranges.............................. 11
Moving and copying data................................ 12
Navigating the worksheet ............................... 13