ENGLISH Copyright Copyright @ 1994 by Pen Ware, Inc. Al rights reserved. This manual may not be copied, in whole or in part, without Pen Ware, Inc.’s written permission, except for the personal use of the software's owner, The software described in this document is furnished under a license agreement, and may only be used under the terms of this agreement.
Pen Cell Charts Creating a Chart, Creasing & new ch Formatting Your Carl Pie charts Column char Stacked column chars 35 Line charts 26 Chart tilled. 38 Displaying grinned: 37 Displaying e legend. 37 Exchanging the X and Y axes. 3-8 Savings chart.. 34 Adding Mark-ups io a Chart. 38 Chart Mode Menus, 3.9 Craft menu...
Precautions Use trisect precautions when handling the Pen Cell IC (!integrated Circuit) card. Wrong x Wrong Do not tarry Ihe card in the back pocket slacks or grousers, This may subject the card to bending and may damage il. Do riot bend or twist the card. This may make it impossible fo inset the card into the Organizer or cause the card to malfunction, Never taus the terminals of the (arg— this may damage the card with static electricity or cause other problems.
Installing the Card Battery Before using the Per Cell IC card for the first dime, enclosed battery info the car. If you use ihe card wi stored data wolf be ghost wham ‘he card is removed from the Organizer, To instill the battery: need to Insert the gout @ battery, a/f 1. Usg your fingernail or a can 1o press the small 13b and then pull the battery hider from the card (ses Figure 1), 2. Wipe fhe new battery clean with 2 dry cloth and insert # in the waffler holder.
Installing Pen Cell The Pen Gall application is an optional IC card that you insert into a slot in an 850078000 series Organizer; similar to sliding a floppy disk into a computer. Install the Pen Cell card while.the Organizer power is off, To install Pen Cell: Ao = 8. Turret he Organizer off Close ‘!he Organizer dnd tim It aver. Set the card Sock switch to tha RELEASE position. Slide the card sect switch and remove the protection card.
Starting Pen Cell To start using Pan Cell after the IC card is inks 1. Tum or ihe Organizer by pressing . 2. South CARD in the Organizer display. The first lime you star: he Pen Cell application, you enter File mods. From row on, the display you see when you enter the Pen Cell application is the same display that hed been present when you last used the application.
Three Pen Cell Modes Pen Cell has three mods: File come, Edit made, and Chart mode. File Mode: ) T Switch to Edit mode. The selected worksheet name, date of last update, and memory occupied. Fie e mine: 5o Free memory on the card. Edit Mode: The worksheet ahem. The tool bar. The edit bar. HINT: If you have the 8900, Touch series you will node that it has a to hide the smaller screen than e Disciple tool bar. shown hate. The 8300 serifs Edit made tool bay lacks the Eurodollars £ orator znd SUN shortcuts.
Creating a Worksheet Creating a new worksheet Pen Cell Worksheets Pen Cell gives you here ways 1o cereal a worksheet: o Create a naw, Lank worksheet. « Create a naw work shes! using @ template. « (pen an existing worksheet To cereal a new worksheet ‘rom fisher File or Edit made: o Press (NEW CRAY: A new, blank worksheet appears in the display. The worksheet has the mans { NER 3 unlit you save it and give It the name of your choice {eight characters or less).
Starting with 2 template Starling with an existing worksheet Worksheet templates have useful formulas and sample data already antlered. 7o create a new worksheet using a template, you-nae to be in File mode: : 1. Touch FILES in the Edited too! tar switchover File mode. HINT: Any time you lava out:of Edit mode, Panel! gives you the opportunity 0 save your worksheet. Chaos YES or NO to move to File mods. 2. Touch TEMPLATE in the File mode o6 ' Touch to choose @ bar o seethes list of template.
Changing & worksheet name Deleting a worksheet While File mice is active, you can also rename a worksheet. To rename a worksheet: 1. Touch the work shear you'want to rename. 2. (goose CHANGE FILE NAME from the FILES menu. RENAME FILE File Name: OOE | o 3. Type & mans for the fle. The name can have from one to eight characters. 4, Touch DONE {or press [ENTER]). Tole CANCEL fa cross the window without renaming the selected file.
¢ HINT: Press to mask-eorractions while you type or prods to clear ths edify bar. 3.. When you ars finished entering, Sec! a different cell {or press (ENTER]). The data now appears in the worksheet call. HINT: Press complete date spiry and move Cali highlighting in the direction of the arrow. Entering numbers Pen Celt recognizes A variety of number formals, such as percentages, scientific notation, logical values, 1.5, currency, and more. For example, it you enter 7%, Pen Celt interprets this as 0.07.
Entering satchels Pen Cell Worksheets “Entering Formulas,” liter in this chapter for information about built in functions. When you are finished entering in Ihe selected cal, select another pail oy touching 1 or by touching the arrow keys in the 10 Key {or press [DESERTER: 4, Te close the 10 Key, ouch CLOSE. 1t you add text 1o a General cell, Pence! assumes that the tex is a label and autocratically adds quotes around il. The quells only appear in the edit bar after you enter the label.
2-12 1. Spectacles 2. Touch FUN ia the ool bar (or choose USE A FUNCTION from the COMMAND men). UE A chm i ]. Scroll arrows Se roll bar 33 IHTRNZC v Tues wog Tue) 3. Scroll through-he fist by logging the up and dawn arrow. Touching-thug scroll-bar below the arrows jumps to a corresponding position in tha fist, © 4. Touch & function o select it South INSERT, or press 16.add the selected function and its argument place’ Molder to the formula in the edit bar. Touch CANCEL 1o quit without inserting a function.
How formulas work with the data in your worksheet Pen Cell Worksheets in edi bar are replaced wham you lye or when you touch a cell or range in the worksheet. HINT: Pres o 1o nave the highlighting o the next argument place Folder in the formula. In effect, serves as & tah key, per milling you to move (rough a formula entering arguments. 7. To signal hal you are finished anteing the formula, select a new ell {or press (ENTER]).
216 Appendix A, *Pen Cell Function Reference;” This.section gives you some general information about using Pen Cell functions, Types of functions and superstars Pence, suppers six types of functions and operators: Arithmetic Perform arithmetic operations. These includes: 1, %, ABS, INT, ROUND, SORT, EXP, LN, LOG, MOD, RAND. Dateline Com puts values sated on dates and times. These frictions use-the Organizer's clock, so the clock must be st properly for date and time values to ba accurate.
© #ERR appears in a cell when a numeric error poseurs. The following coalitions cause an error when formulas &re calculated: © A zero as denominator in the formula, i®: AN incorrect parameter rang T a function.
Guidelines for editing data or formulas Pen Call Worksheets 2. Touch within the deli bar {or press [EDIT)) 1o obtain the blinking edit cursor that indicates you are ready 10 deli, Iow you can use any of ths auditing techniques described below in “Guidelines for editing.” 1 you start 1o type immediately, before you obtain the blinking cursor, the original cal contents disappear from the deli bar and are replaced by what you lye. HINT: Touch UNDO 1o premium ihe worksheet! to its content prior o editing. 3.
Perceive Worksheets the irradiation you wan! 1o go, old the pen past the egg of the worksheet, and ths hit will scroll in the direction you drag. 4. Lift she pen when the outlined cell or range is al the desired location. Note: Tra copied or moved dale overwrites anything they previously coupled that location. Copying and moving with menu commands To copy of move using menu commands: 1. Select! the cell or tangs whose contents you want to copy of move. 2.
Clearing data Rotting The formula; which is now automatically changes i totterer moved to range Adobe, and the data in D1 which was not moved. Copying intimidating a worksheet . , Ta copy the current worksheet as an mag that you can pasta in the Organizer Straight application; . 1. Chooses COPY. IMAGE from ing EDIT sibling of the COMMAND menu. j 126's SCRAPBOOK application. 4.
3.7 Chooses the desired subhuman option: DELETE SHIFT UP . The selected clef o tangs disappears and everything in its column fishwives up by one cell. DELETE SHIFT LEFT The selected cell disappear plethora cell.: 7+ ! HNT: #REF bagpipers in 4 call containing formulaic i you delete a ell that s referred to in the.formula ot if yau delete an entire tangs that is referred to in the formula. 1f you delete part of & range that appears in a formula, the formula is updated appropriately.
HINT: 1 sore calls in the range are outside Ihe display, drag the pen in 11 appropriate direction past the edge of the Pen Cell worksheet. The display will scroll in {he direction you are dragging. Selecting 2 row or column To select & column of row. = Touch Ihe column or row hearing. ~Currency 1% Cur; The selected row and row heading are highlighted. To select multiple adjacent: columns or rows: « Drag tough column or row headings.
Moving Around the Worksheet Se rolling Dragging 2-26 The Organizer displays a portion of the Cells in a worksheet at ane time. Pen Cell gives you a variety of methods to. display other parts of the worksite. You can move around Lhe worksheet by: * Strolling. * Dragging. * Being to a specified cell reference. ® Singing specific cell contents. In Edit mode, the Pen Cell display includes up, down, left, and right scroll bars. and down F LI stroll rows. Se roll button, Ready . Se roll bars.
® Touch the pen in the worksheet and drag 1o one edge of the worksheet, The display moves as you drag along Lhe edge of ihe worksheet in any direction until it reaches ils Limits. Going to a specific To display and select & specific cell: cell 1. Chooses F IND/GO TO 10 ihs COMMAND menu. 2. Chooses GO TO from the FIND/GO TO sub menu. Type the cell references of chaise TOP o1 BOTTOM to go to iha first or last cell in the worksheet.
To display the tool bar when it Is hidden: « Touch SHOW TOOLS in the edit tar (or choose SHOW TOOL BAR Tom the WORKSHEET OPTIONS sub menu in the WORKSHEET menu). Z00M To view larger cell's in the display, you can zoom in. When you zoom in on & worksheet display, cells and cell contents appear larger and fewer cells are in the display. vev] a0 & T Randy.
Pence Worksheets The display is divided into 4 panes. Pane 1 Pane Pane 3 Pane & When you page up or down, only pans 3 ahd 4 move. When you page left and right, only pans 2 and 4 move. Rows above and columns to the left of the selected cel! are indicated by dark lines halt divide the display into panes. When you scroll up ang down, column fables appear on each page an¢ when you scroll left and right, row labels appear on each page.
FORMAT CELLS PONE | [ 2z TAMALE: Daclnals{:] =L Protection | Touch to turn clef protector 5 [~ ‘offhand. An X in the box | indicates that selected cell T' 2 are protected. Touch ihe box Labeled P robe ct ion 5o theta the box {or press lu toggle. Protection on and off). 4. Touch DONE (0r press [ENTER)). Touch CANCEL i you change your mind about reformatting the selected veils.
Pencil Workshops TINT: § none of ihe Al enmeshment buffoons are highlighted when you open he FORMAT CELLS dialog, default alignment is in effect fn lhe selected cell. 4. Touch DONE {or press (ENTER]}. Touch CANCEL. {01 press [ANGELICA) if you change your Ming about reformatting the selected cells. Chaitanya fonts Ells can include bold, italic, underlined, cr plain characters. The default font is pain. To change Ihe font for a calf or range: 1. Selective or range. 2.
Adjusting column and row size 5. "Touch PONE (or press (DESERTER) changelings the font. Touch to-Cl's ihe SET FONT window without making a change. ‘ HINT: The rig default fort is in sf tact only for cal that wars ot already changed “rain the ‘default: : You can easily change column width or row height in a Pen Cell worksheet, : To change’ columnar height: 1. Select ane or more column or ow heading. 2. (noose SEY COLUMN/ROW $T2E trim the COMMAND menu for press [BXPTCET)).
Using the menu bar Worksheet menu Potbelly Worksheets To use the menu bar: 1. Touch MERE {or press (MEND]) to see the menu bar. 2. Touch a menu name fo display the options. 3. Touch a menu apiarist to sel Tha Edit mode menu bar includes it 3 four menus. Switches to File mode. _ Switches to Chart mode. WORKSHEET HER VIEW FILE INDEX | [VIEW CHART [SAVE CHANGES SAVE CHANGES AS HEY I HEW WORKSHEET WORKSHEET OPTIONS recalcitrant OPTIONS Forces recalculation of formulas when manual recalculation is selected.
Comment menu Tao's menu Peripherals menu 244 Selects cut, copy, paste, redo, ‘and copy image operations, Presents insert and delete options. 1 O} Finds'and selects INSERT/DELETE spic cells. FIND 7 G0 T0 USE A FUNCTION FORMAT CELLS SEAFRONT SET COLUMN/ROW SIZE Displays the builtin functions. Formats selected cells. Changes the font of selected cells. Enables changing row and column dimensions. Rearranges the selected range of cells. Displays message felting you how much memory is-available on the IC card.
Creating a Hart You can create and save one or charlatanism for your. worksheet. Creasing anew To cereal a new tartaric, you need to Start inf Edit mode chart 1. Select the range of calls containing data you want to chert, such as the example using ihe Mortgage template shown below. The cells you select in Edit mode form the basis of the char, The row above the selected range determines the horizontal axis labels. $45/12, 3 The selected range determinants the chart content.
Pie chars 34 To change the chart format: 1. 3. Chart title Grid lines sex 6 Chops CHART OPTIONS in the CHART: mar OPTION-in the poll bar) CHART. OPTIONS | DOER | [F6~ey o Trio HEEL Singles PiE | e L Legend {or touch RTI Etching I Touch PIE, LINE, COLUMN, or STACK 1o chino: 52 the heart type. Touch the box seaside TITLE, GRID, or LEGEND 1o display or hide the? elements. Touch the axis orientation you Touch DONE {or press (ENTER)). want.
Column charts Stacked column chars Gelling Charts A column chart displays all the dais for sate row a1 column in the worksheet! as 4 single column, with gec! ts pastern, allegory of data dis anguished by A stacked column chart displays all the data for each row or column in the selected range as a single column, with gate category of data distinguished by its pastern.
Line chars A ting chart shows ihe nonclinical values of senseless dad connected bya line. ' This chart has five | .. lines, one for each row in the selected range of data. Te#x 15 s a s.ex Each line in the chart has three points, ore for each column iri the selected range of data. ! Chart titles You can add a char title characters to chance your chart. To create or change & harlot file: 1. Choose CHART OPT IONS i the CHART menu {or touch OPTION it the fold bar).
Displaying grid lines Displaying the legend Pen Cell Hails Deleting the chart title To delete the char tulle: 1. Choose CHART OPTIONS inline CHART men (cr ouch OPTIONS in the tool tar). 2. Touch the ti ox beside TITLE so the X disappears. 3. South DONE (o egress (ENTER)) Grid lines can aid in the visual comparison of date. You can add grid lines 1o column, stacked control, and line charts 1. Chooses CHART OPTIONS i the CHART menu {or ouch OPTION In the log bark. CHART OPTIONS ;McCall_ 0 v (2 LEGEND i 2.
Exchanging the X and Y axes Saving a chart 3-8 Hiding the legend 1. Choose CHART OPTIONS i the CHART ey {ar touch OPTION int the fool bar) 2. Touch the box besides LEGEND.so the X disappears. 3. Touch DONE (of press (ENTER)): When you crests a char, the horizontal Ur 2% is determined by the data in e selected rows. The vertical or y axis comas from-the data in {her selected columns. You can swill the axes 5o the X xis comes from column date and v axis comas from: row data. 1.
Adding Mark-ups to a Chart The Organizer Scrapbook application includes operations that enable you to egt and print graphics like your Pencil Charts. The Ghats in the Phrasebook carol frequent to the Pence application, however. (Refer 1o the Organizer Operation Manual for details on using the Scrapbook and printing from the Scrapbook.) To mark up a chart using the Organizer Scrapbook application: 1. Choose COPY CHART from the CHART menu {or ouch COPY in tha foot bar).
Appendix B: Pen Cell Specifications and Limits Product Name: Pen Cell Spreadsheet 1C Card Memory Capacity: RAM capacity. 128KB (User area: SKIBOB) Memory Backup Power: 3y—DC Lithium battery {CR2016) Operating Time: Approximately 2 years (at constant tempera ire of 20°C parascending an the lye of battery and use conditions.) Operating Temperature: 0°C o 40°C {32°F 1o 104°F) Exterior Dimensions: simmer {w) x 85.5mm {d) x 2mm {n} 2-1/8 inch {w) x 3-3/8 inch {d) x 3/32 inch {h} Weight: Approximately 18g {0.
Secret worksheets Secret worksheet The Pen Cell card password function lets you protect individual worksheets that you identify as Secret, Secret worksheets are hidden from the Edit mode display when the application card is locked. Secret worksheets are identified by an asterisk in File mode, To use the Organizer's Secret friction in Pen Cell, you need 16 establish a password and then designate the worksheet as secret. To create a password in Pen Cell: 1. Chooses LOCK/UNLOCK 1C CARD from the TOOLS menu.
When the application card is locked, Secret worksheets are not displayed in Edit mode. In File mode, Secret worksheets are identified with an asterisk To view Secret worksheets in Edit mode: Choose LOCK/UNLOCK IC CARD from the TOOLS menu. Choose UNLOCK 1C CARD in the sub menu. 2 3. Type your password exactly as it was entered. 4. Press [ENTER).
Date and tire functions 216, A-2 Date formulas 2-1§ DATE function A-2 Date representation A-2,3 DATE VALUE function A-3 DDB function A-4 Decimal points 2-38 Decimates 2-37 Decimals, in General cells 2-8 Default settings for calls 2-36 Degree of precision 2-38 Delete SHIFT LEFT 2-24 Delete SHIFT UP 3-23 Elating cells, impact an formulas 224 Deleting characters in the edit bar 2-19 Deleting chart titles 8-7 Deleting charts 3-8 Deleting data 2-22 Depreciation A-4 Division 2-15 Dragging to a new worksheet displ
Bewitching to Edit mode fem Chart mode Symbols for formulas 2-17 Symbols, inserting anti the edit bar 219 TAN A-6 Tangent A-6 Templates, using 2-5 Parameter functions A-2 TEN KEY 2-8 Text and numeric labels 2.9 Tex tin cells 2.
| DEUTSCH Copyright Copyright © 1994 by Genware, Inc. Alle Rechte vorbehalten. Dieses Handbuch darf weder ganz noch teilweise ohne vorherige, schriftliche Genehmigung von Genware, Inc. kopiert werden, fauler fir den persönlichen Gebrauch des Eigentümers der Software. Die in diesem Dokument beschriebene Software wird unter Lizenz zur Verfügung gestellt und darf nur unter den Bedingungen dieser Vereinbarung verwendet werden.
[ FRANÇAIS | Copyright Copyright © 1984 par PenWare, Inc. Tous droits réserves. La reproduction intégrale ou partielle de ce manuel est interdite sans Autorisation écrite de PenWare, Inn, sauf pour l'usage personnel du propriétaire du logiciel. Le logiciel décrit dans ce document est souris & un accord de licence et ne peut aire utilisé gue conformément aux clauses de cet accord.
Précautions Pre rez les précautions suivantes lorsque vous manipulez Ja carte. 2 Ci (circuit intégré) Pence. A éviter X Ne mettez pas la carte dans Ia poche arriéré d'un pantalon. Sous pouvez la plier &t Endommager. Évitez de plier ou de tordre 12 carte. Ceci peut rendre impossible Insertion de le carte dans I'Organisslr ou entraîner un mauvais fonctionnement. Me touchez jamais fes contacts métalliques de la carte.
Installation de la pile de la carte Avant d’installer paru la première fols 1a carte, vous devez insérer la pile incluse. i vous utilisez la racle sans pils, toutes les donnes stockées seront perdues lorsque vous Bilerez la carte de 'Organiseur. Pau installer la pile : Utilisez un ongle ou Lne pince de monnaie pour appuyer sur la pelota languette, pus lirez le support e pile de Iz carte (voir 1. Figure 1). Essuyez la nouvelle pile avec un chiffon sec et insérez-la dans son support.
Modification du 4. Effleurez DONNE {ou appuyez sur [ENTARTRER. Effleurer CANCEL pour fermer fa fendre sans:duplication. En mode Fichier, vous pouvez étalement renommer une feuille de calcul. nom d'une faille Pour g faire ; de alleu 1. Effleurez la faille de calcul & renommer. 2. Choisissez CHANGE FILE AMEN radis le menu FILES. RENTAME FILE File Nate: W | [05 CANCEL 3. Tapez un fom (frusqua huit caractères) pour s fichier. 4. Effisurez DONNE {ou appuyez sur (ENTRER) ).
La référence de la cellule sélectionnée apparat ici. La cellule sélectionnée est en surbrillance. 12 cellule s met en surbrillance et la référence apparat dans l’indicateur de descelles. Pour plus désinformations sur les références des cellules, consumiez fa section « Rétrécir des formules » dans la suite de ce chapitre et pour des informations sur la sélection, consulat la section « Information sur les cellules de références » dans la suite de ce chapitre. 2. Tapez les donnes tue la cellule doit contenir.
Encirée des nombres 2-8 La barre d'édition affiche ce que vous tapez. Ew] BL Insu rance CONSEIL : Appuyez sur pour effectuer des corrections tout en tapant ou sur pour effacer la barre d'édition. 3. Uns fois les donnes encirées, sélectionnez ime autre cellule {ou appuyez sur [ENTRER]). Les données apparaissent maintenant dans une effluence de-A feuille de calcul.
Entrée des étiquettes Effisurez ici pour fermer ie Effleurez ici pour effacer les clavier & 10 touches. ardeurs d'entrée avec la touche aller-retour. Effleurez ici pour déplacer le clavier & 10 touches dans I'affichage en le faisant glisser. Effleurez ici pour déplacer la sélection de cellule vers la première cellule de la rangée J_ suivante. Affleurez les & £ fléchés pour 1
2-12 « Une formule peut avenir des blancs enfer un nom de fonction ef ses marqueteries. Toutes lgs entrées suivantes tans corrects et ont la mémos signification : SuM (A4AB), sum {a4: 28 ). ¢ Lors du calcul d'une formule, Essoreur de calcul peut &re, dans certains cas, importante. Utilisez alors ROUND (values nimber of desdits pour révision Les formules peuvent contenir: * des nombres (par exemple, 250, -90, 21%, des dates et des temps chiffrés.
vous copiez ou déplacez une référence de cellule absolue d'un emplacement un autre, Ia cellule indiquée par la référence ne change pas. S vous copiez la formule $C55 cellule AT vers fa cellule K9, la formule dans KO est identique (c’est-à-dire, Références relatives de cellules Une référence relative de cellule caractérise une cellule par rapport & son emplacement relatif 4 la celui qui content lz référence.
Sélection au clavier le stylo épias avoir dépassé’le bord dé Ia feuille de calcul. Cite dernière se dérégule alors dans la direction du glissement. Sélection d'une rangée ou d'une caponne Pour sélectionner une colonne ou ung rangée : . Affleurez En-tête de la.colonne ou de I range: concurrence 1° T La rangée sélectionnée et sa rubrique s'affichent en surbrillance. Pour sélectionner des colonnes ou des rangée adjacentes : * Glissez la gong des des colonnes et des rangées.
Pour effectuer un oo avant cu arriéré : o Effleurir ZOO dans Iz col droit inférieur {ou choisissez ZOOM dans g sous-ment YORKSHIRE OPTIONS gu menu yorkshire. Titre Utilisez SET TILTE pour créer des litres de tableau gui ne défilent pas. Ceci vous persel de parcourir les nombreuses pages de donnes avez colonne ob e Ya rangée qui reste immobile ef visible.
défilez vers la gauche ou la droite, les étiquettes des ranges apparaissent sur chaque page. CONSEIL : Si vous sélectionnez une cellule dans 1 colonne A ou la rangée 1 avant de choisir SET TILTE ON, l'affichage n'est divisé que deux panatela et le défilement e affectueuse que dans une seule direction, Pour désactiver SET TILTE o Choisissez SET TILTE ON dans le sous-menu YORKSHIRE OPTIONS dumenuORKSHEET.
Le nombre de barres est Effecteur ici pour donné par le nombre de revenir en mode rangées de l’intervalle Édition. sectionnelle. ) Les étiquettes de l'axe horizontal (X) sont déterminées |___parlarangée située au-dessus de l’intervalle sélectionné. La légende du diagramme vient de la colonne située a gauche ds l’intervalle sélectionné. CONSEIL ; L'affichage de 'Organiseur série 10-8900 ne dispose pas de la barre d’outils dis mode Diagramme. Dans & cas, utilisez le menu CHAR .