background image

Summary of Contents for GeoBook NB-60

Page 1: ...NB 80C 2 Word Processing Spreadsheet Drawing Scrapbook Addressbook Planner Book Reader Text File Editor Games Glossary _GEOS US ENGLISH ...

Page 2: ...ich is supplied on diskette Addressbook Stores names and addresses and other information for reference including email addresses Planner Schedules appointments on a perpetual calendar Book Reader Opens books on screen Text File Editor Creates and edits DOS text files This program is on diskette i Games Solitaire and Turnabout are on diskette This manual assumes you are familiar with the basics of ...

Page 3: ...724 523 Reproduction or disassembly of embodied programs or database prohibited Based upon Roget slI TbeNew Thesaurus 1980 by Houghton Mifflin Company International CorrectSpell _ English spelling correction system 1994 by Inso Corporation All rights reserved Reproduction or disassembly of embodied_gorithms or database prohibited Portions of BIOS software provided by Phoenix 1997 by Phoenix All ri...

Page 4: ...telephone network the telephone company will notify you in advance that temporary discontinuance of service may be required If advance notice is not practical the telephone company will notify you as soon as possible Also you will be advised of your right to file a complaint with the FCC if you believe it is necessary The telephone company may make changes in its facilities equipment operations or...

Page 5: ...Text 10 Dragging and Dropping Text 11 Usihg U_do_to Reverse Your Last Acfi_ _ _ 12 Using Special Characters and S_nbols 12 Changing Text Font Size Style and Alignment 12 Using Tone in Text 15 Finding and Replacing Text 17 Formatting Documents 19 Setting Line Spacing 20 Using Indentations Tabs and Rulers 21 Adding Borders 25 Setting Hyphenation 26 Using Headers and Footers 27 Creating a Title Page ...

Page 6: ... 58 Displaying Counts 58 Using Abbreviated Phrases 59 Inserting Special Characters 60 Importing and Exporting Documents 64 2 Spreadsheet _ 65 Starting Spreadsheet _ 65 Opening a Document 66 Using the Tool Bars 67 The Basic Functions Tool Bar 67 The Advanced Functions Tool Bar 68 Graphic Bar Drawing Tools and Bitmap Tools 68 Moving around in a Spreadsheet 69 Selecting Cells and Ranges 69 Working wi...

Page 7: ...ormulas 98 Naming Cells and Ranges 98 Controlling Automatic Recalculation 100 Using Iteration and Circular References 101 Charting in Spreadsheet 102 What Is a Chart 102 Types of Charts 103 Creating Charts _ 108 Changing the Type Of Chart _ 108 Manipulating Charts 109 Resizing and Moving a Chart 109 Changing Chart Properties and Attributes 110 Deleting a Chart 110 Using a Chart in Another Program ...

Page 8: ...tating Objects 142 Skewing Objects 143 Untransforming Objects 143 Duplicating Objects 143 tirtg t_ phi _ _ _ Conver a Gra c 145 Arranging Objects _ 146 Moving Objects to the Front or Back 146 Moving Objects 146 Grouping and Ungrouping Objects 148 Pasting Inside 149 Using Rulers 150 Using Grids 151 Using Text in Drawings 152 Changing Text Style Size 154 Aligning Text 155 Adding Tone to Text 155 Wor...

Page 9: ...Flipping through Cards 176 Editing Cards 177 Copying Cards 177 Deleti rds __ _ _ 178 Adding Notes to Cards _ 178 Searching through Cards 179 Making New Addressbooks 180 Printing and Faxing an Addressbook 180 Importing a Document 182 Exporting an Addressbook Document 183 6 Planner 185 Starting Planner 185 Viewing the Calendar 18 6 Selecting and Viewing Events 187 Switching between the Calendar Wind...

Page 10: ...g from Book Reader 204 8 Text File Editor 205 Starting Text File Editor 205 What Text File Editor Can and Cannot Do 206 Word Wrap and Line Endings 206 Changing the Text Size 206 Printing a DOS Text File 207 Naming a DQ__ Text File _ _ _ 208 9 Games 209 Turnabout 209 Capturing Pieces 209 Sequence of Play 209 Setting User Options 210 Solitaire 210 Starting Solitaire 211 Playing the Game 211 Finishin...

Page 11: ...215 Fina_idal Functions 216 Information Functions 217 Logical Functions 220 Mathematical Functions 222 Print Functions 223 Statistical Functions 223 String Functions 224 Time and Date Functions 226 Trigonometric Functions 227 Glossary 229 Index 237 Contents vii ...

Page 12: ...Contentsviii ...

Page 13: ...ther than the SPACEBAR to align text If you use TAB to set the spacing between text then you can Simply change the measurement of the tab space to change the location of a column Type only one space after a period or colon When using a typewriter _you enter two spaces after a period or colon because of the spacing o _e typ_ewdtet characters _ Use italic style text rather than underline for book ti...

Page 14: ...cument appears Opening a Document_ Templates allow you to create standard documents such as envelopes quicldy See Using Templates in Getting Started Book 1 To open an existing document or template 1 Insert the diskette that contains the document or template into the disk drive 2 3 Select New Open from the File menu The New Open dialog box appears Double click on the name of the folder and file you...

Page 15: ...e 2 Click on the tool button The characteristics change The Basic Functions Tool Bar To remove tool bars click again on the name of the tool bar in the Show Tools submenu of the Options menu The Basic Functions tool bar appears when you open Word Processing Use it for functions like copying or changing the font size of selected text Open Close Textstyles plain bold italic andundedined Save I Print...

Page 16: ...se the Graphic bar for editing graphic objects created in or imported to Word Processing For example use the Duplicate button to make a copy of a graphic object or use the Area Fill tool to fill a graphic object AreaPattern LineShading LineStyle PasteInside AreaFill ILine Tone I TextShading AreaShadin_ _ I 1 _ l _Te x _Tone Ungroup I I L e T _ I I Gr_upI BreakOutPasteInside Bringto Front Sendto Ba...

Page 17: ...aphics or to edit bitmap graphics imported into Word Processing The Drawing tools Bitmaps and the Bitmap tool bar are explained in detail in the Drawing chapter which starts on page 125 Saving On screen Settings Configuration Saving the configuration allows you to save the settings from the Options menu For example if you want the Advanced Functions tool bar to be visible every time you open Word ...

Page 18: ... outline will be represented by a rectangle with dotted borders 2 3 set up the page Select the document for which you want to change the page setup Place the insertion point anywhere in that document Select Page Setup from the File menu A dialog box appears Fill in the dialog box making the selections you want Starting Page Numlmr You can start your document on a page other than 1 If you_have seve...

Page 19: ...recommended because you will not lose any text as you type If you want typed characters to replace the characters to the right of the insertion point turn the Insert mode off Word wrap means that you do not have to press ENTER the Return key on a typewriter to start a new line of text As you type the words appear in the text area As words reach the end of a line they automatically continue on the ...

Page 20: ...oint To start a new paragraph Press ENTER The insertion point moves to the lej_ margin of the next line To place the insertion point M the text Position the insertion point in the text and press the Select button You can type in the text _ To select text 1 Move _inserti_ p 6in _o the beginning of the word line or paragraph you want to select 2 Hold the Select button and drag across the text until ...

Page 21: ...nt SHIFT END From the insertion point to the end of the line extends or reduces the selection a line at a time toward the end of the document CTRL SHIFT To the beginning or ending of a paragraph in the direction of the arrow extends or reduces the selection in the same t or _ direction CTRL SHIFT From the insertion point to the beginning of the document HOME CTRL SHIFT _ From the insertion point t...

Page 22: ...g and Replacing Text When you select text you can cut it and move it elsewhere or copy it to another place The selection you cut or Copy is placed on the clipboard an electi ofii_liOlding s_a_ce_ WSen you press PASTE the contents of the clipboard are pasted into the document at the insertion point When you move a selection you remove or cut it from its oaginal location and paste it into another lo...

Page 23: ... text is placed in the clipboard 3 Select the block of text you want to replace and press PASTE The selection is replaced by the contents of the clipboard Dragging and Dropping Text Move _ CopJ __ Youcan onlymove text to text areas whichhave already been typed in To create a larger text area press ENTER The drag and drop feature provides a quick way to move or copy text without using the clipboard...

Page 24: ...ers seethe Appendix _ Once you open the Keyboard it will stay open until you close it 1 Click on the SYM button in the lower fight hand comer of the screen The Symbols On screen Keyboard appears for tbe font you are using 2 Click on the Symbols menu to see other choices for the font you are using _ _ 3 Click on the symbol or character that you want to appear in your document The symbol or characte...

Page 25: ...r s width For example the letter i uses less space than w l_ To change the font To see a sample of the font select Fonts from the Charactermenu then select Font Viewer Youcan also select fontsfrom the Fonts submenuin the Character menu 1 Select the text to change 2 Click on theFon_ iC_YrYon _e Basic Functions tool bar A drop douPa menu of fonts appears 3 Select the font The selected text appears i...

Page 26: ... appears in the next smaller or next larger size To set a custom text size 1 Select the text to change 2 Select Sizes from the Character menu A submenu appears 3 Select Custom Size from the submenu A dialog box appears 4 Select the custom point size you want between 4 and 792 5 Click on Apply 6 Click on Close Changing text styles Use text styles to add emphasis to words and phrases in your documen...

Page 27: ... _ _ Center CTRL R Right CTRL J Justified Using Tone in Text You can set the text tone before you begin O ping if you want or select it and change it later Text tone should stand out against its background for ease of reading If the tones are too close the text disappears into the background By default text tone is black and background tone is white You can also increase or decrease the percentage...

Page 28: ...x appears 3 Fill in the dialog box Frilled or Unfilled Select Filled to set other options in this dialog box By default the background is unfilled Shaded Select the percent shading for the text background tone The lower the number the more faded the tone A setting of zero 0 causes the background to disappear By default this setting is 100 Tone Tools Select the text background tone or shade of gray...

Page 29: ...arch here or click on Find Next or Find Previous to resume the search for another match For forward searches if Word Processing reaches the end of the document it starts searching from the beginning For backward searches if Word Processing reaches the beginning of the document it starts searching from the end If Word Processing cannot find the search text in the document a message appears Click on...

Page 30: ...h use the Multiple Characters wildcard in your search text math You can also search and replace special eAMme_ in your document graphics special text tabs carriage returns and page breaks _ To use wildcards and special characters 1 Press CTRL F The Find and Replace dialog box appears 2 Click on Special Characters A drop down list appears _Find It I_pla o _ _ rm _ciuJ Characters m FI gnore Case P c...

Page 31: ...ent marks For example if the search string is Dog Word Processing could find matches for Dog and dog Match Partial Words Instructs Word Processing to search for a portion of a word For example if the search string is print Word Processing could find matches on print sprinter reprint and so on Click on Find Next or Fred Previous to search the document for the search text and click on Replace or Rep...

Page 32: ...ch row of text Triple Two whole lines are between each row of text Custom Set custom line spacing up to 12 specify line spaciog Select the text or move the insertion point into the paragraph you want to change 2 Select Line Spacing from the Paragraph menu A submenu appears 3 Select one of the line spacing options from the submenu To specify custom line spacing 1 Select Line Spacing from the Paragr...

Page 33: ...the paragraph the hanging indent If both of the Left Indent triangles are together all lines in the paragraph align beneath the markers If the top triangle is to the right of the bottom triangle the first line indents as shown in the illustration at left To set indentations by dragging 1 Select all of the paragraphs you want to indent If you want to indent only a single paragraph move the insertio...

Page 34: ...nes between tabbed items B To create tabs on he ruleR _ 1 Select the paragraphs for which you want to create tabs or if you want to add a tab to a single paragraph move the insertion point into the paragraph 2 Click on the ruler The tab marker appears wbere you clicked The automatic tabs disappear to the lej_ of the new tab 3 If the tab is not exactly where you want it on the ruler drag it to a ne...

Page 35: ...ect the tab you want to change in the Tabs list 4 Fill in the rest of the dialog box selecting the options you want 5 Click on Apply 6 Click on Close To delete a tab 1 Select Tabs from the Paragraph menu The Tabs dialog box appears _ 2 Select the_ tab you _ant to delete m the Tabs list 3 Click on Delete Tab or drag it off the ruler Word Processing deletes the tab and shifts the text to the next ta...

Page 36: ...t Tab stop Right indent i I i F p N r p F t Loft margin Text area Right margin Snap to Ruler M _ ksis explained on page 40 Follow these steps to change options on the ruler _ To align the ruler with the page 1 Select Rulers from the Options menu A drop down menu appears 2 Click on Align Ruler with Page The ruler moves to the le_ To show the horizontal and vertical rulers 1 Select Rulers from the O...

Page 37: ...border Left Top Right and Bottom Select all four sides to put a box around the text Select Draw Inner Lines to draw between lines of text o Border Width points Sets width of the border in points Border Spacing points Sets border spacing in points Border Type SLrts type of border Normal Shadow or Double Line Shadow Anchor If a shadow border is selected select the anchor for the light source that cr...

Page 38: ...ak and wraps the rest of the word to the next line Word Processing provides hyphenation settings that you can change Note that some hyphenation can make a document easier to read while too much hyphenation can make words harder to recognize and make the page look cluttered I_ To change hyphenation _ 1 Select one or more paragraphs with the hyphenation you want to change 2 Select Hy phenation_fi_m ...

Page 39: ...s bold tex 0 and multiple lines of text To set up a header or a footer 1 Select Edit Header from the Layout menu A page appears with the insertion point in the upper left corner of the header area OR Select Edit Footer frOm the Layout menu A page appears with the nsertion point in the upper left corner of the footer area Insertion pointfora header __ _t2_ at _k_ Dtk _ la_ut irtl_l_ tm t lra_ _er_ ...

Page 40: ...ocument The tide page is numbered 0 but the number will not print The title page appears v_th a page break line below the insertion point To move the insertion point down the page press F_J_TER 2 add a title page_to_a document Seiect Title Page f _t_ __Layout menu A submenu appears Select Create Tide Page from the submenu A dialog box appears asking if you want to continue Click on Yes to create t...

Page 41: ...reaks and inserts them accordingly Automatic page breaks are called softpage breaks because their location changes depending on the amount of information in a documenL You can force a page break manually by inserting a bardpage break Do this whenever you want to start a new page in a specific location ll_To insert a hard page break 1 Place the insertion point where you want the hard page break 2 P...

Page 42: ...n characteristics Thedistancebetweencolumns is 0 25 inches Theverticalruleis 2 pointswide The columnsettingis Ihres l_ To set or change the columns 1 Place the insertion point in the document 2 Select Page Setup from the File menu A dialog box appears 3 Fill in the dialog box Columns Select the number of columns Spacing If you have more than one column select the distance between columns as well a...

Page 43: ...ragraph spacing Styles allow you to apply a group of attributes to text all at once For example if you want the headings in your document to be centered and bold create a style to automatically center and bold them then apply that style to heading text Without a style you would have to manually center and bold each heading Using default styles Word Processing provides three styles Use them as is o...

Page 44: ... 2 Select Text Style Shee_ from the Paragraph menu A submenu appears 3 Select R ecall Style _m th _ submenu Word Processing applies the saved attn butes to the selected text Defining a new style You can add a new style to the style sheet by giving it a name and defining its attributes A base sty e is a style on which other styles depend these styles are variations on the base style If you change a...

Page 45: ...ions tool bar By default this option is selected Apply to Selection Only Character Style Select whether you want to apply the style attributes to selected text only or to the entire paragraph Point Size Relative Select to make the point size relative to the point size of the base style Changing the point size in the base style changes the point size in the current style by the same amount Margins ...

Page 46: ... it in _e list If you do not want a base sOde select No Base Style Hod_u St_o Sttjb l Jnlr_ _ormal _u b I_ Bar PopOawn I ist n Ri plg to selection Onbj Character StLjle Point Size Relatioo I I Hlergin Relatlue Leading I_JaUue rltlo Base SIvle Normal Bleeder Footer i ID 5 Fill in the dialog box selecting the options you want 6 Click on Modify to change the style definition The Modify Styles dialog ...

Page 47: ...graph menu A submenu appears 3 Select Revert to Base Style Word Processing applies the base style overriding the current attributes of the selected text Using style sheets from other documents You can copy style sheets from another document or template into a document you are working on That way you do not need to def me the same styles all over again To get styles from_ar other document 1 Select ...

Page 48: ...ges in Page Setup left and right the document will have two master pages one for the left and one for the right Editing the master page To change the format of an individual page in your document do not use a master page Instead reduce your document to _I_ TO edit the master page Scale to Fit in the View menu use the pointer from the Drawing tools and select and resize header footer or main body r...

Page 49: ... the width or position of these columns edit the master page To select a text region Pointertool _ i I i i I L__L__ J__i Handk show that the text region is selected Once se lected you can move or resize iL 1 Select Scale to Fit from the View menu Tbepage is scaled doum 2 Open the Drawing tool bar from the Show Tools submenu of the Options menu This tooL bai _ _pears on the left of the screen 3 Sel...

Page 50: ...rd Processing and Drawing Complete information about drawing and graphics is included in the chapter on Drawing Graphics especially You can use any _Paphic image that you can paste from the clipboard For large ones take up more example you could draw a logo in Drawing copy it to the clipboard and memory than text Ifyou use large graphics you paste it directly into your letterhead in Word Processin...

Page 51: ... Layout menu The Drawing tool bar appears on the left of the screen 2 Point to where you want to anchor the upper left comer of the graphic frame 3 Press the Select button and drag down and to the fight until the graphic frame becomes the size you wanL An outline shows the borders of the graphic frame as you drag it 4 Release the Select button The graphic frame appears with bandies along its borde...

Page 52: ...hic frame and click on the Select button Handles appear along its border to show that it is se ected OR To deselect point anywhere outside or inside the border of the graphic frame and click To change the_size o_Fa g_aphic frame 1 Select the graphic frame you want to resize 2 Point to any handle hold down the Select button and drag the handle until the graphic frame becomes the size you want 3 Rel...

Page 53: ... select the line attributes you want 4 Click on Apply then click on Close Using Grids You can position graphics using the grids snapping objects into place for you automatically The grid is a pattern of evenly spaced vertical and horizontal lines that help you a ign and size objects You can also change the spacing of the grids You can also automatically snap or position objects along grid lines wh...

Page 54: ...ct and copy more thanone graphicobject __ at a time press and hold CTRL whileselecting objects _ _ To copy and paste_graphic object _ 1 In the program you are using to draw the graphic Drawing Spreadsheet or even Word Processing select the graphic object you want to copy 2 Press COPY Youcan also select Copy and Paste from lhe Edit menu orfrom their buttonson the Basic Functionstool bar 3 Open the ...

Page 55: ...te another scrapbook See Scrapbook page 167 If you have never created your Default Scrapbook a message appears _telling you to__e_e it by clicking on New See Scrapbook pPge 167 If for some reason you have a scrapbook but it is not labeled as Default Scrapbook the program tells you that it cannot find your Default Scrapbook Click on Cancel to open a New Open Scrapbook dialog box Then select your sc...

Page 56: ...etheobjecL To set text wrapping 2 3 Select the graphic frame you want to use Select Wrap Type from the Graphics menu A submenu appears Select one of the following options Wrap Tightly This wraps text tighdy around the borders of selected graphic objects Wrap Around Rectangle This wraps text around a rectangular area that completely encloses the selected graphic objects Wrap Inside Object This wrap...

Page 57: ...u want to delete the graphics on the last page Click on Move Graphics to keep the graphics on the last page Click on Cancel Delete to create a new page that contains just the graphics from the last page OR If you want to insert a graphic layout after the current page select Append After This One and click on Yes when the message box appears _ifybuba _rap _ds on thefolloua ngpage that are not in th...

Page 58: ... the referent com_ or explanaUon Typically footnotes are numbered sequentially If you use numbers for your reference mark you must update the numbering sequence manually A footnote remains on the page on which you added iL If the text with the reference mark moves to a different page you must manually move the footnote to the new page For these reasons it is best to add footnotes starting from the...

Page 59: ...e View menu Use the pointer from the Drawing tools and select and resize header footer or main body region 4 Hold down the Select button then drag down and to the right until the text frame becomes the size you want usually along the right margin and as tall as needed for any footnote s An outline shows the borders of the text frame as you drag it 5 Release the Select button The text frame appears...

Page 60: ...he text and select a style from the Basic Functions Once you have created the styles enter the heading text press TAB enter tool bar _ _ the page number and theja_ _aapply_the style for the heading level See page 31 lel_l_ Norrr_ 1 for more information on creating and applying styles Creating a Bibliography Style sheets can also help you quickly create a bibliography for a document A typical bibli...

Page 61: ...he user dictionary Checking Your Spelling Word Processing has an electronic spelling dictionary of 114 000 words that it checks to look for mistakes When it finds a word that is not in the dictionary it displays it in the Check Spelling dialog box and lets you decide what to do with it l_ Tocheck the s oe ilng of a word or block of text Youcan also select Check Spellingfrom the Eo_tmenu or from it...

Page 62: ...f possible spellings When the suggestions appear select the spelling you want and then click on Replace If no suggestion is correct type the word correctly in the Change To box then click on Replace Add to User Dictionary Click on this button to add the word to the user dictionary stored on diskette If you do not have a user dictionary yet you will automatically create one when you add your letrst...

Page 63: ... word entered in the new word box 4 Fill in the dialog box selecting the options you want Words in User Dictionary This lists the words in the user dictionary Delete Selected Word To delete a word select it from the list then click on this button Adkl N ew W_ _ _To add a new word type it here then clickbn Add New _ord If you attempt to add a word that already exists a message appears click on OK a...

Page 64: ...the current umrd and appears in the current word box OR Type a different word in the current word box 5 To look UP a definition and synonym for the current word click on Lookup 6 To go back to a previous word click on Back and select the previous word you want It appears in tbe current word box 7 Click on Replace W_ Proce_sing replaces the text 8 Click on Close Printing or Faxing Your Document Onc...

Page 65: ... addresses stored in a consistent format For example an Addressbook document might contain the names and addresses of your friends The information in the data document gets inserted into various places merge fields in the merge document A merge document is a Word Processing document that contains text grap_ layouL a_ nd fo z 2m_atting It also contains mergefie ds that m _rk where Word Processing p...

Page 66: ...ar in the merge field including underscores Field Name Index Field Addr Field Note Field Home Office Car Fax iP hone5 Phone 6 w Phone __7 Description Name of person company or other sorted information Address information Notes box Home phone number Office phone number Car phone number Fax phone number Addition_ phone number _d_tonalphone number Additional phone number To add merge fields in a Word...

Page 67: ...ample you might want to keep friends in one Addressbook document and business associates in another That way you can merge and print a personal letter to an your friends without involving business associates Addressbookuses standardized field names The merge fieldsin your Word Processingmerge documentmust rnaP h thesefield names exam Once your Addressbook document contains the information for merg...

Page 68: ..._ __ i224 m_n Slroet lOe ktown F I_ _B _ S0e _ _ _ _i JJ k _ ic_ 45 wt _ s t 25 LP_ A o C ___K _ _3 tig _ _ _i __ JR e _ _ _illko TI iitchel 1759 Hol ow_y Street _P ine Bluff T A I_ _r2 _ iB_ _ _ _ _ii zz C_ro_l _ iSander_ 358 Tldewe terDrlve L__ _I _ S D _ 9_ 58 2_ 8_ 5 _8 1 ILl _ I 3 cap I u_ I s I t_13r_l Ulrttitllld ISW_l Entriesappearinthe rowsbelow Youcanuseanyfield Eachrowis a differententr...

Page 69: ...0 to the clipboard If you see field on a printed documen_ check to see that you selected either Merge One or Merge All Next make sure that the name of the field in the data dooument match es the name of the merge field in the merge document _ To print a merge document 1 _In y_Or Wo_Proces_g merge document press PRINT A dialog tmx appears 2 In the Print dialog box select a merge option NO Merge Sel...

Page 70: ...play invisible characters Select Show Invisibles from the Options menu Word _ng displays the invisib e characters Displaying Counts You can make changes Word Processing counts the number of characters words lines and to the text while the dialogbox is visible thenrecalculate the countsifyou want to see the impact of a change to the document paragraphs in a document Use this feature when your docum...

Page 71: ...atk_ dia og box appears 3 Type the abbreviation in the Abbreviation box example cc_ 4 Type the phrase in the Phrase box example chief executive officer 5 Click on Apply Your abbreviated phrase appears in the Abbreviated Phrase dialog box 6 To edit any abbreviated phrase or abbreviation select it and dick on Edit 7 Make your changes in the Edit Abbreviation dialog box and dick on Apply 8 To save yo...

Page 72: ...rocessing Mserts the current date in the format you selected The date is entered just asJf_ _ y_u had typed it yourself and is automatically updated 1 Place the insertion point where you want to insert the current date 2 Select Insert Special from the Edit menu A submenu appears 3 Select the date format you want from the submenu Longhand Date This option inserts the current date in a longhand form...

Page 73: ...n Selecta numberformatfromthislist 4 Select the special number from the Type list Page Number This displays the current page number in the documen tsYo u U_n set the starting page number for a document Number of Pages This displays the total number of pages in the document 5 Select the number format from the Format list Number Uppercase Letter Lowercase Letter Uppercase Roman and Lowercase Roman R...

Page 74: ...nge This date is the date that you insert the character It does not change Date Doom_ent Created This date shows when the document was created Date of Last Revision This date shows when the document was last saved Date of Printing This date shows when the document was last printed Word Processing inserts the date even if you have not yet printed the document 5 Select the date format from the Forma...

Page 75: ...insertion point where you want to insert the time 2 Select Insert Special from the Edit menu A submenu appears 3 Select Special Time from the Insert Special menu A dialog box appears 4 Select the special time from the Type list The choices include the following Now Won t Change This time shows the system time when you inserted the character It does not change if the system time changes qFtme Docum...

Page 76: ... No Idea and Word Processing _1 analyze the document to see if 5 To import a document from another word processing program 1 Insert the diskette containing the document you want to open 2 Select New Open from the File menu The New Open dialog box appears 3 In the New Open dialog box click on Import The Import Document dialog_box appear_ i__ _ _ Select the program it was created in from the fight a...

Page 77: ...ages refer to New _ dialog bo_ Select New An empty Spreadsheet document appexzrs page 124in thischapter Editbar Columnheaders Shows theinformation Clickontheseheaders to Activecell Thehighlighted celltoenterinformation intheactivecell Inthisexample thecelladdress isA1 Thisaddress selectjanentirecolumn appearsintheEdit bar _ _ Cells _ _ Eachcell canhold a sepa ratepieceofinformation suchastext numb...

Page 78: ... box see All About Documents in Getting Started Book 1 Spreadsheet templates are available See Using Templates in Getting Started Book 1 _ I_ To open a new spreadsheet document Click on Spreadsheet from the Main Menu Spreadsheet opensan erupt 2 Spreadsheet document I_ To open an existing document or template 1 Select New Open from the File menu The New Open dialog box appears 2 Select the drive if...

Page 79: ...e current row If you have selected multiple rows Insert Row adds the same number of rows above the selection Delete Row Deletes the current row If you have selected multiple rows Delete Row deletes the rows containing the selected cells Insert Adds one column left of the current column If you have selected multiple columns Insert same number columns to the of Column Column adds the of left the sel...

Page 80: ... chart is a plot of values connected by straight lines An area chart is a line chart in which the area below the line is filled with a pattern Point IA point chart is a plot of points Pie A pie chart is a circular chart where each slice represents a part of the whole chart showing stock market data high low and close High Low A high low chart is useful for tracking pairs of data that mark a high a...

Page 81: ...ick on a cell or otheritem place the on screen pointer in a cell then click on the Select buttonor tap once on the glidepad Selec_button left buttonona mouse Drag button right button onamouso To enter information in a cell or make changes to it first select it to make it the active cell The active cell appears highlighted with a heavy black border around it as shown in the illustration below When ...

Page 82: ...ou want to select and then press ENTER OR Select Go to Cell from the View menu type the address of the cell you want to select and then click on Go To To select a range of cells Drag from the first cell to the last cell of the range you want to select OR If you attempt to enter the locked area via the View Go_ 1_ Cell menu item the following message appears The selected cell is located in the lock...

Page 83: ...the fn st Idled cell to the left or if no more filled cells to the left the first unfilled cell in the row CTRL 1 Selects the last filled cell above the active cell in the current column or the first filled cell to the right or if there are no more f dled cells above the active cell the first unfilled cell in the column CTRL _ Selects the last filled cell below the active cell in the current colum...

Page 84: ...Labels If you have selected a range of cells press ENTER to move down columns and press TAB to move across rOWS I_ To enter values or labels 1 Select the cell in which you want the entry to appear 2 Type the entry numbers or words in the cell If you are using the numeric keypad to enter numbers besure the NUM LOCK key is on To turn it one click on_theNUM button in the lower left comer of the scree...

Page 85: ...The Lat _Ml_mae Ldk Jlontt If a cell is not wide enough for a numeric value you enter or for the result of a formula the symbol appears in the cell as shown in the illustration to the left The value is stored in the cell but you cannot see it unless you make the column wider See Changing the Appearance of a Spreadsheet on page 82 You can enter values between lOqS z and 10_s 2 All numbers and calcu...

Page 86: ... rounded to a whole number Currency Currency with Commas Currency Integer rounded to nearest dollar iPercentage times 100 Percentage Integer times 100 irounded to whole percent Thousan ds divided by 1000 and _ irounded Millions divided by one million iand rounded Scientific You Type 1234567 123 4567 1234 567 1234 567 1234 567 1234 56 1234 567 085 4275 1234567 Spreadsheet Displays 1234567 123 46 1 ...

Page 87: ...mat appears in the dialog box 4 Click on Apply Spreadsheet changes the format of the selected cell s 5 Click on Close The dialog box disappears Entering and Changing Datesand Times _ There are two ways to enter dates and times in your spreadsheet as labels or as formulas Q OR To enter a date or time as a label Type the date exactly as you want it to appear For example you could type any of the fol...

Page 88: ...ER Spreadsheet returns 0 523877 the serial number format of 12 34 and 23 seconds You can change the format of the cell to show the time in normal format 12 34 23 Unless you want the date or time to appear inyour spreadsheet as a serial number change the date or time format The next section explains how to do this To enter a date or time as a formula 1 Select the cell in which you want to enter a d...

Page 89: ...h 21st 1964 23456 Mar 21st 1964 23456 3 21 64 23456 03 21 64 23456 Saturday March 21st 23456 March 21st 23456 3 21 23456 March 1964 Date Short Month Year Date Year _ Date Month Date Day Date Weekday Time Hour MiD Sec Time Hour MiD Time Hour Time MiD Sec 23456 3 64 23456 1964 23456 March 23456 21st 23456 Saturday 1234 567 2 36 29PM 1234 567 2 36PM 1234 567 2 PM 1234 567 36 29 _ To change the format...

Page 90: ...p int gdd lines _ To show or hide grid lines whether they are visible on screen or not Use Page Setup hum the File menu to_ specify pdnUng gdd lines 1 Select Other Settings from the Options menu 2 Select Draw Grid Lines to show the grid lines OR Deselect Draw Grid Lines to hide the grid lines Showing Cell Borders To create an interesting visual display of your numeric information you can display c...

Page 91: ...or printed Page number Name of the document Your name or the name of your department business or school Graphics such as a logo or drawing Header text size cannot exceed 24 points To create a header or footer 1 Enter the header or footer text in a cell or range of cells that is not part of the main information See the sidenote on the left 2 Select the cell or range 3 Select Header Footer from the ...

Page 92: ... Select the cells for whida____r__ou want to change the background tone tone to white and the 2 Select Text Background Tone from the Properties menu A dialog box text tone to black the cell enMes will appear as black text on a white background appears Fill in the dialog box Filled or Unfilled Select Filled to set other options in this dialog box By default the text background tone is unfilled Shad...

Page 93: ...ote Indicator appears see example on the left The note does not appear in the document instead it appears in a special box that you can print with the spreadsheet if you want l_ To attach a note 1 Select the cell to which you want to attach a note 2 Select Notes from the Cell menu The Notes dialog box appears 3 Type_the note_inlth_x ljalog box 4 Click on AplSly A Note Indicator a small square appe...

Page 94: ...s the column letters it changes to a double arrow as sboum in the illustration at lej_ 2 Press and hold the Select button and drag the column divider on the right side of the column until the column is the width you want OR With the Select button double click on the column divider on the right side of the column to set the column width just wider than the longest entry in the column This is the sa...

Page 95: ...ither click the row header or select a cell in the row 2 Select Row Height from the Cell menu A dialog box appears 3 Click on the Automatic check box to turn it off and click inside the Height value selector 4 Enter the number of points you want to use for the row height 5 Click on Apply The dialog box remains on the screen until you close it so that you can keep adjusting the height 6 Click on Cl...

Page 96: ...arance of a spreadsheet You can change the text style for any cell or range of cells in your spreadsheet whether they contain labels values or formulas I_ To change the style of text 1 Select the cell or range of cells you want to change 2 Select Styles from the Properties menu Plain the text style without bold italic or underline Bold Italic Underline Sur_pt e g a2 b2 c2 Subscapt e g H20 _To chan...

Page 97: ... 0 25 Built in functions or prewritten formulas built into Spreadsheet DATE SUM and AVG are built in formulas This section explains how to combine these elements in a formula that performs a calculation Entering Formulas A I c Din e_ I 25 00 rOTAL 4_oJ _ l Begin a formula by typing an equal sign Next use references values operators and built in functions to describe the calculation you want to per...

Page 98: ...u create relative references and absolute references Your choice depends on how you want Spreadsheet to treat the references when you copy or move the formula from one cell to another Relative references A relative reference tells Spreadsheet how to find a particular cell starting from the cell containing the formula such as go two rows up and one column to the right It is like telling someone how...

Page 99: ...he reference to cell B3 must not change Otherwise each calculation would be based on a different interest rate To ensure that all copies of the formula use the value in cell B3 you enter the absolute reference 1153 For more information on the financial function see Using Built in Functions in Formulas on page 88 Also see the Appendix for a listing of the financial functions REFERENCE TYPE B3 Relat...

Page 100: ...ou use more than one operator with the same priority like and Spreadsheet performs those calculations from left to right Change the order of calculations by enclosing within parentheses those expressions you want calculated first Spreadsheet evaluates expressions enclosed in parentheses first and then uses those results to calculate the rest of the formula The rab le at the left shows some example...

Page 101: ...ert the AVG function with placeholders the following appears in the Edit Area AVG value 1 value 2 To use the AVG function to average the values for example in cells A1 A2 A3 A4 and AS replace the placeholders with addresses of cells that contain the values as in the example below _ _ _ _ _ AVG A1 A2 A3 A4 A5 or AVG AI _ 5 You may also enter the numbers themselves instead of the cell addresses For ...

Page 102: ...he argument Make sure you type it correctly Your entry replaces the p acebo der argument 9 Continue replacing arguments as needed 10 Press ENTER 11 When the calculation is complete the result appears in the spreadsheet If the calculated re sult is not what you expect be sure that you typed the formula correctly 12 Click on Close I_ To insert a function by typing 1 Select the cell where you want th...

Page 103: ... of the function types More detailed information is in the Appendix beginning on page 215 Financial functions Financial functions provide formulas for common financial calculations For example the FV Future Value function calculates the future value of a stream of regularly invested payments The arguments for financial functions are either values or addresses of cells that contain values When the ...

Page 104: ...tistical calculations For example MAX returns the largest value in a list The arguments for statistical functions consist of either values or addresses of cells that contain values String functions A string _s a series of characters Stnng funcuons extract text including _ numbers or retutrh values based on the text At least one argument in each string function is a text string Time and date functi...

Page 105: ... reflect new information If it is a simple change select the cell to make it active and then type the new entry If you want to make a change in a complex entry you may want to work in the Edit Bar To begin eoVting _e selected cell press CTRL SPACEBAR _ To edit the contents of a cell 1 Select the cell you want to change 2 In the Edit Area select the information you want to change or click where you...

Page 106: ...Paste also appear in the Edit menu As you work with Spreadsheet you may find k convenient to copy and move information There are two ways to do so Use the Fill choices on the Cell menu to copy the contents of the active cell across a row or down a column Use the CUT COPY and PASTE keys to copy or move information to any other location in a spreadsheet When you copy or move values and labels from o...

Page 107: ...ions Using Cut Copy and Paste Copied formulas I You Can copyor mov e a_ginglecell or a range of cells to any other 16_ation in a spreadsheet Cut Copy and Paste work the same way in Spreadsheet as they do in other programs Cut and Copy places the selected cells on the clipboard paste retrieves any previously cut or copied information from the clipboard Youcan also click on the Cut Copy and Paste bu...

Page 108: ...nformation 4 Release the Drag button 1 be information is moved or copied depending on whether you dragged within the same document or from one document to another Inserting and Deleting Rows and Columns After you have created a spreadsheet you may need to add a row or column to make room for additional information When information becomes obsolete you will want to delete a row or column Insert Row...

Page 109: ... the date as a label Spreadsheet creates additionalda_s asJabels Ifyou entered thedate as a serialnumber Spreadsheet creates additionaldates as serialnumbers however thecell must have a date format To filldate informationas text suchas Sunday orJanuary fillin 5 the first value as text but do 6 not abbreviate the month For numbers such as a year value to fill ina progressiveseries of years enter th...

Page 110: ...f I_ To show or hide all formulas l Select Other Settings from the Options menu A submenu appears 2 Select Show Formulas to show all formulas OR _ De select Show Formulas to hide all formulas Naming Cells and Ranges When you create a formula you must include references to the cell or cells that contain the numbers to calculate You can refer to cells by their addresses or you can name them and then...

Page 111: ... An absolute reference tells Spreadsheet the specific addres_o Ta cell A relative reference tells Spreadsheet how to find a pa_ cular cell starting from the cell cont_ ning the formula For more informa_on see page 86 3 Fill in the dialog box specifying the name and reference you want to use Name Enter the name example Cost Definition Enter the cell address or the addresses for the range of cells U...

Page 112: ...pears 2 Select the name you want to change 3 Click on Change A dialog box appears 4 Type the new name in the Name box 5 Click on OK All formulas referring to the old name are updated to the new name 6 Click on Close _ To change the definition of a name 1 Select Define Name from the Formula menu A dialog box lists existing names 2 Select the name for which you want to change the definition 3 Click ...

Page 113: ... more than once each successive calculation results in a smaller value Thisis called let at on Iteration is the process of recalc_l_iting a_cifculffr _ference repeatedly until the values converge which means that the difference in the result of each successive calculation is no longer significant Before using circular references turn on iteration using Calculation from the Options menu If you ente...

Page 114: ...reate a chart to show the value of the consumer price index over a period of years the total revenue for a company broken down by region or the average student test grade through the school year Charts show the relationships between a sem es of va u_s broken down into categories For example in a chart of monthly expenses the series would include January February March and so forth the categories w...

Page 115: ...readsheet charts Each category you want to chart should have at least one value for each series Empty cells in your spreadsheet will be interpreted as zeros in your chart Types of Charts Spreadsheet lets you create the following types of charts Column Bar Line X Y Plot Pie High low Column chart A co tram obart or a vertical bar chart plots each category in a series as a vertical bar The height of ...

Page 116: ...me variations are available for bar charts and column charts Line chart A ine dbart plots a point indicator for each value on one axis in relation to the text label on the other axis and connects the points in each series with straight lines This type of chart ks useful for showing how a value changes over time The illustrations below show a typical line chart The chart on the left shows the resul...

Page 117: ...sult when the data is entered horizontally The one on the right shows the resuk when the data is entered vertically 00 _ _ _ __ 49E 54i 51i 57i a4 i ag t a7i 7 2_0 150 10D o _ _ 4gl 341 4 _ 54_ 391 51 37j 4 4 571 43i Variations on the standard area chart include the following Stacked Percentage Like the column chart s stacked percentage chart this area chart shows the areas for each category stack...

Page 118: ...nclude the following Lines Only Draws only the lines connecting the points in each series does not draw the markers for each point Markers Only Draws only the markers for each point does not connect the markers with lines This choice makes an X Y plot that looks like a traditional scatter plot Scatter plots are primarily used to see how different data is grouped Pie chart _ A pi_ chart is a round_...

Page 119: ... is plotted as a single vertical line You can also show a third or fourth relative value along with each pair such as the stock s daily closing priCe or the average temperature High low charts require two categories of data and may show up to four categories The third category places tick marks to the left the fourth category places tick marks to the righL There are no variations available for hig...

Page 120: ...lick on Advanced Functions Changing the Type of Chart By selecting Change Type from the Chart menu not only can you change a chart from one type to another but you can also choose a To select a different type of chart for a different view of your information click on the appropriate chart button from the Advanced Functions tool bar See page 68 For example once you have created a pie chart change i...

Page 121: ...agging toward the center of the chart reduces it while dragging away from the center enlarges it To move a chart 1 If the chart is not selected click on the edge of the chart to select it Handles appear around the char frame and the move handle appears in the center Resize ha _iie_ _ the handles around the edges J If you move a chart or graphic image into a ocked area the chart or image will becom...

Page 122: ...more informadion on legends see page 112 1 Select the chart by cricking on it Hand es appear around the chart 2 Select the object within the chart that you want to change by clicking on it Handles appear on that object to indicate it is selected You cannot move the component parts of the chart or any labels that the chart has generated but you can edit text labels using the Text tool 3 Choose the ...

Page 123: ...irst typing an apostrophe and then the nume ic characters Legend Select this option if your chart shows more than one category and you want to define the tones or patterns to differentiate between categories You can also select its position on the chart Horizontal below chart and Vertical at right of chart Click on Apply Spreadsheet adds tbe items you selected to your chart as shown in tbe followi...

Page 124: ...t the chart type from the Chart menu or from the Advanced Functions tool bar A_er a few seconds the chart appears 4 If the legends are not present select the chart then select Titles Legends from the Chart menu and dick on Legend 5 Click on Apply then click on Close The Legends appear on the chart TO edit legend la_ lS i_ 1 Select the cell in the left column that contains the legend label 2 Press ...

Page 125: ...marks 3 Click on Close To addgrid lines to a chart 1 With the chart selected choose Grid Lines from the Chart menu The Grid _ nes dialog box appears i iiii J Grid Lines X Axis Draw Grid Line_ at Ha jot Ticks Dram Grid Lines at Minor Ticks Y Axis Dram Grid Lines at Ivlajor Tick _ Gri J Lines at Hlinor Ticks _ _ _ Oram Select the axis from which you want the grid lines to originate and click on Appl...

Page 126: ...following _ o S6 rt t owl tfr eolu2fi ns of reformation Create custom number and date formats Add graphics to a spreadsheet Sorting Save your work before sorting Then if the results are not what you expected select Other from the File menu and click on f_scard Changes Ony data in the unlockedareas is sorted when usingthe _rt feature Data in the locked titles is not sorted You can sort information ...

Page 127: ... following Ignore Case A_ You can have the sort ignore any differences in uppercase and lowercase and ignore accents on letters in alphabetical sorts Ignore Spao_ _ You can have the sort ignore spaces between words and punctuation marks in alphabetical sorts Click on Sort Spmadsbeet _ the selected cells I_ To perform a simple sort more quickly 1 Select the range of cells you want to sort 2 Click o...

Page 128: ...places Negative numbers move the decimal point to the left and positive numbers move it to the right Options Select format options from the drop down list commas percent sign leading and trailing zeros and the position of the sign or relative t o the leader or trailer For example if the sign foll6ws _e_ iea der Tth en a negative dollar amount would be formatted like this 100 rather than 100 Fixed ...

Page 129: ...ul if you want to see where a page breaks or when you are working with graphics To specify a different ruler 1 Select Rulers from the Options menu 2 Select the type of ruler you want from the submenu The new ruler appears in place of the column and row headers Adding Gia phics Formore information on fillpattems see the chapteron Drawing which begins on page 125 In addition to charts you can includ...

Page 130: ...of vertical cells to the right of the last column to be locked To lock rows and columns at the same time select the top left cell of the area you want to remain scrollable Select Lock Titles from the View menu If only rows are to be locked a black horizontal line is drawn below the last locked row Once titles are locked select Unlock Tales to release any locked rows_ and or colurt_s _ If only colu...

Page 131: ... is much like printing and faxing any other document First set up your page then print or fax the Spreadsheet document You can also print or fax a chart from your Spreadsheet documenL Setting Pa_ _ Setup Opti ons _ _ _ Before you print use Page Setup from the File menu to select your page layout options Refer to page 92 for using built4n functions To set Page Setup options for printing 1 Select Pa...

Page 132: ... references to print on each page of your spreadsheet Print Header Use this option if you want to have headers printed on the pages of your spreadsheet You can specify headers using Header Footer from the Cell menu Print Footer Use this option if you want to have footers printed on the pages of your spreadsheet You can specify footers using Header Footer from the Cell menu Click on Apply Click on ...

Page 133: ... box appears 4 In the Print Range box enter the cell numbers you wrote down in step 1 Select from the other fax options and click on Print Graphics Exporting and ImportingSp eadsheets Exporting allows you to use a document created with Spreadsheet in another Spreadsheet program such as Lotus 1 2 3 Importing allows you to use documents created in another Spreadsheet program You can export to or imp...

Page 134: ...er a name for the exported file The correct extension already appears in this box so you do not need to enter it Be sure to enter a standard DOS file name no more than eight characters long 6 Click on Map Export Fields A diak g box a_ with Column A Column B and so on listed in the Source List box the columns that appear here corr_xrnd to the occupied columns in the _eet The Destination List consis...

Page 135: ...Import l _To change the order of columns when importing 1 Select New Open from the File menu The New Open dialog box appears 2 Insert the diskette that contains the file to import and click on Import A dialog box appears 3 From the left column select the file you want to import 4 From the right column select the format Comma Separated Format or dBase IV _ _ 5 Clicff ori Map Imp6_ Fieldsl Tbe Map I...

Page 136: ...or formula results Refer to page 82 in this chapter One or more of the cells referenced in a formula contain an alphanumeric entry Rewrite the formula to include only cell addresses containing numbers Formula is incorrect Verify format of formula to ensure proper data is given Example DATE 96 08 23 Incorrect formula entered Verify correct format is entered Example IF B2 20 40 20 10 Formula contain...

Page 137: ...ng To open Drawing Click on the Drawing icon from the Main Menu The New Otx n dialog box appears Select New A new document appears Drawing tool bar _ I_I_ IOJAI IOIOIO _I Print Open Close and _ Save buttons _ The area outside the dotted lines will not print Attributes tool bar _ see page 136 To select or click on an item place the on screen pointer on the item then click on the Select button or ta...

Page 138: ...The Drawing tool bar is also available in Word Processing and Spreadsheet where it appears on the left of the document window Drawing Tools Pointer tool Selects moves and re sizes objects The arrow pointer is automatically selected when you start Drawing Rotate tool Allows you to rotate objects Zoom tool Enlarges your work area so that you can see more detail Text tool Adds text to your drawing Yo...

Page 139: ...lection tool Selects all or part of an object to copy cut or paste Brush tool Allows you to draw lines Eraser tooL Removes lines and drawings _ Bitmap Line tool Draws a straight line in a bitmap A bitmap uses tiny dots to form an object Bitmap Rectangle tool Draws a bitmap rectangle Bitmap Ellipse tool Draws an bitmap ellipse Fill tool Fills an area with a tone Pixd View tool Allows you to view in...

Page 140: ...mirs If you select the Line Rectangle or Ellipse drawing tool the pointer changes to crosshairs when you move it over the drawing area The center of the crosshairs shows where the shape will begin as you draw Crossed I beams If you select the Text tool and move the pointer into the drawing area the pointer changes to crossed I beams If you move the pointer over a text object the pointer becomes a ...

Page 141: ...drag diagonally until the shape is the size you want as indicated by the outlines that appear in the drawing area 5 Release the Select button The object appears as a solid shape After you create an object resize handles appear around the outside and a move handle appears in the center Use these handles to move and resize the object Handles also indicate that an object is selected _ I_ To move or r...

Page 142: ...r changes to crossbairs when you move it into the drawing area 2 Move the crosshairs to where you want to start your line You do not have to move it exacdy to the right place now you can change it later 3 Press the Select button and while holding it down drag until the line is as long and in the direction you want Release the SelecL b_it_ A straight line appears with a handle at ea rb end and a mo...

Page 143: ...ere is no object Handles in the dra_ng d_apl_a_ _ il_ To select several objects Selectingseveral I Click on the pointer tool objects is useful when you want to move or change the tone of several objects that are next to each other 2 Move the pointer above and to one side of the objects you want to select Hold down the Select button and drag across the area you want to select As you move the pointe...

Page 144: ...bject 2 Hold the Select button and drag one of the resize handles but not the move handle in the center of the object To resize the object around its center point hold down the C key or the comma key while dragging To resize an object to scale instead of stretchingit see page 141 To proportionally resize an object hold down SHIFT while you drag one of the comer handles 3 To proportionally size aro...

Page 145: ...want To reduce a drawing use a percentage from 12 _ I_ to 99 TO enlarge a drawing use a percentage from 101 to 400 I_ To return to normal size In the View menu click on Normal Size The drawing is shown at 100 scale Ip To show the ntire drawing in the window In the View menu click on Scale to Fit The drawing fits into the window I _To show or hide scroll bars In the View menu click on Show Horizont...

Page 146: ...p to 100 sides use Create from the Edit menu The following illustration shows some examples of objects polygons and stars og _ To draw simple objects arcs and lines with the Create submenu 1 Select Create from the Edit menu 2 Click on the name of the object you would like to create The object appears on the screen 3 With the object still selected you can select attributes such as tone see page 136...

Page 147: ... star 1 2 Select Create from the Edit mentt Select Stars from the Create submenu A dialog box appears I struts _uterl_dius ItOOpt ill_l_ IlOOpt f_ _l Znmrhd_s I_pt ilq_l_ i_Pt I11_1 lcr t s ar I m The outerradiusis 3 measured frompoint to poinL The inner radiusis the centersection of the star Remember that radiusis the distance from the center to the edge Fill in the dialog box Number of Star Poin...

Page 148: ...ies such as the fill tone shading flu pattern and drawing mode Line attributes are qualities such as the tone line pattern thickness style and arrowheads Text attributes control items such as the font size tone line spacing paragraph spacing indents tabs and borders Background tone used with area attributes can be used to create custom tones Tone and patterns can add emphasis and appeal to a graph...

Page 149: ...ou want to change 2 Select Area Attributes from the Attributes menu A dialog box appears 3 Fill in the dialog box Filled or Unfilled Select Filled to fill the enclosed area of the graphic object and to set other options in this dialog box By default area is unfilled Shaded Select the percent shading for the fill tone The lower the number the more transparent the tone By default this setting is 100...

Page 150: ...attern To change an object s tone or pattern using the Attributes menu 1 Select the object s Handles appear around the object s 2 Select Area Attributes from the Attributes menu A diedog box appears 3 Select the tone or pattern from the palette in the dialog box 4 Click on Apply 5 Click on Close Use background tone TO use a background tone when youwant to use tone under your pattern or shaded tone...

Page 151: ...tributes 1 Select one or more arcs to change 2 Select Arcs from the Atuibutes menu The dialog box on the left appaccrs 3 Fill in the dialog box changing the options you want Starting Angle Select the starfin g angle You can specify from zero 0 to 360 degi e_induSive Endimtg_mgle Select the ending angle You can specify from zero 0 to 360 degrees inclusive _ End Points Cotanccted Select whether you ...

Page 152: ...filled Select Filled to fill the line or border of the graphic object which makes it visible Select Unfilled if you want the line or border to be invisible By default the line is Filled Shaded Select the percent shading for the line tone The lower the number the mote transparent the tone By default this setting is 100 A zero 0 setting is the same as an unfilled line or border Tone Tools Select the...

Page 153: ...aionally Using the Scale submenu you can make objects larger by entering a value greater than 100 o or make them smaller by entering a lower value than 100 m Youcan scale ver_cal 4 and horizontaldimensions independentlyortogether 5 Youcan use scaling to elongate or shortena text o bjecL To flip an object _ _ _ 1 Select the object s to flip Handles appear around the object s 2 From the Transform me...

Page 154: ... tool on the Drawing tool bar Thepointer changes to a cunmd arrow when you move it over the drawing area 3 Place the tip of the arrow on one of the handles surrounding the selected object The pointer changes to crossed arrows 4 Grab the handle by clicking and holding down the Select button The handles disappear 5 While holding down the Select button drag clockwise or counter clockwise until the ob...

Page 155: ... Skew to apply the skewing repeatedly until you achieve the result you want 5 Click on Close Untransforming Objects You can remove any skewing scaling or rotations you have made to an object reverting to the original drawing You might want to do this for example_if you we_ cxp rimenting With different transformations and wanted to reverse everything you have done Untransforming removes all transfo...

Page 156: ...om duplicate 2 Select Duplicate from the Edit menu A d_ og box appeam I _te _PIm_ mr _ _ t_ IT II_ r_ lop i_ 3 _Rtd _ rr 7 El 3 5 Fill in the dialog box of Duplicates Select the number of duplicates Rotate Select the number of degrees to incrementally rotate each duplicate Scale Select the scale percentage to incrementally resize each duplicate Move Select the vertical and horizontal distance to i...

Page 157: ...s should you later untransform the object For more information see Untransforming Objects on page 143 DItTo convert object sto a graphic object 1 Sele d 0ne w or more oblects to convert 27 Select Convert from the Transform menu A submenu appears 3 Select Convert to Graphic Drawing converts selected o_ects to a single object Converting from a graphic breaks a single graphic object down to its compo...

Page 158: ...e menu The object is moved accordingly Moving Objects Objects that you place outside the print border the dotted line near the perimeter of the drawing area will not appear when you print When you create objects you can move them around your drawing as you like This section describes how to move objects in a drawing To help you gauge the position of your objects relative to the total drawing area ...

Page 159: ...r where you want the objects to be placed 5 Release the Select button The o_ ects appear in the new location _ To custom move objects 1 Select one or more objects to move 2 Select Move from the Arrange menu A submenu appears 3 Select Custom Move from the submenu A dia og box appears 6 Custtmn 0 Centimeters _lO pt O Points OP_Os Fin n the Horizontal Select the horizontal distance you want to move A...

Page 160: ... the following Change the fill tone for all three rectangles all at once Rotate them around a common center A group can contain any object induo_ng another group Move them as a group without changing their positions relative to one another Resize them as a group while maintaining their relative scale After you have made changes to a group you can ungroup it to make each component a separate object...

Page 161: ...following example shows how to paste one object inside another To paste inside ff _e two objectsdo not 1 Place the inside object over the outside object Position the inside object ovedap you cannot where you want it in the outside object as shown in the following paste inside example Be sure to position the interior object as close as possible to where you want iL You can fine tune it later nudgin...

Page 162: ...rom the Edit menu A submenu appears 3 Select Break Out Paste Inside Drawing splits the objects into separate objects The ru ers help you measure vertical or horizontal distances Rulers help you position align and resize objects You can show rulers along the left and top borders of the drawing area By default Drawing shows rulers You can hide the vertical ruler the horizontal ruler or both to incre...

Page 163: ...s to the grid even if the grid is hidden _l_ To show or hide the grid 1 Select Grids from the Options menu A dialog box appears If Snap to Gn d is selected in this dialog box Drawing aligns o_ ects to the grid 2 Select Show Grid to show the grid OR Deselect Show Grid to hide the grid 3 Click on Apply 4 Click on Close I_ To set the grid spacing 1 Select Grids from the Optiom menu A dialog box appea...

Page 164: ...automaticallycreates a text object 6 inches across and I line high As you type the text object automatically grows verticallyto accommodate new lines of text Youcan resize the object later Size Style Tone Alignment _ To create a text object 1 Select the Text tool from the tool bar Thepointer changes to crossed 1 beams when you move it over the drawing area 2 Place the I beams where you want your t...

Page 165: ...e you want to begin typing Hold down CTRL then hold the Select button and drag the on screen pointer diagonally to create your text object The size of your type will be the size of the object you create Release the Select button The blinking insertion point shows the size of capital letters Begin typing If your characters are too large for the words to fit in the object you defined Drawing extends...

Page 166: ...cted text or text in selected objects The point sizes available are 9 10 12 14 18 24 36 54 and 72 You can also select Custom Size from this same submenu Ifyou changetextso that itis verylarge or very small Drawing a_usts the heightof the text object but not the v_dth To change the font style or size of text in a drawing 1 To change text within a text object use the Text tool to select the text you...

Page 167: ...ted object changes alignm_t Adding Tone to Text You can add tone to some or all of the text in a text object by selecting Text Tone from the Text menu or by using the Text Tone tool from the Attributes tool bar To change text tone using the Attributes tool bat select the text then click on the Text Tone tool Select a tone from the list that appears You cannot select percent shaded using this tool ...

Page 168: ... the Cream option on the Edit menu A bCtmap object is any object you create using any of the tools on the Bitmap tool bar A bitmap is an object made up of pixels which are individual dots that make up an object like the dots on a television screen Bitmaps allow you to create freehand objects Because bitmaps have special properties Drawing provides a set of tools for manipulating pixels The Bitmap ...

Page 169: ...nnot however move or resize individual bitmap items you place in the bitmap frame Once you place a bitmap item into a frame it permanendy becomes part of that frame unless you select Undo from the Edit menu l_ To draw a bitmap frame _ _ 1 Select the Frame tool from the Bitmap tools Thepointer changes to crosshairs when you move it over the drawine area 2 Move the on screen pointer to where you wan...

Page 170: ...ng bitmap shapes Straight lines Rectangles Ellipses Freehand shapes Once you draw a bitmap shape it becomes part of the bitmap frame You cannot change a bitma_ghape asyou Would a draw object For example you cannot move or r_size a bitmap ellipse directly you can only draw another ellipse in the new location or size you want For this reason it is helpful to select Undo from the Edit menu to correct...

Page 171: ...rectangle then hold the Select button and drag until the rectangle is the size you want 5 Release the Select button A rectangle appears with the attn butes you selected To draw an ellipse circle Pressing SHIFT__ilo__ dravdng an ellipse creates a circle 1 Select Area Attributes from the Attributes menu 2 selectdae area fill tone shading and pattern 3 Select the Bitmap Ellipse tool from the Bitmap t...

Page 172: ...e region You can select all or part of the object I_ To select a region within a bitmap object _ 1 Click on the Bitmap Selection tool Tbepointer changes to crossbairs when you move it over the drawing area you can cut or opy_ 2 Move the pointer to v there you want to anchor one comer of the the selected region to selection therLhold the Select button and drag until the selected regton is the clipb...

Page 173: ...nu When you use the Eraser tool Drawing changes the tone of affected pixels to white It has the same effect of painting pixels white using a different Bitmap tool such as the Rectangle tool i_ To erase pixels in a bitmap frame 1 Select the Eraser tool from the Bitmap tools Thepointer changes to a square when you move it over the drawing area 2 Move the pointer to w_ere yofi want to start erasing a...

Page 174: ...n click the Select button The Pixel View appeam 3 Select the bitmap tool you want to use to change pixels 4 In the Pixel View window use any of the Bitmap tools to change pixels individually or in groups To change the Pixel View area With the magnifying glass tool click on a pixel in the Pixel View window This pixel becomes centered in the Pixel View window OR Click in the bitmap object outside th...

Page 175: ... format 2 Select Bitmap Format from the Attributes menu A dialog box appears 3 Fill in the dialog box Monochrome or 16 color Select the bitmap format you want Resolution Select the resolution you want 72 dpi 300 dpi or Custom from 1 2400 dpi 4 Click on Apply 5 Click on Close Printing or Faxing Drawing Documents Before printing a Drawing document for the In st time review Setting Printer Options in...

Page 176: ...ubmenu appears 2 Select Print The Print d_ og box appears 3 Select your print options then click on Print To fax 1 Save your document then press PRINT A submenu appears 2 Select Fax The Fax dialog box appeam 3 Select your fax options then click on fax Drawing 164 ...

Page 177: ...ects TIFF files can be used by programs on many different kinds of computers l_ To import a graphics file 1 Iryou are importinga 2 drawing and do not know the format select No Idea and Drawing 3 willanalyze the drawing to see if itcan 4 be imported Open the Drawing document into which you want to import a graphics t fle Insert the diskette containing the drawing to import then select Import Graphi...

Page 178: ...n to use the exported file with Microsoft Windows 3 0 or higher and you want the file to be Run Length Encoded RLE compressed Compression These options appear only when you select TIFF from the Formats list Select Uncompressed to export without compression Select Auto Compress to export with compression Export Entire Document Select this option to export the entire fde Export Selected Objects Sele...

Page 179: ...copied any scraps into this document it is empty If you have already entered scraps the contents of the first page appear in the View box After placing the f_t scrap in the Default Scrapbook save it without renaming it if you want the Default Scrapbook to open each time you open Scrapbook Or you can create and save a new Scrapbook document to open when needed see page 171 l_ To start Scrapbook _ C...

Page 180: ... from the File menu The Import Scrap dialog box appears 3 From the left select the name of the file you want to import and from the right select the format either No Idea or TIE 4 Click on Import Copy andPaste _so_ I_To opy f rom another program to Scrapbook _ppear in the Edit menu When you paste an item _2 from another program into your scrapbook 3 you automatically add a 4 new page to the scrapb...

Page 181: ...ext page If you are on the last page the Next button takes you to the fLrst page l_ To move to the previous page Click on Previous to go to the previous page If you are on the fhst page the Previous button takes you to the last page I_ _ To go to a specific _age j 1 Click mGo to Ira g67 A _lialog box appears 2 Double dick on the page number or page name to show the page in the Scrapbook window 3 C...

Page 182: ...pbook is restored to tbe pretdouMy saved version Naming a Page of Scraps Page names describe the type of scrap stored on the page and can be helpful when you want to locate particular items in a large scrapbook Page names are shown in the Name box at the bottom of the Scrapbook window the names are also listed in the Go to Page dialog box Names may be up to 32 characters long _ To name a page __ 1...

Page 183: ...nd give it a name 4 Press SAVE A dialog box appears 5 To select a folder for saving the new document in click on the icon of the folder 6 Type a name in the New Name area then click on Save You are returned to Scrapbook with that document open _To save a scrapbook document Press SAVE Importinga Scrap from a DOS Program When you import from WordPeffect5 0 into Scrapbook the font size changes from 1...

Page 184: ...m 1 Open the scrapbook in which you want to place the image 2 Insert the diskette containing the scrap graphic or text that you want to import 3 Go to the page that you want to follow the imported page 4 Select Import Scrap from the File menu The Import Scrap dialog box appears 5 Select the name of the f de you want to import and select the format 6 Click on Import Scrapbook 172 ...

Page 185: ...gwithDocuments business and one for personal SavingDocuments WorkingwithMenus WorkingwithDialog Boxes Starting Addressbook When you open Addressbook the default document called First Addressbook appears After adding names and addresses save First Addressbook without renaming it if you want the Default document to open each time you open Addressbook You can also create new Addressbook documents see...

Page 186: ...start entering names addresses and phone numbers into different boxes Each box is a_e d of information Creating and Adding New Cards To create new cards and add them to your Addressbook start with a blank card and then type information into three fields the index field address field and phone number field The following illustration shows these fields Rip to cards byletter indextabs Flipto cardstha...

Page 187: ...t character If you typed a last name and first name separated by a comma in the index field then the two names switch places as they are copied 4 If you want to change the name as it appears in the address field and not in the index field press BACKSPACE to delete the incorrect text then enter the revised name 5 Press ENTER again and type the address information Press ENTER at the end of each line...

Page 188: ...hange a phone type on the current card 3 4 1 Click on the up and down arrows next to the phone field until you see the entry you want to change 2 Click in the phone type field you want to change The insertion point appears Edit the existing phon_e You can press DELETE or BACKSPACE repeate _5 and th _e th e new name for this entry Press TAB or click in the phone number field Type the phone number T...

Page 189: ... to keep track of such as a home and a business address Save yourself some typing time by selecting Copy Record from the Edit menu to copy the card with the basic information then edit the copy To copy a card 1 Flip through your Addressbook until the card you want to copy is shown 2 Select Copy Record from the Edit menu 3 Click on New to show a blank card _ 4 Select Paste RecordLirom the Edit menu...

Page 190: ... by selecting Undo from the Edit menu right after you delete Adding Notes to Cards Notes can be useful for keeping track of birthdays special interests and any other information To add notes to a card 1 Select the card to attach the note to then click on Notes A sma l window appears in which you can tYpe the note 2 Type any information 3 Click on Close The note is attached to the current card _ To...

Page 191: ...xes in the Finddalog box you can disable searchingin one or more fields The index fieldcannot be disabled 2 Fill in the dialog box typing the text you want to search for in the Find field and choosing the options you want 3 Click on Find Next Addre mbook shows tbe first card containing the specified text The text is selected in the displayed card If the text was found in the Notes box the Notes bo...

Page 192: ...ew Name area then click on Save The new document is saved with the name you provided You are returned to Addressbook with that document open Printing and Faxing an Addressbook When you print with Addressbook you print just the information in your Addressbook not the card design that appears in the window Addressbook allows you to print the information that is currendy shown on screen as a card a l...

Page 193: ...the items you specified prints Notes are inserted in the list if you are printing with the Print Notes option OR If you are tra nting with the Current record option the information from the card currently on screen prints To print envelopes and labels I Open the Addrec_book_you Want to print 2 Select Send from the File menu A submenu appears 3 Select Print The Print dialog box appears 4 Select Opt...

Page 194: ...ress file 1 Insert the diskette containing the file to import 2 Save and close the current Addressbook The New Open dialog box appearr 3 Select Import A dia og box appears 4 Select the file format from the right Thefile aa tension appears in the File Mask box and only documents with that extension are displayed in the file selector 5 Select the drive and document to import from the left 6 Click on...

Page 195: ...4 until you have mapped all the fields you want Select from the Map List and_ch ck_oo_ Unmap to change any map pairs you have designated inoorrectly 7 When you have mapped all the fields you want click on Done The Import dialog box reappoum 8 Click on Import A message appears telling you that the import is in progress If the file is very large it could take several minutes to import You cannot int...

Page 196: ... A dudog box appears 3 Select Comma Separated Values or dBase IV from the formats list 4 Select the document to export then click on Map Export Fields The Map Extxxn Fields dialog box appears Sourco Limb lndax_Field Rddr_ReJd Not o JF ield Nome Office Car Fox Phmte_6 Phone_7 F 1 5 Select one field in the Source List and one corresponding field in the Destination List to correlate the field informa...

Page 197: ...g Planner When you open Planner the default document called My Schedule appears After entering appointments save My Schedule without renaming it ff you want the Default document to open each time you open Planner You can also create new Planner documents see page 200 To start Planner Click on Planner from the Main Menu _ Planner window appears tilt _ _ uk_lt Utllt_ _ 121U i_ _ _ I_ Ib88 lu t Ib3o ...

Page 198: ...ou are scrolling but you never see more than one month at a time The current day of the month is highlighted _ To switch to the full year view 1 Select Full Year from the View menu The ca endar shrinks so that more than one month can appear in the window 2 Use the scroll bars to view any additional months that do not fit in your window l_ To switch back to the single month view Select Single Month...

Page 199: ...ions You can also schedule repeating events Toseedifferentyears clickonthe upanddown arrows Or double click theyear andeditiL Clickona dayin the cal endarwindowto selectit andviewitsevents Calendar window Today sdatehasa thick blackborder I I 12 19 26 Toseedifferentmonths clickonthe scrollbar Scrollleftfor previous monthsandscrollrigMfor futuremonths Selectedday this day s events appearinthe Event...

Page 200: ...r in the Events window To view events on the next or previous day In the Events window click on the up or down arrows at the top right side of the Events window Click on up for the previous day and down for the next day As the selected day changes events for that day appear in the Events window To view events for today You can also view _ Press CTRL T TZod_ _comes tbe selected day and its events a...

Page 201: ...e cunfereeuce 2 30 PH Long range plumd_j f rL Dec 15 19915 5cl_ PM Prepare for Christmos Planner _ S c_hedul_ sv I Therangeof d _t_ is highlighted inthe Calendar window A summaryof eventsovertheselected rangeappearsinthe Eventswindow In the Events window onlythosedayswhich haveeventsscheduled areshowninthe ___ summary ff there are no events in the range the Events window shows Nc Events _To view a...

Page 202: ...t Theoasiest_y to I_ To schedule an event by selecting from the day template schedulean eventis to select a day and then 1 Select the day on which you want to schedule an event select a time from the 2 In the Events window select a time from those provided in the day day template template A border appears around the event divided into a time area and a description area tz eem H I 2 3ePH TiL of eve...

Page 203: ...u realize that you made a change you wish you had not select Undo from the Edit menu before you do any other task Removing a Scheduled Event _ _ _To remove a schedD ed event _ Ifyou accidentally I In the Events window click on the event you want to remove delete the wrong event select Undo 2 Select Delete Event from the Edit menu The event is removed from the from the Edit menu Events window If th...

Page 204: ...Event from the Edit menu The new event appears in the Events window and its time highlighted 3 Edit the time if the one shown is not correct The time must be in the HH MM format For example you can type 11 50 Pr_for a new time OR If you want to schedule an event with no specific time delete the text in the time area 4 Press TAB or click in the description area then type a description Copying Event...

Page 205: ...ch as a birthday or a holiday Monthly by day A mombly by day event occurs every month on the same day of a particular week such as every third Sunday Yearly by day A yearly by day event occurs once a year on the same day of a particular week in a particular month such as the first Sunday in March When you schedule a repeating event it appears in the Events window on the days for which it applies Y...

Page 206: ...ormat and type AMor PM 6 Type a brief description of the event in the Event box 7 Select Forever if your event should repeat indefinitely OR _ _ _ _ Select From if your event is of limited duration and should repeat only over a specific time period Edit the start and end dates 8 Click on OK The original dialog box appears 9 Click on Close The weekly repeating event appears in the Events window at ...

Page 207: ... yearly event by day of the week 1 Select Repeating Events from the Utilities menu A dialog box appears 2 Click on New Another dialog box appears 3 Select Monthly if you are scheduling a monthly event by day of the week OR Select Yeady if you are scheduling a yeady event by day of the week 4 Select Day of Week 5 if you are scheduling a yeady event use the up or down arrows to select the month your...

Page 208: ... on OK The original dialog box appears 5 Click on Close be changes are reflected in the Events window Removing a Repeating Event from the Calendar If your repeating event is no longer part of your schedule you can remove the event To remove a repeating event 1 Select Repeating Events from the Utilities menu 2 Se_lect thename of__e_e_ _nt you want to remove from the list and Lben click on Delet_ 3 ...

Page 209: ...ot sent a fax before review the chapter tided Fax and Data Modem in Book 1 Selecting thep_age size _ Before you pnnt o r f_Lx use the Page Size dialog box to specify the dimensions of your calendar Normally Planner prints its documents at 8 5 x 11 inches You can change the page size for instance to print a poster sized calendar across multiple sheets of paper which you can tape together Page Size ...

Page 210: ...ars 3 Under Planner Options click on the button next to the word Content A drop down list appears 4 From the drop down list select Month then click on the up or down arrow to select a month OR i _ Select Year then click on the up or down arrow to select a year You can also edit the number in the Year box OR Select Events window When the Content is set to Month select Include Events if you want to ...

Page 211: ...rrow to select a year You can also edit the number in the Year box OR Select Events window When the Content is set to Month select Include Events ff you want to fax the first few lines of events for each day OR If you want to fax a blank calendar make sure the Include Events option is off 7 Click on Fax when you are f mished Planner 199 ...

Page 212: ... Close from the File menu The New Open dialog box appears If you have unsaved changes in the current calendar you are asked if you wish to save or discard them 2 Click on New A new calendar appears 3 You must add one or more events to the new calendar before you can save it and give it a name An easy way to do this is to select New Event from the Edit menu 4 After adding an event select Save As fr...

Page 213: ...ox appears _ Book Reader Plee_ select e book 1o open Iletu Disk Tool availabilRy is based on _e book you have open Tools appear gray when not available Select a book from the list When you open a book you are given a set of tools as follows Back When using a hyperlink to jump to information in different parts of the book Back takes you back to the previous page If Book Reader is showing the first ...

Page 214: ...r example you could copy a page of zip codes for your city and indude it as a part of a document you are creating in Word Processing ff a book has a Table of Contents page Book Reader shows it to you when you start If it does not the first page of the book appears To read a book To Start Move the page up and down Turn_thepage Jump to a hypedink Return to a pi evious page Return to the fLrst page D...

Page 215: ...ouer one it changes to a cursor question mari_ 2 Click on the spot The area flashes then Book Reader motes to the information on that topic To copytext or other content from the book You can paste the text 1 Place the insertion point in the text then hold the Select button and move in Word Processing or your finger across the glidepad surface until the text is highlighted rDrawing 2 Click 6n the _...

Page 216: ...Be sure you have set up your printer see Setting Printer Options in the Getting Started chapter of Book 1 To print selected text from a book 1 Select the content to print 2 Click on the Send icon at the bottom of the screen The Send dialog box opens 3 Click on Printer then click on Send To print the current page With the page you want to print displayed in the Book Reader window click on the Send ...

Page 217: ... chapte_ in Book 1 text without special formatting like boldfacing adjustable tabs and page Worltingwith Documents Saving Documents breaks You can also import ASCII text files into Word Processing or export WorkingwithMenus from Word Processing to ASCII see page 64 WorkingwithDialog Boxes _ To start Text File Editor 1 Insert the diskette labelled Text File Editor 2 Click on File Manager from the M...

Page 218: ...dings When your text reaches the right edge of the window it wraps automatically to the next line This feature is called word wrap Word wrap means that you do not have to press ENTER the Return key on a typewriter to start a new line of text When oware ready to begin a new paragraph press ENTEiq If you want to set lin_ endings press ENTER at the end of each line If there is more text than can fit ...

Page 219: ...fferences when printing Text File Editor documents Line Length The length of a line in the printed document is not always the same as the length of the same line shown in the Text File Editor window In the Text Fie Editor window text wraps at the right edge of the window When you print however text wraps at the right edge of the page However if you end a line by pressing ENTER this line ending is ...

Page 220: ... Give them names that follow the DOS rules for naming files up to eight characters long no spaces followed by a period and three more characters Use TXT following the period to indicate your file is a text file For more information see Naming a DOS File in Getting Started Book 1 Text File Editor 208 ...

Page 221: ... play Turnabout against another person or against the system Either _ay the game play sequence is the same Ifyou are not sure where to make your next move select Hint from the Game menu _ To play Turnabout 1 Insert the diskette labelled Tumabout in the disk drive 2 3 4 Click on File Manager from the Main Menu File manager appears Click on the drive A icon The contents of the diskette appear Locate...

Page 222: ...lay against the system without making the first move To begin play select Start New Game Allows you to watch the system play itself To stop the game select any of the other player options Selecting Ma chine vs Machine automatically starts a new game Allow_g__OU_to put barriers in some of the squares on the falaying board Selecting Obstacles starts a new game iAllows you to change the size of the p...

Page 223: ...ere if you are playing a timed game Playing the Game Drag cards to move them from stack to stack and click on face down cards to flip them over To start a new game Select Re Deal from the Game menu or click on the New Game button in the lower right hand comer Double click a card in one of the seven lower stacks to send it to one of the four upper stacks ff it is a legal move To move a card to a ne...

Page 224: ...n you drag cards to a new location If you click a card possible locations for that card appear highlighted You can move cards back from the four upper stacks to the seven lower stacks something you cannot do at higher levels You can also move parts of a face up stack to another stack For example if you have a sequence of six cards on a particular pile you can move the last three face up cards to a...

Page 225: ...ch time thereafter 10 the first four times 20 30 land so on each time thereafter Vegas Your game starts when you choose Re Deal from the Game menu You start each Vegas game already 52 points in the hole and for each re deal you lose another 52 points For each card you successfully move to an upper stack you receive five points Points are cumulative from game to game You are also limited to how man...

Page 226: ...tion from the submenu Changing Other Options In addition to choosing a playing level and a scoring method you can also set other playing options These options appear in the Options menu and are summarized in the following table IF YOU Change Card Backs YOU SEE A dialog box where you can select differ ent artwork for the backs of the playing cards Set Countdown A dialog box that lets you specify th...

Page 227: ...tions are represented by a keyword followed by arguments enclosed in parentheses The function returns a value based on the arguments you enter For example in the expression SQRT 144 SQRT is the keyword for the square root function and 144 is the argument This function returns 12 the square root of 144 Argument Rules The following rules apply to using arguments in functions You can use numbers cell...

Page 228: ...s the total number of payments that are made Be careful to enter the interest rate for the same time pen od as the payments Internal rate of return of series of irregular payments at regular intervals k returns the interest rate when you know the initial investment and know you will get regular payments of varying amounts Guess is the number you guess is approximately the in_x _st rate Range fs th...

Page 229: ... the investment period Be careful to enter the interest rate for the same time pen od as the term Information Functions The information functions return information about a cell or a range of cells Function cI oosE _ valuel value2 _ Descd_ion Returns the n th value in the list of arguments where the first value is 0 and index indicate _ the n th valu_ _Valt_e carrbe flor_ 0 to n 1 You can use as m...

Page 230: ...t_ or 0 if it is not Useful in IF statements IS STRING value Returns1 if an expression is a string or 0 if it is not Useful in IF statements 3I range Returnsthe value flora the first cell in a range if that cell contains a number time or date If the cell contains text the function returns 0 zero NA0 ROWS range VLOOKUP m ue range offset Returns the number of rows in a range Stops the evaluation of ...

Page 231: ...OKUP or VL OOKUP the table entdes must be sorted in ascending order I 2 3 4 5 5 7 R I e Ic In i i i il i5ooi i i i IEI r isl i i i i t 0 i I_ 0 i i i i i i i i i i i i i HLOOKUP B1 B3 F4 1 10 In this example HLOOKUP B1 B3 F4 1 returns 10 B1 contains the value 1257 units BI F4 is the table range The offset is 1 which defines the row containing information to search In this case the offset is the ro...

Page 232: ...entheses See also TRUE Evaluates a condition returning one specified value if true and another if it is false Logical is any expression or value that can be evaluated as true or false True value is the value returned if the logical expression is true False value is the value returned if the logical expression is false Returns 1 if at least one of the arguments is true or 0 if all of the arguments ...

Page 233: ... box at the left Logical Function example combining functions By combining IF with the AND and OR functions you can create even more complex conditional statements Consider the following examples IF AND AI 100 BI 100 Cl IOO 5 0 The result of this formula is 5 only if the values in A1 B1 and C1 are all greater than 100 Otherwise the result is 0 You can apply the same principle using the OR function...

Page 234: ...number LN vahte Natural logarithm of value using the constant e as a base LN is the inverse of EXP Value must be a positive number For example LN 2 returns 0 693147 LOG value Base 10 logarithm of va ue Value must be a positive number For example LOG 100 returns 2 MOD value divisor Modulus the remainder of the division of value by divisor If you attempt to divide _ MOD returns an_ er_o_ _ _ by zero...

Page 235: ... of cells that contain numbers The results of these calculations are always numbers Function AVG valuel value2 Description Average of the values in a list You can use as many arguments as you want AVG treats empty cells as zero values You cannot average cells containing text MAX valuel Largest number in a list Listcan include values or addresses separated by commas value2 MAXignores empty cells an...

Page 236: ... number The CHAR string function converts code numbers to characters You can use values between 1 and 255 The function of CHAR 0 is the opposite of CODE 0 If the value is out of the 32 255 range CHAR returns a VALUE error For example CHAR 65 returns A Strips unprintable characters from a string Useful for removing nonprintable characters fTom imported text For example CLEAN CHAR 13 text returns te...

Page 237: ...etter following any nonletter character PROPER converts all other characters to lowercase Repeats a string a specified number of times If nton is zero REPEAT returns an empty string For example REPEAT HA 6 returns HaHaHaHaHaHa Replaces matching characters in a string with a specified string On_ina is the text string in which you want to replace chara_ers Start is the first character in the origina...

Page 238: ...fractiona part the time is midnight Extracts the minute from the time value serial number The minute is an integer from 0 to 59 Time seri numbers are decimal fractions and can be part of a date dme combinationyJf_ _ is nO fractional part the time is midnight You can use TIMEVALUE t convert text time Extracts the month from the date va ue serial number Month is an integer from 1 to 12 Timeserial nu...

Page 239: ...l to or greater than 1 ASlN value ASINH value ATAN value ATANH value ATAN2 value Returns the angle that is the arc sine of a value The arcsine is the angle which is the sine of value The angle is between lt2 and 7t2 radians Value must be from 1 to 1 l Returns the angle that is the hyperbolic arc sine of a value The inverse hyperbolic sine is the number which is the hyperbolic cosine of value Retur...

Page 240: ...arentheses Converts degrees to radians Returns the sine of an angle expressed in radians If you know an angle in degrees you can use the RADIANS function to convert it to radians Returns the hyperbolic sine of an angle expressed in radians Returns the tangent of an angle You must express angle in radians If you know an angle in degrees you can use the RADIANS function to convert it to radians Retu...

Page 241: ...unit of information consisting of 8 bits used to show memory capacity card view in Addressbook to be able to view one address card at a time carriage _ the_ _me chanical u_that cat i e_s Lh_kjet cartridge back and forth across the pa_e case either upper E or lower e cell the box irva spreadsheet in which you enter data cell address the location of a cell shown by its row and column For example A1 ...

Page 242: ...of a computer do not pointer one of the shapes of the pointer It indicates that the pointer is not in an area of the screen where you can take any action Drag button the bottom button on a glidepad or right button on a mouse used to move an item on the screen For example to move tex_o a new location select the text hold down the Drag button and move the on scneen pointer to the new location draggi...

Page 243: ...ded double density double track and MF 2HD double sided high density double track formula performs a calculation like totaling numbers function k e rs_ the top row keys that activate functions such as copy paste etc functions Basic iool bar contain b ut t 6ias t oor performing tasks such as save copy etc functions Advanced tool bar contains buttons for performing tasks such as zooming in geometric...

Page 244: ...r folder insert mode a mode for entering text in which new text pushes existing text to the right insertion point the blinking vertical line on the screen that shows you where your next text will be plac _ _ _ _ __ interact Not cap talizecl any collection of computers connected to share information Internet Capitalized the world wide network of computers accessed through an Intemet Service Provide...

Page 245: ...enlarge a window from icon size to full screen size menu a list of choices menu bar contains all the pull down menus for the application merge _to_combine data from one applicafig n with data from another minimize a window to reduce a window to the size of an icon modem a deyice for connecting to a telephone line for the electronic transfer of information monitor a CRT Cathode Ray Tube screen and ...

Page 246: ...AM random access memory stores information for the on screen display and for routine tasks such as opening a submenu _ _ _ range a group of cells in a spreadsheet read only a type of file or diskette that can be opened but not changed redraw for recreating or updating the image on the screen so that all of the text and graphics are accurate reference mark the character usually a number used to mat...

Page 247: ...n to send or receive a character string a series of characters used in spreadsheet formulas style a collection of text and paragraph format options grouped under a common name See text style sheet Style tool bar_ contains tools for changing te2ct style size font etc and for checking spelling _abmenu a secondary menu that is_reveal_l_hen a menu or another submenu is selected tab leaders dots or lin...

Page 248: ...ymbol or that substitutes for an unknown character when searching for a word Wildcards make certain word searches more efficient window a boxed in area of the screen in which you are creating or editing a document Windows have a title bar and menu bar across the top word wrap a feature allowing words that cannot fit on one line of text to automatically be placed on the next line wrapping text a fe...

Page 249: ... erase 161 formats tag image formats TIF 165 frame creating 157 freehand 159 images editing 160 line 159 objects Drawing 156 pixel view tool 161 rectanglejq_9 _ resolution 163 selection region 160 shapes Drawing 158 tool ellipse 127 line 127 rectangle 127 bitmap BMP format 165 bold text changing to 14 spreadsheet 84 tool bar button 3 book reader 201 close 202 copy 203 find 203 open 201 print 204 b...

Page 250: ...heet 82 compression 166 continuous printing Spreadsheet 120 Converting text graphic 145 copy book reader 203 Copy tool drawing 127 copying Addressbook records 177 charts to another program 110 event descriptions Planner 192 Spreadsheet cells 95 formulas 95 text 11 dragging and dropping 11 correcting asyou type 8 COS angle function 228 COSH value function 228 COUNT valuel value2 function 217 counti...

Page 251: ... inside 149 scheduled events in Planner polygon 135 191 printing 163 styles Word Processing 34 rectangle 129 text Word Processing 10 redrawing the screen 133 dictionaly resizing objects 132 user editing 51 ruler units 150 Word Processing 49 rulers 150 selecting objects 131 diskette type 231 square 129 document star 135 creating 2 straight lines 134 exporting 64 text formatting 19 align 155 opening...

Page 252: ...ons 85 88 inserting 89 copying to adjacent cells 95 description 72 elements 85 entering 85 86 function within a function 90 inserting names 100 moving 94 naming ranges 98 operators 85 references 85 _ _ relative 86 __ _ relative references 94 show hide 98 _spreadsheet 85 values 85 frame tool drawing 127 functions 215 arguments 215 date OisO 226 keyword 215 logical list 220 mathematical list 222 pri...

Page 253: ... function 218 ISNUMBER value function 218 ISSTRING value function 218 italic text changing to 14 spreadsheet 84 tips for using 1 tool bar button 3 iteration Spreadsheet 101 key combinations selecting spreadsheet cells 71 L LEFT string num function 225 LENGTH string function 225 line modifying Drawing 139 tool drawing 126 line spacing WordProcessing 2O lines and borders Drawing object 136 locking r...

Page 254: ...xt changing to 14 spreadsheet 84 tool bar button 3 Planner creating new calendars 200 printing calendar 197 page size changing 197 repeating events 193 scheduled events adding 191 removing 191 scheduling events 90 particular time 192 searching events 196 viewing calendar switching 186 viewing events 187 PMT prineipal interest term function 216 point size relative style sheets 33 pointer tool drawi...

Page 255: ...g Addressbook records 179 events in Planner 196 searching text 18 SECOND time_value function 226 Select button 1 69 125 definitio_ 35 x selecting all tool drawing 127 text canceling a selection 9 extending a selection 9 keyboard 9 reducing a selection 9 tool drawing 127 shortcut keys redo 12 undo 12 SIN angle function 228 SINH angle function 228 skewing objects Drawing 143 SLN cost salvage life fu...

Page 256: ...other documents 35 SUM value 1 value2 function 222 SYD cost salvage life period function 217 symbols 12 T table of contents creating 48 tabs changing 23 creating _ _ deleting 23 displaying marks 58 key Word Processing 1 leader option 23 list option 22 position option 22 setting default stops 23 types 23 vertical line option 23 tag image file TIF format 165 166 TAN angie function 228 TANH angie fun...

Page 257: ...luel value2 function 224 VLOOKUP value range offset function 218 W WEEKDAY date_value function 227 wild cards searching with 18 Word Processing aligning text 1 bibliography 48 changing columns 30 color 15 counting words 58 deleting text 10 dictionary editing 51 em dash 1 finding and replacing text 17 fonts proportional 1 foo_otes __4_ _ i graphic frames 39 graphic layouts editing 45 headers and fo...

Page 258: ...___he_ Printed in USA Part Number US3475001 ...

Reviews: