Page 1 NB-80C Word Processing, Spreadsheet, Drawing, Scrapbook, Addressbook, Planner Book Reader, Text File Editor, Games & Glossary _GEOS ® US ENGLISH...
Page 2 € AbOut this Manual In this manual, Book 2, look for information on these desktop publishing, personal planning, and electronic accessory programs: Creates, • Word Processing. edits, ,and prints documents, such as memos, letters, and reports. • Spreadsheet. Creates and edits Spreadsheet documents, performs calculations,...
Page 3 States of America and other countries. Mastersoft is a registered trademark of Mastersoft, Inc. in the U.S.A.- Copyright© 1997 by Brother International Corporation. All rights reserved. Black & white clip art images in this product are licensed from Media Graphics...
Page 4 • Consult the dealer or an experienced radio/television technician for help (changes or modifications not expressly approved by Brother International Corporation could void the warranty) RJllC/W This product uses jacks and is designed to connect to the telephone...
Page 5: Table Of Contents
Table of Contents THE BASICS 1 Word Processing Word Processing 13ps ..............Starting Word Processing ............. Opening a Document ..............Using the Tool Bars ..............The Basic Functions Tool Bar ............The Advanced Functions Tool Bar ........... The Graphic Bar ..............The Drawing and Bitmap Tool Bars ..........
Page 6 Wrapping Text ..............Inserting, Appending, and Deleting Graphic Layouts ......... Finishing Your Document ............Using Footnotes ..............Creating a Table of Contents ............Creating a Bibliography ............Proofing Your Document ............Checking Your Spelling ............Creating a User Dictionary ............
Page 7 Creating Notes ..............Changing the Appearance of a Spreadsheet ..........Adjusting Column Width and Row Height .......... "82 Changing Alignment ............. Using Different Text Styles ............Working with Formulas .............. Entering Formulas ..... : ......... Using References in Formulas ............. Using Operators in Formulas ............
Page 8 Exporting and Importing Spreadsheets ..........Spreadsheet Error Codes ...................... 3 Drawing Starting Drawing ..............Opening a Document .............. Using the Tools ..............Drawing Tools ..............Bitmap Tools ..............Pointers ............... Creating and Editing Simple Objects ..........Selecting Objects ..............Resizing Objects ..............
Page 9 Printing or Faxing Drawing Documents ..........Importing and Exporting Graphics ..........4 Scrapbook ........Starting Scrapbook ..............Using 'Scrapbook Documents ............Placing and Deleting Clip Art and Other Scraps ........Navigating Through Scraps ............: Naming a Page of Scraps ............Creating a New Scrapbook Document ..........
Page 10 Copying Event Descriptions ............Scheduling Repeating Events ............. 193 • Changing a Repeating Event ............. Removing a Repeating Event from the Calendar ........Finding Specific Events ............Printing or Faxing Planner Documents ..........Creating New Calendars ............ELECTRONIC ACCESSORIES 7 Book Reader ........
Page 11 APPENDIX Spreadsheet Built-in Functions ......Argument Rules ..............Fina_idal Functions ..............Information Functions .............. Logical Functions ..............Mathematical Functions ............Print Functions ..............Statistical Functions ..............String Functions ..............Time and Date Functions ............Trigonometric Functions ............Glossary ..........Index ..........Contents vii...
Page 12 Contentsviii...
Page 13: Word Processing 13Ps
Word Processing Before starting, review This chapter explains how to create almost any type of document. It also these basic procedures explains how to write a form letter and merge it with names and addresses from the Getting Started from Addressbook or Spreadsheet.
Page 14: Starting Word Processing
Starting Word Processing • To create a new document: By default, the Word 1. Click on Word Processing from the Main Menu. The New/Open dia/og box Processing icon is appears. automatically sel_cted 2. Click on New. A new Word Pr_essing document appears.
Page 15: Using The Tool Bars
Using the Tool Bars The tool bars provide quick access to menu functions. In Word Processing, you can open five different tool bars: Basic Functions, Advanced Functions, Graphic Bar, Drawing Tools, and Bitmap Tools. • To open a tool bar: 1.
Page 16: The Advanced Functions Tool Bar
The Advanced Functions Tool Bar When opened, the Advanced Functions tool bar appears above the Basic Functions tool bar. °.." 0 n.. Zoomin Find andreplace Stylein use Zoom st°reStyle tofit i R_cal,Style Hyphenation Scale ol t I1_1 kZ!l'_l . o,m.,"1 I-I=1=1-1 Alignment Linespacing...
Page 17: The Drawing And Bitmap Tool Bars
The Drawing and Bitmap Tool Bars In Word Processing, the Drawing tool bar appears on the left of the window When you are working with this tool bar in Word Processing, remember Pointer tool following: I-beamtool I'_ • To select a graphic.in Word Processing,...
Page 18: Beginning A Document
Beginning a Document Before typing, first define the type of document you are creating by setting your page size and page setup options. Setting uP Your Page To select the page size: You can create a 1. Open a new document.
Page 19: Working With Text
The columnsettingistwo. Thissampledocument is set up with 2 columns,0.25inch spacing between columns,and a vertical rule(line)between columns. The verticalrule is 2 Working with Text This section explains how to enter, move, copy, and edit text. It also describes to insert characters and symbols, change text style and format,...
Page 20 !l_ To go to another page: You can also select a Select Go to Page from the View menu. If your document has more than page to go to from the page, tbe page you select appears, lf your document begins on a page other Basic Functions tool...
Page 21 • To select text with the keyboard: Press the keys shown below: Press This To Select SHIFT + --* or _- One character in the direction of the arrow; reduces or extends one' character at a time in the same direction. CTRL + The current word;...
Page 22: Deleting Text
Deleting Text When you cut a • To delete text: selection, it is placed 1. Select the text you want to delete. on the cl_board. CUT. 2. Press You can paste the selection from the clipboard to another • To delete text using the keyboard: location as long as you have not cut or With no text is selected,...
Page 23: Dragging And Dropping Text
To copy a selection: 1. Select the item or text you want to copy. COPY. The 2. Press item remains in your document and aLso goes to the clipboard, replacing other item in the clipboard. 3. Move the insertion point to the location where you want...
Page 24: Usihg-U_Do_To Reverse-Your Last
Using Undo to Reverse Your Last Action Sometimes you may delete some text or change the way it looks and replaces contents of the clipboard immediately decide that it was not what you wanted. If you have not done so that even Undo wi/I anything else, select Undo from the Edit menu to restore the text.
Page 25 Fill in the dialog box: • Character Weight (%). Select the weight of the characters. Select any weight from 75 to 125. • Character Width (%). Select the width of the characters. Select width from 25 to 200. • Character Spacing.
Page 26 If all the highlighted • To change the text size: text is the same size, 1. Select the text to change. the currentsize is identifiedby a filled Select Sizes from the Character menu. A submenu appears. radio button in the Select one of the sizes from the list.
Page 27: Using Tone In Text
Aligning text You can decide how text lines up along a margin: left, centered, right, and iususqear. -- Alignedwith leftside of the margin -- Alignedwith rightside ofthe margin Centeredbetween sides ofthe margin Rushagainstbothsidesof the margin(justified) _ To change text alignment: 1.
Page 28 Fill in the dialog box: • % Shade_ Select the percent shading for the text tone. The lower the number, the more faded the tone. A setting of zero (0) causes the text to disappear. By default, this setting is 100. * Tone Tools.
Page 29: Finding And Replacing Text
Finding and Replacing Text Use Find and Replace to quickly find a word or phrase in your document and, ff you like, to replace it with a different word or phrase. You can also replace all occurrences of a word or phrase in a document. Searching for text You can search for any sequence of numbers,...
Page 30 Replace all occurrences of the search text with the replacement text. To do this, click on Replace All. A dialog box appears asking if you want to rep/ace a/! occurrences. Click on Yes to continue or No to quit. Replace in Selection is the same as Replace All, except that it replaces all occurrences only within selected text.
Page 31: Formatting Documents
• Graphic or Special Text. Adds a character to search for any graphic object or any special text character (dates, times, numbers, and so on) to the Find text. Adds Replace • Tab. a tab character to the Find or With text.
Page 32: Setting Line Spacing
Setting Line Spacing Line spacing is the space between lines in a paragraph, also called geadmg. Linespacingis the spacebetween linesin a paragraph... To add more space between the lines of text in a paragraph, select from the following line spacing settings: •...
Page 33: Using Indentations, Tabs, And Rulers
• To change spacing between paragraphs: 1. Select one or more paragraphs to change. 2. Select Paragraph Spacing from the Paragraph menu. A dialog box appears. 3. Fill in the dialog box, selecting the options you want: • Space On Top. Select the spacing above a paragraph. •...
Page 34 3. Fill in the dialog box, selecting the options you want: • Left Indent of Fu'st Line. Select the distance of the first line from the left margin of the page. • Hanging Left Indent. Select the distance of the text from the left Hanging indent margin of the page.
Page 35 • Tab Type. Select the alignment of the text at the tab setting (Left, Center, Right, or Decimal). For example, use a decimal tab to align. columns of numbers along the decimal point. Tab Leader. Select the character that precedes the tab setting (None, Dot, Line, or Bullet).
Page 36 Using rulers When you open a new document, the margins are set for a 6-1/2 inch text area and the tabs are 1/2 inch apart. Use the ruler to change right and left indentations and to insert different tabs. Ruler changes do not The indentations and tabs on the ruler affect the paragraph containing...
Page 37: Adding Borders
Adding Borders You can place a border (lines or a box) around a paragraph to add emphas_. The border extends to the edge of the left and right indentation marker. You can also set the border tone to set it apart from other text. •...
Page 38: Setting Hyphenation
4. Fill in the dialog box, selecting the options you want: • % Shaded. Select the percent shading for the border tone. The lower the number, the more faded the tone. A setting of zero (0) causes the border to disappear. By default, this setting is 100.
Page 39: Using Headers And Footers
Using Headers and Footers A header contains anything (text, graphics, or both) that you want to appear at the top of every page. Likewise, a.footer contains anything you want to appear at the bottom. Here are some of the things you can put in headers and footers: •...
Page 40: Creating A Title Page
• Date of Printing. Click to put the date of printing at the insertion point. Crick on Close. The document page reappeews with the beader or footer you created. l_ To change the size of a header, footer, or body text region: Layout 1.
Page 41: Using Page Breaks
I_ To delete the title page: 1. Select Title Page from the Layout menu. A submenu appears. 2. Select Delete Tide Page from the submenu. A dialog box appears asking if you are sure you want to delete the title page. 3.
Page 42 To set up multiple columns, specify column options in the Page Setup dialog box (from the File menu). When you set multiple columns, specify number of columns, the gutter (or spacing) between columns, and the width of any vertical rule(s) (the lines in between the columns).
Page 43: Using Text Style Sheets
4. Click on Apply. 5. Click on Close. Using column breaks To force Word Processing to move text to the top of the next column, press CTRL + ENTER to insert a hard page break and create a new column. Using Text Style Sheets A style is a collection...
Page 44 4. Select the style, scrolling the list if necessary. Word Processing applies style formatting to selected paragrapbs. 5. Click on the window control button in the top left comer to close dialog box. Storing and recalling text attributes tempor=;rily You can temporarily store the text and paragraph attributes...
Page 45 You can also define l_ To define a new style: a new style without 1. Select a paragraph for which you would like to change the style. Word using a base style. Processing uses the attn'butes in the selected (or base) style to define Word Processing uses _e default initial...
Page 46 • To update a style: 1. Select a paragraph in the style you want to change. 2. Set any character and paragraph attributes you want for this style. 3. Select Text Style Sheets from the Paragraph menu. A submenu appears. 4.
Page 47 Click on Delete. Word Processing deletes the selected style. Word Processing attaches the base style to any paragraphs in the style you just deleted. of those paragrapbs Houmm_, Word Processing does not apply the attributes with the attributes in the base style. Click on Delete and Revert."...
Page 48: Using Master Pages To Design Documents
Using Master Pages to Design Documents Use master pages to specify information that repeats on each page of a document. For example, you might want a logo to appear on every page. Header......... region The maatarpage is a prototype of how text and graphics appear on every...
Page 49 • Redraw I)ooanent. Click on this button to refresh the screen implement any changes you have made. Make your changes to the master page. The changesyou can make include: • Adding any text or graphics you want to the header or the footer.
Page 50: Using Graphics In A Document
• To move a text region: 1. Select the text region you want to move. 2. Point to the move handle in the center, hold clown the Drag button, drag the text region to where you want it to appear. You can also select 3.
Page 51: Using Frames For Graphics And Text
Using Frames for Graphics and Text A graphic frame is a rectangle that frames text or graphics. You can fill a graphic frame with tone and paRems, change the tone and thickness of its border, and make text wrap around it, wrap inside it, or even flow right through it.
Page 52 • To create a graphic frame for text: 1. If the Drawing tool bar is not open, select it from the Show Tools Texttool submenu of the Options menu. Select the Text tool from the Drawing tool bar. l-Beam _ Place the insertion point in the document and drag to size the frame.
Page 53: Using Grids
delete a graphic frame: 1. Select the graphic frame you want to delete. Press DELETE. To_na graphic f rarno.,To set area attributes for a frame: set the area attributes. 1. Select the graphic frame. To a_ust the border of a frame, set He line Select Area Attributes from the Graphics...
Page 54: Using Clip Art In Documents
l!_ To set the grid spacing: 1. Select Grids from the Layout menu. A d_gg box appears. When you change the 2. Select the units of measure (Inches, Centimeters, Points, or Picas). By units of measure for the default, the units of measure are the same as the ruler setting. grid, you vwII find it 3.
Page 55 I_ To change the size of a graphic object: 1. Select one or more graphic objects you want to resize. You can also 2. Point to any handle, press hold down the Select button, and drag the change Ihe size by handle until the graphic object becomes...
Page 56: Wrapping Text
Press PASTE. You are asked if you want the graphic on the text layer or graphics lays. Wrapping Text Wrapping text means that text'can go outside or inside the borders of a graphic object. The following illustration shows examples: This text is wrapped tight .
Page 57: Inserting, Appending, And Deleting Graphic Layouts
Inserting, Appending, and Deleting Graphic Layouts To keep graphics and text together on the same page, use Insert, Append, and Delete. These functions allow you to insert or delete pages in between existing pages without changing the layout of the graphics and text on the existing pages.
Page 58: Finishing Your Document
Finishing Your Document This section explains how to put the finishing touches on your document: footnotes, a table of contents, and a bibliography. usingFootnotes A footnote is a reference or explanation that appears at the bottom of the page or in a footnote section at the end.
Page 59 l_ To create a footnote at the bottom of a page: 1. Select Show Tools from the Options menu; then select Drawing Tools. Drawing tool bar appears on the left of the screen. 2. Select the Text tool from the Drawing tool bar.
Page 60: Creating A Table Of Contents
Creating a Table of Contents Style sheets can help you create a table of contents for a document, which typically looks like this: ._11 R ..t • • )6 . • IS . • • t • ff • Dot tab leader iTabl_ oJ' C¢_t4ram PEt 1 Frtedomof Corm:t_nce m<lExpro_oct.
Page 61: Proofing Your Document
For example, create a style (such as Biblio) that is a hanging indented paragraph. Once you create this style, type the bibliography entry and apply the style to it. See page 31 for more information on creating and applying styles. Proofing Your Document Word Processing provides...
Page 62 • Check Selection. Checks only selected text. The first misspelled word (or word that is not in the dictionary) appears in the Change To box. 4. Select the action you want to take on this word: • Skip. Click on this button to ignore this spelling. •...
Page 63: Creating A User Dictionary
Creating a User Dictionary Use this feature when your document contains correctly spelled words not found in the dictionary, such as proper names or special terminology. can also delete words in the user dictionary. l_ To create the user dictionary: Open a Word Processing...
Page 64: Printing Or Faxing Your Document
I_ To use the Thesaurus: 1. Select Thesaurus from the Edit menu. A dialog box appears. 2. If you select a word in your text, its definition and synonym will automatically appear. Type the word and click on Lookup. If more than one definition for the current word...
Page 65: Merging Information From Other Programs
• To fax: 1. Select Send from the File menu. A subraenu appears. 2. Select Fax.A dialog box appears. 3. Select the Fax options and click on Fax. Merging Information from Other Programs When you print a Word Processing document, you can merge (combine) information...
Page 66: Setting Up The Merge Fields
Setting up the Merge Fields The merge document is created in Word Processing, and it contains text, graphics, formatting, and page layout. It also contains merge fields (for names, addresses, etc.) that correspond to the information in the data document. The merge fields have field names, which must match exactly the field names used in the source data document.
Page 67: Merging Addressbook Information
..=" : • ,= ..=" : "" ..P" " " P" : • F'_ " I" Putthe_d data fv !. il.)X Iv Iz ! = _-lllI_-_l fx IL IMI"I" lP le 1_) S _ lip ""_" laiIl¢lII.lalI, 1I I a/Ill I- ']°IN IIIll...
Page 68: Merging Spreadsheet Information
I!_To copy all records to the clipboard: 1. In Addressbook, select Other from the File menu. A submenu appears. Select Export Document from the submenu. A dialog box appears. Select Comma Separated Values format from the right. Give the file a name and click on Export to Clipboard.
Page 69: Printing A Merge Document
• Field names must be contiguous. (You cannot have an empty cell between field names.) Fill in the rows beneath the field names. (Each row will be used one at a time to create individual documents when merging.) l_ To copy the Spreadsheet merge data to the clipboard: Do not look the _lles 1.
Page 70: Spedal Effects
Special Effects Displaying Invisible Characters Youcan_day invisJ_le Imgsib_ c/_ur_ are characters that you type but do not normally see characters to see and on-screen, such as spaces, tabs, paragraph marks (carriage returns), page and e(ft whatyouhave column break marks, and section break marks. typed Forexample, y ou mightwant!olmowff This table shows the on-screen symbols that represent invisible characters:...
Page 71: Using Abbreviated Phrases
Using Abbreviated Phrases Use Abbreviated Phrase to quickly insert long phrases into your Woed Processing documents. For example, if you commonly use the phrase Chief Executive Officer, put it in the abbreviated phrase list with the abbreviation ceo. Then, whenever you want to inse_ the long phrase...
Page 72: Inserting Special Characters
Inserting Special Characters You can insert special characters in a document that display dates, times, numbers. Special characters are useful because they save you from typing calculating information. For example, if you want the current date in a letter template to be updated each day, use a special...
Page 73 Inserting a number (counter) Once you insert Word Processing keeps track of certain information in a document, such as • special numbers, you the current page number, or the number of pages. "[b display any of these cannot change their numbers, insert the appropriate special...
Page 74 Once you insort J_ To insert a special date: special dates you 1. Place the insertion point where you want to insert the date. cannol change their value; bSevalue 2. Select Insert Special from the Edit menu. A submenu appear_ depends on internal 3.
Page 75 Inserting special times Word Processing keeps track of time information, such as the current time the time a document was created, revised, or printed. To display any of these times, insert the appropriate special time character in your document, the format you want.
Page 76: Importing And Exporting Documents
Importing and Exporting Documents You can open documents created with other word processing programs importing them into Word Processing. Likewise, you can export a document from Word Processing to another word processing program. You can import from and export to the following word processing programs: Import and Export Programs ASCII or plain text...
Page 77: Spreadsheet
Spreadsheet Before starting, review Spr_beet makes calculations quickly and efficiently. You can use these basic procedures spreadsheets for keeping track of a budget or for creating presentations with from the Getting StaRed charts. chapter in Book 1: • Working with Documents •...
Page 78: Opening A Document
Edit Bar Activecell address. • \ • Thecelladdress oftheacbve cell. candickheretoenterthecontents oftheEditareaintotheactivecell. let, _ Ilxg._ca 4- D7 - E8 -1t" Editarea. • ="f-'=--'=" This,shows t hecontents o ftheactive Restorebutton.._.._ cell. Clickheretocancel t he changes youare currently e ntering inthe Editarea. Opening a Document I_ To open a new spreadsheet document:...
Page 79: Using The Tool Bars
Using the Tool Bars The tool bars in Spreadsheet provide quick access to menu functions. Like Word Processing, Spreadsheet contains five tool bars: Basic Functions, Advanced Functions, Graphic Bar, Drawing Tools, Bitmap Tools. I_ To open a tool bar: 1. Select Show Tools from the Options menu.
Page 80: The Advanced Functions Tool Bar
The Advanced Functions Tool Bar Use the Advanced Functions tool bar for more advanced menu functions like creating charts from spreadsheet data. Textalignment Zoomout Rnd andReplace ] Centered Right ] Zoomin Full N°rmalsize I (100%) cdum. I High_ow Delete Bar l I I Pie %:,nt I Charttypes...
Page 81: Moving Around In A Spreadsheet
Moving around in a Spreadsheet You can scroll through a spreadsheet by clicking on the scroll bars at the right of the screen or by using the keyboard. I_ To scroll using the keYboard: Use any of the following keystrokes to scroll through a spreadsheet:...
Page 82 Like individual cells, ranges have addresses. A range address consists of the address of the upper left cell, followed by a colon (:), followed by the address of the lower right cell. In the illustration on the previous page, the address for the selected range is B3:D13.
Page 83 • To select a cell using the keyboard: Use any of the following keystrokes to select a cell: • ARROW KEYS (t x _ x _ x ---). Selects the next cell in the direction of the arrow. • HOME. Selects the f'_t cell in the current row. •...
Page 84: Working With Values And Labels
Working with Values and Labels Build a spreadsheet by entering values, labels, andformu/as. Values. Values are numbers, for example, sales figures for the past four quarters. Dates can be entered /abe/.,. Labels are text; they are the titles or descriptive text that describe the as labels or as formulas, contents of rows and columns, for example, First Quarter, Second Quarter,...
Page 85: Notes On Entering Labels
Notes on Entering Labels If you enter a label wider than the cell, it spills over into the next cell to the right as long as that cell is empty. If the cell to the right is full, the text appears cut off.
Page 86: Changing The Number Format For Values
Changing the Number Format for Values When you enter a value, Spreadsheet automatically shows it in a standard format; however, you can change the format to suit your needs. following table shows the available formats for values: Format You Type... Spreadsheet Displays 1234567...
Page 87: Entering And Changing Dates And 1Imes
• To change the format of values: 1. Select the cell(s) containing the value(s) whose format you want change. 2, Select Number Format from the Properties menu, A dialog box appears: NumdberFormat Sel_taformathem. Spreadsheet d isplaysan exampleof theselected formathere. 3. Select the format you want from the Formats list, An example...
Page 88 Entering dates and times as formulas Dates entered as formulas are stored as serial numbers representing number of days since January 1, 1900. For example, January 1, 1993 would stored as the number 33969. When a date is stored as a serial number, you can use Spreadsheet to change its format automatically.
Page 89: Format Formulas
Format Formulas When you enter a date or time value as a formula, Spreadsheet initially displays a number;, however, you can change the format to suit your needs. The following table shows the available date and time formats: Format i Example Date : Long 23456 = Saturday,...
Page 90: Formatting Spreadsheets
Formatting Spreadsheets Formatting options do not affect calculations; instead, they allow you to change the appearance of a spreadsheet. This section describes how to do the following: * Show and prim grid line_ • Display cell borders • Create headers footers •...
Page 91: Using Headers And Footers
Using Headers and Footers Headers and footers are the text that pdnts at the top or bottom of each page. They can be as simple as the page number, or they can include more descriptive information, such as the following: Enter header and •...
Page 92: Using Tones
Using Tones To add interest to your spreadsheet presentation, use tones or shades of gray for the following elements in a spreadsheet: • Text • Background • Cell borders • To change the text tones: 1. Select the cells that contain the text to which you want to apply...
Page 93: Creating Notes
Fill in the dialog box: • % Shaded. Select the percent shading for the text tone. The lower the number, the more faded the tone. By default, this setting is 100. If Unfdled is selected, this attribute is set to zero (0). •...
Page 94: Changing The Appearance Of A Spreadsheet
Changing the Appearance of a Spreadsheet You may want to change the appearance of a spreadsheet to improve its presentation. For example, you might want to emphasize certain aspects with a different text style or alignment. This section explains how to do the following: •...
Page 95: Changing Alignment
I_ To set a column width exactly: 1. Select the column for which you want to set the width. To do so, you can' either click on the column header or select a cell in the column. 2. Select Column Width from the Cell menu.
Page 96: Using Different Text Styles
Using Different Text Styles Using different text styles can highlight important information and improve the overall appearance of a spreadsheet. You can change the text style for You can apply more any cell or range of cells in your spreadsheet, whether they contain labels, than one style to your values, or formulas.
Page 97: Working With Formulas
Working with Formulas Spreadsheet uses Formulas describe calculations you want Spreadsheet to perform. When you floating point math, start to use formulas, you see the power of a spreadsheeL Each time you which has benefits such change the contents of a cell anywhere in your spreadsheet, Spreadsheet as speed.
Page 98: Using References In Formulas
)_ To enter a formula: 1. Select the cell in which you want to enter the formula. equal sign appears 2. Type - to begin the formula. in the Edit Area_ Click on the first cell you want to use in the calculation. Tbe cell address appears in the Edit Area.
Page 99 Absolute references An absolute reference tells Spreadsheet the specific address of a ceg. An absolute reference is like telling someone your exact address: 3628 Sixteenth Avenue. When you copy a formula from one location to another, Spreadsheet O.OS does not adjust absolute references. Use an absolute reference when you want to refer to the same cell, regardless of where you may copy the formula...
Page 100: Using Operators In Formulas
Using Operators in Formulas type of Notice that percentage Operators describe calculation you want to perform, is a form of example, addition or subtraction. The following table shows the operators muttip/ication, you can use in formulas. To use the Operator Description Example exponentiation...
Page 101 To specify arguments, use a list of values, separated by commas and enclosed in parentheses. If the values are in cells, you can list those cells as the arguments. For example, to sum the numbers 2, 3, 5, and 6 enter SUM(2,3,5,6).
Page 102 3. Select the function from the Functions list on the fight. You can select function type from the list on the left so that the Functions list shows only functions of the type you select. 4, Select Paste Arguments (the default) ff you want to insert placeholder arguments...
Page 103: Spreadsheet's Built-In Functions
Spreadsheet's Built.in Functions Spreadsheet provides the following built-in function types: • Financial • Information • Logical • Math • Print • Statistical • String • Time and Date • Trigonometric When you select Insert Function from the Formula menu, a dialog box appears with a list of these function types on the left and the built-in functions...
Page 104 Logical functions The logical functions evaluate relationships and return true or false results. For example, the IF function looks at a condition, such as whether the contents of B13 = 500, and returns a true or false answer (true=l, false=0). Mathematical functions Mathematical...
Page 105: Editing The Spreadsheet
Editing the Spreadsheet After you have created a spreadsheet, you may want to make some changes. This section describes how to do the following: Edit the contents of a cell • Copy and move information in a spreadsheet • Insert and remove rows and columns •...
Page 106: Copying And Moving Information
You may want to l_ To delete the contents of cells: delete information 1. Select the cell or range of cells whose contents you want to delete. using Cut from the Edit menu; that way, if DELETE. The Press coments of the cell or range are permanently deleted.
Page 107 Copying to adjacent cells Fill Right and Fill Down provide a handy shortcut when you want to copy contents of the active cell across a row or down a column. This is useful when you want to copy formulas. When copying formulas, Spreadsheet automatically adjusts the relative references.
Page 108: Inserting And Deleting Rows And Columns
Using Drag and Drop You can over, de the Use drag and drop to move or copy cells in your spreadsheet. Drag and drop default drag and drop by works the same way in Spreadsheet as it does in other programs.
Page 109: Filling A Range Of Cells With Incremental Values
Filling a Range of Cells with Incremental Values Using Fill Series from the Cell menu, you can automatically fill a range of ceils with a series of incremental values. Select the range of cells and specify starting value and the increment. Spreadsheet does the rest.
Page 110: Options For Spreadsheet Formulas
Options for Spreadsheet Formulas This section describes to do the following: • Show and hide formulas • Assign names to cells for'formulas • Turn automatic recalculation on and off • Use circular references and iteration in calculations Showing and Hiding Formulas To see a formula for a single cell, select...
Page 111 Define a name that refers to a specific cell or range. For example, you might define RATE as A3; then, when entering formulas, you can type RATE instead of typing A3. To define a name: 1. Select Define Name from,the Formula menu. A dialog box appears with a list of any names you bare previously defined.
Page 112: Controlling Automatic Recalculation
Once you have l_ To insert a name in a formula: defined a name, 1. Select a cell and begin entering a formula. you can usa it in any formulas you 2. When the insertion point in the Edit Bar is in the position for the name create.
Page 113: Using Iteration And Circular References
l_ To turn automatic recalculation on or off: 1. Select Calculation from the Options menu. A dialog box appears. 2. Select Automatic or Manual to specify the type of calculation you want. 3. Click on OK. 4. Click on Close. You can also !_ To recalculate manually:...
Page 114: Charting In Spreadsheet
Click on OK. Click on Close. Create the formula with a circular reference. Spreadsbeet recalculates formula the specified number of times or stops when the stated value for maximum change is calculated. Charting in Spreadsheet Spreadsheet lets you create a variety of charts that represent numeric...
Page 115: Types Of Charts
If you must use a Chart Tide. The tide of the chart. This label is optional. If you do not place number for the chart any text in this cell, the chart will not be tided. You can tide it later using the- title, sedes name, or Titles and Legends choice on the Chart menu.
Page 116 Stacked Percentage. The columns in each category are stacked that the total height represents 100%. The height of each value shown as that value's percentage of the whole category. This is like a vertical pie chart. One Tone With Values. Columns all have the same tone and are labeled with their numcric values.
Page 117 Matkea-s Only. Draws only the markers for each point; does not connect the markers with lines. Drop Lines. Draws the markers for each point, and then connects the points in each category with a vertical line; does not draw lines connecting the values.
Page 118 X-Y Plot chart An X-Ypiot chart, sometimes called a scauerp/ot, looks similar to a line chart, but there is a significant difference between the two. Une charts plot a value against a label (see the line chart on page 104), whereas X-Y plot charts plot one value against another.
Page 119 High/Low chart A high/low chart is useful for tracking pairs of data that mark a high and low or a start and end value, such as the price of stocks or the day's temperature range. Each pair of data points is plotted as a single vertical...
Page 120: Creating-Charts
Creating Charts Once your labels and _1_TO create _1 chart- data are in place on the spreadsheet, spreadsheet, you can 1. From a select the cells that contain the data you want chart. create charts using either the ChWts menu Open the Chart menu and select a chart type from the Create submenu.
Page 121: Manipulating Charts
Manipulating Charts The procedures in this When you create a chart, it appears with small black boxes around the section explain how to perimeter and a diamond-shaped spot in the center. These band/_s indicate perform basic the chart is the currently selected object. operations with graphic objects.
Page 122: Changing Chart Properties And Attributes
Changing Chart Properties and Attributes Attributes are visual elements such as tone, line thickness, and fill pattern. If you select a chart and then click one part of it, such as a wedge of a pie chart, you can change the attributes of that part of the chart.
Page 123: Adding Titles And A Legend
Adding Titles and a Legend • To add titles and legend to a chart: Select the chart. Select Titles & Legend from. the Chart menu. A dialog box appears. Fill in the dialog box, selecting the options you want: • Chart Title.
Page 124: Changing Markings
Enter the new text. When you are finished with the Text tool, select the Pointer tool from the Pointertool Drawing tool bar and click on an empty area of the chart to remove Open the Drawing tool bar outline around the text (so that other changes are not accidentally...
Page 125 • To add axis markings to a chart: 1. With the chart selected, choose Axis from the Chart menu. The Axis dialog. box appears. 2. Select the type of axis markings you want and click on Apply. The markings appear in your chart. The following illustration shows a chart with tick marks along the X Axis: 1i¢kmarks Click on Close.
Page 126: Changing Marker Shapes
Changing Marker Shapes Marker Markers show the data points on a chart. They are found only on X-Y plot and line charts. Changing the shape of the markers can help make the chart easier to read. I_ To change the marker shape: 1.
Page 127 * SHIFT + ENTER. Moves the active cell up one row. • TAB. Moves the active cell fight one column. • SHIFT + TAB. Moves the active cell left one column. Spreadsheet sorts all selected cells by the Select Sort from the Edit menu. A dim_g box appem's. row or column containingthe active Fill in the dialog box:...
Page 128: Creating Number And Date Formats
Creating Number and Date Formats While Spreadsheet offers a wide variety of standard number and date formats, you can create additional number and date formats to suit your needs. example, if you want to show values with six decimal places, you can create a special format.
Page 129: Using Rulers
• To delete a number or date format that you created: 1. Select Number Format from the Properties menu. A dialog box appears. 2. Select the format to delete and click on Delete. You are asked if you really want to delete the format.
Page 130: Locking Titles
Locking Titles Lock Tides in the View menu locks specific rows or columns of a page on-screen as tides. When you scroll the page, the tides remain fixed on-screen while the rows below (or to the right) scroll as usual. •...
Page 131: Printing And Faxing
Information you paste into other programs is not automatically updated. Therefore, if you change the spreadsheet, you must recopy it into the Word Processing document if you want to keep the information in both documents" the same. • To use spreadsheet data in another program: 1.
Page 132: Printing And Faxing Spreadsheets And Charts
Select reduce Scale to Fit on One Page. this option if you want your spreadsheet to fit on a single page. If your spreadsheet is too large, it may be reduced so much that you cannot read it. Continuous Printing. Use this option ff you want your spreadsheet print...
Page 133: Exporting And Importing Spreadsheets
• To fax: 1. Press PRINT. A submenu appears. 2. Select Fax. The Fax Document dt2dog box appears. 3. Select your fax options and click on Fax. • To print a chart: 1. Make a note of the cells that the chart either completely or partially covers (you will use this note in step 5).
Page 134 For more information 5. Select the folder where you want to save the exported f'tle; then enter a about DOS file name for the exported tile. The correct extension already appears in this names, see Naming a box, so you do not need to enter it.
Page 135 10. Click on Done. The dialog box disappeam. 1"beExport Document dialog box remains. 11. Click on Export. 12. Name the document and press ENTER. After a few seconds, the information mcpom. l_ To import a Spreadsheet document from Lotus 1-2-3 or Comma Separated Value forrnat:...
Page 136: Spreadsheet Error Codes
Spreadsheet Error Codes The following describes the error codes in Spreadsheet. These appear inside a cell when an error occurs. Explanation Error Codes #OVRFLW# Formula has a division by zero or division by an empty cell. Correct formula entries. Cell too narrow to accommodate entry or formula results.
Page 137: Drawing
Drawing Before starting, review Drawing allows you to cream many types of designs, pictures, these basic procedures illustrations. After you create a.drawing, you can copy it into a Word from the Getting Started Processing or Spreadsheet document. You can also import and export chapter in Book 1: Drawing...
Page 138: Opening A Document
Opening a Document • To open an existing drawing document: For information on 1. Click on Drawing from the Main Menu. 1"beNew/Open dialog box appears. templates, see Using 2. Click on Open: Open an existing document. The Open dt2dog box appears. Templatesin Getting 3.
Page 139: Bitmap Tools
object tooL Cuts a selected from your drawing. Copy tool. Copies an object to the clipboard. Paste tool. Pastes the contents of the clipboard at the insertion point. Select All tool. Selects all graphics and text in a documenL Black handles appear around...
Page 140: Pointers
Pointers Select a drawing tool by clicking on it in the tool bar. When you move the on-screen pointer into the drawing area, it changes shape. This shape depends on the tool you are using and the location of the pointer. Pointer.
Page 141: Creating And Editing Simple Objects
Creating and Editing Simple Objects With Drawing, you can create objects from shapes or lines. Once created, can select, edit, and manipulate individual objects. You can also change (tone or pattern) or the _ (outline). Drawing offers two ways to create objects: with the drawing tools...
Page 142 ll_To create an unfilled object: Pressing CTRL as you Press CTRL while you hold the Select button and drag to create a shape. draw creates an unfilled When you release the Select button, the unfilled object appears: object when the defaultis set to filled, and it creates a filled object when the defaultis set to unfilled.
Page 143: Selecting Objects
3. Hold the Drag button and drag the line to a new location. I_ To add an arrowhead at the end of a line: Press CTRL while drawing a line. An arrowhead appears at tbepoint where you ended the line. 1.
Page 144: Resizing Objects
• To select all objects: To select all but a Press CTRL + I. Hand/esappeararound a!/the objects. couple of objects in your drav#ng,choose Select All from the Edit menu, then press CTRL, and clickon only those objectsyou want to deselect. Resizing Objects You can enlarge and reduce objects by dragging the resize handles.
Page 145: Changing The On-Screen View
Changing the On-screen View You may find it easier to draw by adjusting the on-screen view. For example, you can enlarge the view of an object (zoom in) to focus on free details. can also hide scroll bars or redraw the screen to clean it up.
Page 146: Advanced Work With Objects
Advanced Work with Objects In Drawing, you can change the appearance of objects in many ways. You can: • draw lines, arcs, and complex objects with the Create submenu; • set attributes to change the appearance of each object. • Drawmg Objects, Arcs, and Straight Lines shapes To create simple shapes like triangles or more complex...
Page 147 • To create a polygon: 1. Select Create from the Edit menu. 2. Select Polygons from the Create submenu. A dialog box appears: IPOItJIgOn_l_st:flg_. IlOept IIIP_II_I IlOOpt I[l_'_ The radii for a polygon Fill in the dialog box: represent the •...
Page 148: Setting Attributes
• Inner Radius. The inner radii of the star represent the radii of an ellipse that touches each of the star's inverted angles. The left box specifies the horizontal measure, and the right box specifies vertical measure, in point increments. The default is 40 points (about...
Page 149 Use these tools to change the attributes of selected objects. If no object is selected, use the tools to set the attributes of future objects you draw. Setting area attributes Area attributes apply to the area inside ellipses, rectangles, rounded rectangles, and arcs.
Page 150 • To shade an object: 1. Select one or more graphic objects to shade. 2. Click on the Area Shading tool. A horizontalpop-up menu appears. The option fim'tbest to the lej_ is 100% shading while the option farthest to the night is 0%, the same as an unfilled object.
Page 151 Changing arc attributes To create an arc, use the An arc is a portion of a circle (ellipse). Since a full ellipse is 360 degrees am tool from the Dra_ng around, a 90 degree arc is exactly one quarter of an ellipse; a 180 degree too/bat, is half of an ellipse.
Page 152 To shade a line: [I\=J 1. Select one or more lines or graphic objects. Click on the Line Shading tool. A borizonta/pop-up menu appe¢_. option farthest to the left is 100% sbading_ while the option farthest to the right is 0%. Select the shading you want.
Page 153: Transforming Objects
Transforming Objects You can transform an object to give it special visual effects such as flipping, scaling, rotating, and skewing (slanting). You can also undo transformation. Flipping Objects Use the Transform menu to flip objects left-to-right or top-to-bottom. This is useful for creating interesting...
Page 154: Rotating Objects
Rotating Objects To rotate an object, use the Rotate tool or select Rotate from the Transform menu, where you can select the exact degree of rotation. The selected object rotates around its center point You can also select multiple objects, and they will rotate around their respective center points.
Page 155: Skewing Objects
Skewing Objects vertically You can skew an object to make it slant horizontally at a precise angle. Select one or more objects that you want to skew. Select Skew from the Transform menu. The dialog box at the left appears. Skew Select the skew...
Page 156 I_ To duplicate an object: Shortcut: Press D to 1. Select the object you want to duplicate. Handles appear around the object. duplicate the selected 2. Select Duplicate from the Edit menu. The copo_d object appears with object(s); press P to bandies around it.
Page 157: Conver Tirtg't_ A Gra Phi C
Converting to a Graphic You can also group Converting to a Graphic is helpful when you want to manipulate text or a graphic objects and graphic to create special visual effects. For example, you could convert a text transformthem. object with numbers to a graphic;...
Page 158: Arranging Objects
Arranging Objects The Arrange menu provides several ways of controlling placement of objects in your drawing. Moving objects to the Front or Back Whenever two or more objects ovedap, you can place one of the objects behind the others or you can place it in front. I_ To move an object to the front or back: Select the object you want to move to the front or back.
Page 159 Moving one object !_ To move several objects: moves all the selected 1. Select the Pointer tool from the Drawing tool bar. objects.As you drag, an outlineof the objects 2. Place the on-screen arrow near the objects, hold the Select button, and followsyour motion, drag across the screen to make a box around the objects.
Page 160: Grouping And Ungrouping Objects
Nudge means to To nudge objects: move a small 1. Select the object or objects. amount. To nudge object(s) using the Select Move from Arrange menu. A submenu appears. keyboard, press 3. Select Nudge Left, Nudge Right, Nudge Up, or Nudge Down.
Page 161: Pasting Inside
Pasting Inside When you paste an object inside another object, Drawing combines them into a single object that you can manipulate as you would any other Drawing object. The boundaries of the outside object become the boundaries of the inside object.
Page 162: Using Rulers
• To nudge inside: 1. Select the object that contains the object or objects you want to nudge inside, 2. Select Paste Inside from the Edit menu. A submenu appears. 3. Select Nudge Inside. A submenu appears. 4. Select Nudge Left, Right, Up, or Down.
Page 163: Using Grids
Using Grids Drawing can position objects 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 align and size objects in a drawing. You can also change the spacing of the grid. You can also automatically snap (or position) objects...
Page 164: Using Text In Drawings
Press X or period (.) l_ To snap objects to the grid: to turngrid snapping 1. Select Grids from the Options menu. A dialog box appears. on or off onlyfor the next create, move, or 2. Select Snap to Grids. resize operation.
Page 165 • To enter and edit text in a text object: Use the basic text editing techniques available in all programs, including BACKSPACE and DELETE keys, and Undo, Cut, Copy, and Paste from the Edit menu. • To create text in different sizes: Select the Text tool.
Page 166: Changing Text Style, Size
Changin_ Text Style, Size Text sty/e refers to the way the type in each font appears: • Plain Text , • Bold • Italic You can combinestyles to create • Underlined Undedined. Bold Underlined./taiic Underlined.Bold Italic, and Bold Italic Underlined. and Subscript (e.g.
Page 167: Aligning Text
2. Click on the Text Shading tool. A hcrdzontalpop-up menu appears. • option farthest to the lej_ is 100% soading, while the option farthest to the right is 0%. 3. Select the shading you want. Drawing applies the shading to the selected text or text objects.
Page 168: Working With Bitmap Objects
Working with Bitmap Objects ,, , In Drawing, you can use three types of objects to compose a drawing: text objects, graphic objects, and bitmap objects. • A text objea is an object you create using the Text tool on the Attributes tool bar.
Page 169: Creating A Bitmap Frame
Creating a Bitmap Frame bitmapframe defines the outer bounds of a bitmap. Create a bitmap frame using the Frame tool or by drawing a bitmap shape using other bitmap tools. Use the Bitmap tools to change pixels in the object and manipulate bitmap by moving, resizing, or transforming it as desired.
Page 170: Drawing Bitmap Shapes
You can also create a bitmap frame by using the Bitmap tools to draw a bitmap shape (straight line, freehand symbol, rectangle, or ellipse) in a blank part of the drawing area. When you do this, Drawing creates a rectangular bitmap frame around...
Page 171 • To draw a straight line: 1. Select Line Attributes from the Attributes menu. A dialog box appears. 2. Select the line tone, shading, width you want. 3. Select the Bitmap Line tool from the tool bar. Thepointer changes crosshairs when you move it over the drawing area.
Page 172: Editing Bitmap Objects
Editing Bitmap Objects Once you create a bitmap, you can use the Bitmap tools to change pixels in the object, erase portions of it, and select all or part of the object to cut, copy, and paste. Whenever you use a bitmap tool in a bitmap object, the bitmap object becomes the selected object.
Page 173: Using Tone Or Fill Pattern In A Selected Area
Using Tone or Fill Pattern in a Selected Area It is a good idea to You can change the tone of a contiguous group of pixels using the Bitmap save your drawings Fill tool. Unlike the Fill tool for graphic objects, which fills the entire...
Page 174 • To display the Pixel View: 1. Select the Pixel View tool from the Bitmap tool bar. Thepointer changes to" a magnifying glass when you move it over the drawing area. 2. Move the on-screen pointer to where you want to change pixels;...
Page 175: Changing The Bitmap Color And Resolution
Changing the Bitmap Color and Resolution (monochrome and resolution can change the color format or color) number of dots, or pixels, per inch) of a bitmap. (the For example, if you want to reduce the storage and memory size of the object, change a 16-color...
Page 176 • To print a document: PRINT. A submenu appears. 1. Save your document; then press 2. Select Print. The Print d_/og box appears. 3. Select your print options; then click on Print. • To fax: PRINT. A submenu appears. 1. Save your document; then press 2.
Page 177: Importing And Exporting Graphics
Importing and Exporting Graphics You can import graphics into Drawing that were created with other drawing programs or are stored in other file formats. You can also export drawings When you import a you have created in Drawing. biffnap graphic, Drawing places it in the center of the of a series of dots...
Page 178 Select 0S/2 Device Independent Bitmap if you plan to use the exported file in an OS/2 program. Select Windows 2.x Device Dependent Bitmap if you plan to use the exported file in a Windows program with a version of Microsoft Windows earlier than 3.0. Select Windows 3.x'D1B if you plan to use the exported file in a program running with Microsoft Windows...
Page 179: Scrapbook
Scrapbook Before starting, review they Scrapbook is a place to store graphic objects and bits of text so that these basic procedures available for pasting into documents. It also allows you to place the clip art from the Getting Started that is supplied on diskette in a"...
Page 180: Using Scrapbook Documents
Using Scrapbook Documents Scrapbook is a place to store graphic objects and bits of text so that they are available for pasting into documents. You can also delete graphic objects text from your default scrapbook or any other scrapbook document. You can also navigate through a scrapbook...
Page 181: Navigating Through Scraps
II_ To copy from Scrapbook to other programs: 1. Go to the scrapbook page that has the scrap you want to cut or copy. 2. Press CUT or COPY from the function keys. 3. Exit Scrapbook by pressing EXIT. 4. Open the document in the program to which you are copying the scrap. 5.
Page 182: Naming A Page Of Scraps
Retrieving a deleted !_ To retrieve a deleted page: page restores the 1. Select Other from the File menu. A submenu appears. document to the way it was when 2. Select Discard Changes from the submenu. appe_zrs. you last saved it. All Click on Yes.
Page 183: Creating A New Scrapbook Document
Creating a New Scrapbook Document Before you create a l_ To create a new scrapbook document: new scrapbook 1. If you have a Scrapbook document open, select Close from the File menu. documen_ you must firstsave and close If you have unsaved changes in the current...
Page 184 • To import graphics or text from another program: 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.
Page 185: Addressbook
5 Addressbook Bo[om startir_, rmaew Addressbook is your electronic address and telephone directory. Use it to these bask: pmcE_uros store addresses and telephone numbers, as well as notes and email addresses. from the Getting Started You can also create multiple Ad_-essbook documents, for example,...
Page 186: Working With Cards
Working with Cards Addressbook documents are referred to as Addr_ssbooks, which contain a series of cards, or records, much like the cards in a real card file. Each card contains the name, address, phone numbers, and notes you enter for each person.
Page 187 I_ To add cards to your Addressbook: CTRL + TAB moves the 1. Click on New. Addressbook shows a blank card with the insertion point in" cursor from field to field. the index field. 2. If you are adding a card for a person, type the person's name in the index...
Page 188: Adding And Changing Phone Types
Adding and Changing Phone Types Each address card can have up to seven phone numbers in six standard categories: HOME, OFFICE, CAR, FAX, EMAIL, and ALIAS. Each card also contains a blank field so you can add one phone type. )_To add a phone type in the empty category:...
Page 189: Editing Cards
Editing Cards • To make changes in cards: 1. To make changes in cards, locate the card you want to change by clicking on the appropriate index tab; then clicking on Next until the card you want appears. 2. Select the text and replace it with new text, the same...
Page 190: Deleti Rds
Deleting Cards From time to time, you may want to clean up your Addressbooks by deleting cards you no longer need. • To delete a card from your Addressbook: 1. Flip through your cards until you find the card you want to delete. 2.
Page 191: Searching Through Cards
Searching through Cards Addressbook allows you to search all the cards. For example, you can search the cards to fred those containing a spedfic address. l_ To search for information on the cards: 1. Select Find from the Utilities menu. A dia/og box appez_: Selector deselectthese Find optionsto specifyfieldsin...
Page 192: Making New Addressbooks
Making New Addressbooks You may want to create other Addressbooks. For instance, you may find it easier to keep business contacts in one Addressbook and keep friends and family in another. Beforeyou create a II_To create a new Addressbook document: new Addressbook, 1.
Page 193 Curreat record - Address only. This option prints the address currently on screen for labels and envelopes. All records - Addresses and phone numbers. This option prints a list of the index fields, addresses, and phone numbers from all cards in your Addressbook.
Page 194: Importing A Document
4. Select fax options and click on Fax. Importing a Document You can import documents, such as mailing lists, from some database Spreadsheet programs and turn them into Addressbooks. You can import following: • CSV (Comma Separated Values) • Lotus 1-2-3 •...
Page 195: Exporting An Addressbook Document
In the SourceList,clickon a fieldnameto mapfrom a file. In the Destination List,clickon the Addressbook Thislist showsthepairsof fieldsyou havemapped. nameto whichyouwantto map. List= IC,ck here i ryou make an stake. Clickhere for eachfieldsyou haveselectedto map. 5. Select one field in the Source List and one corresponding field in the Destination List and click on Map.
Page 196 i_ To export an Addressbook: 1. With the Addressbook document open, select Other from the File menu. A • submenu appears. 2. Select Export Document from the submenu. A dialog box appears. Select the format for export. The file _xtension appears in the File Mask box, and...
Page 197: Planner
Planner Before starting, review Planner is an automated appointment book that combines a yearly calendar these basic procedures and scheduler in one program. You can create multiple Planner documents, from the Getting Started for example, to keep track of business appointments and another to keep...
Page 198: Viewing The Calendar
Viewing the Calendar The Calendar window always contains a whole year, January through December. Normally you see only one month at a time, which is the single month view. You can scroll the window to see the other months in the year, and you can change the year over which you are scrolling, but you never see more than one month at a time, The current day of the month is highlighted.
Page 199: Selecting And Viewing Events
Selecting and Viewing Events Like an appointment book, Planner keeps track of weekly meetings, importam appointments, and special dates. All of these are called events. Use events Planner to track important dates in your daily schedule and to schedule dates far in advance, like birthdays and vacations.
Page 200: Switching Between The Calendar Window And The Events Window
Switching between the Calendar Window and the Events Window You can view the Calendar window and the Events window side-by-side On the View menu, when both windows at a time. Showing only one window at a time lets you work with either are showing, the without...
Page 201: Selecting A Range Of Days And Viewing Their Events
Selecting a Range of Days and Viewing Their Events You can view a summary of events over a range of days. The following illustration shows an example: These arethedatesoverwhich. Clickto see events in the events are beingsummadzed. previousand next rangeof days. ,.,.., [r_-l rt'z _b41 1996...
Page 202: Scheduling Events
• This Quarter. Selects all days in this calendar quarter. The quaffers run January through March, April through June, July through September, and October through December. • This Year. Selects all days in this year. The selected range is bighh'gbted in the Calendar window, its events...
Page 203: Changing A Scheduled Event
Changing a Scheduled Event You can change the scheduled time for an event or the details in its description. I_ To change a scheduled event: When you change the time of a scheduled 1. In the Events window, locate the event you want to change.
Page 204: Adding An Event At A Particular Time
3. Edit the time if the one shown is not correct. Be sure the time you type is in the HH:MM format. For example, type 8:15 _a_ for a new time. 4. Press TAB or click in the description area, and then type a description. Adding an Event at a Particular Time You may want...
Page 205 Scheduling Repeating Events You might have events that happen regularly, such as a meeting every Thursday at 4:00. In Planner, you can schedule the event once. Planner then remembers to schedule these meetings for you every Thursday at 4:00. You can schedule an event that repeats in one of the following ways: Weekly.
Page 206 2. Click on New. Another dialog box appears: Chun_ aepeeU. 0 Ewt Type of [_ent- • Neekkj @ HunUdy O Veeritj [requenctj, @omj of _ek @nero s_pec_ry t_, Event 141flOccur Select _Detj(s)_ n Sun • Plon n Tuns • Ned [] Thu 0 Frl 17Set _ LaSt...
Page 207 6. If you are scheduling a yearly event, use the up or down arrows to select the month your event occurs. (Skip this step if you are scheduling monthly event.) 7. If you know the time of the event, type it in the Time box.
Page 208: Changing A Repeating Event
Changing a Repeating Event If your scheduled repeating event changes at any time, you can modify the event to reflect the new changes. • To change a scheduled repeating event: Select Repeating Events from the Utilities menu. A dialog box appears. Only unaltered Select the event you want to change from the list, and then click on occurrences of the...
Page 209: Printing Or Faxing Planner Documents
2. Type the text for which you are searching. Click on Find Next. The search starts on the current day and goes forward. • If no matches are found, you are asked if you want to search past events. 4. Click on OK. The first event that matcbes the search text appears highlighted...
Page 210 • To change Page Size options: 1. Select Page Size from the File menu. A dialog box appears: 2. Fill in the dialog box: • Type. Select paper, envelope, or label. • Size. Select the page size from the lisL •...
Page 211 From the drop-down list, select Month; then click on the up or down arrow to select a month. Select Year;, then click on the up or down arrow to select a year. You can also edit the number in the Year box. Select Events window.
Page 212: Creating New Calendars
Creating New Calendars Planner provides a standard document called My Schedule. Whenever you start Planner, this document opens, making it easy to keep all of your appointments in one place. If you keep just one calendar, you should use this document. You can create other calendars.
Page 213: Book Reader
Book Reader With Book Reader, you can open books supplied on diskette, such as Before starting, review directories of zip codes and area codes. these basic procedures from the Getting Started chapter in Book 1: When you open a book on diskette, you can scroll through it and move from •...
Page 214: Using Information And Text
Send. This tool opens a dialog box allowing you to send selected text to the clipboard or to the printer. lF'mdLThis tool OlXmSa dialog box with options about the information you want to find and how you want to find it. I_ To close a book: Select Exit from the Book menu.
Page 215 • To find information in a book: 1. Click on the Find icon at the bottom of the screen. The Find dfi2/og box appears: r- lrl 2. Enter the search term. Click on Find Next, Find Previous, Close, or Help. •...
Page 216: Printing From Book Reader
Printing from Book Reader The Print option is in the Send dialog box. You can send selected text to the prints print clipboard or printer. Selecting option the selected text or the current page if no text is selected. Be sure you have set up your printer (see Setting...
Page 217: Text File Editor
Text File Editor Text File Editor is a simple editing program that allows you to create, read, DOS is Disk Operating write, and edit DOS text files, also called ASCII text fries. Text File Editor is System. supplied on diskette. Starting Text File Editor Before starting, review Text File Editor...
Page 218: What Text File Editor Can And Cannot Do
What Text File Editor Can and Cannot Do Word Processing The following table lists the tasks that Text File Editor can and cannot perform. can perfom all of Text File Editor shares basic capabilities with Word Processing, such as spell the tasks listed in check.
Page 219: Printing A Dos Text File
Printing or Faxing a DOS Text File Before printing a Drawing document for the first time, review Setting Printer Options in Getting Started (Book 1). Also select page size options to reflect the actual size, layout, and _ that you want to prinL Before faxing...
Page 220: Naming A Dq
Naming a DOS Text File, DOS File Names. All documents created in Text File Editor are DOS text files. 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.
Page 221: Games
Games Before starting, review Two games are available: Turnabout, a game of strategy, and Solitaire, these basic procedures popular international card game for one player. Games are supplied from the Ge_ng Started diskette. chapter in Book 1: • Working with Menus •...
Page 222: Setting User Options
6. The system then places its next piece. Watch the board carefully because the action moves very quickly. 7. It is your turn again to place your next piece. Play continues until no more of the pieces can be capture_ The system keeps a running score of how many pieces each player has during the game.
Page 223: Starting Solitaire
Starting Solitaire 1. Insert the diskette labelled Solitaire in the disk drive. Click on File Manager from the Main Menu. File Manager appears. Click on the drive A icon at the bottom of the screen. The contents of the diskette appear 4.
Page 224: Finishing A Game
_ To undo a mistake: Select Undo from the Game menu. The card returns to its original iocmion. Finishing a Game You win Solitaire when you have flipped over all of the face-down cards, and played all of the cards in the deck. When this happens, the Auto Finish button changes from gray to black.
Page 225: Changing The Scoring
Changing the Scoring Solitaire has the following scoring options: Standard ('rimed) and Standard (LMtimed). In Standard (Timed), you lose points for the time you spend deciding where to move a card. In Standard (Untimed), you are not penalized for taking time to make decisions.
Page 226: Changing The Number Of Cards Drawn
I_ To change the scoring: 1. Select Scoring from the Options menu. A submenu appears. Select an option from the Scoring submenu. Changing the Number of Cards Drawn You can draw either one, two, Or three dards at.a time from the deck. choice you make affects...
Page 227: Spreadsheet Built-In Functions
. Appendix: • Spreadsheet Built-in Functions Bui/t-kzfunaions are prewritten formulas that take a value, perform a Spreadsheet uses floating point math, mathematical operation, and _turn a result. For example, you can use a which has benefits such built-in function to total a grotlp of fiumbers. as speed But floating point math produces...
Page 228: Fina_Idal Functions
Financial Functions The arguments for financial functions are either numbers or addresses of cells When the argument is the interest rate, enter its actual that contain numbers. value (for example, enter .07 or 7% rather than 7). Be sure to specify the same units for the term and the interest.
Page 229: Information Functions
Function Description SIN (cost;salvage,h'fe) Straight-line depreciation. Cost is the initial cost of the asset. Sa/vaooe is the value of the asset at the end of the time period. Life is the useful life of the asset, the number of time periods the asset is being depreciated.
Page 230 Function Description Returns a value from a horizontal lookup table, allowing you to use a spreadsheet HLOOKI_ (value, table like a database. HLOOKUPextracts from the horizontal rows, and VLOOKUP range, offset) extracts information from vertical columns. HI.OOKUPassumes the entries in the Fast row are sorted in ascending order.
Page 231 Information Function example: HLOOKUP HLOOKUP and VLOOKUP allow you to search for a value that is within a range of values. The table below is an example of a simple lookup table. This table tracks a discount rate, which is based on the number of units sold.
Page 232: Logical Functions
Logical Functions, The logical functions evaluate relationships and return true or false results. True= 1 (or nonzero values) and false = 0. A logical function uses a conditional statement; for example, if this is true then do that. An example of a lo[_ical function would be this conditional statement: if the value in B12 is larger than 10,000, then display 50 in this cell.
Page 233 BONUS= IF(SALES<IOOOO,.O2*SALES,.O4*SALES) For sales over $10,000, the bonus is 4%. The formula for such an IF statement shown in the box above is =IF(C4<10,000, 0.2 * C4, .04"C4) where the sales figure is located in cell C4. In this example, SALES<10000 is the condition you want to test, .0Z*SALF_ is the result you want ff the condition is true, and .04*SALESis the result you...
Page 234: Mathematical Functions
Mathematical Functions The arguments for mathematical functions are either numbers or addresses cells that contain numbers. The results of these calculations are always numbers. Function Description ABS (value) Absolute value of a number. Value can be a cell. For example, ABS(-12) returns £XP (mluO...
Page 235: Print Functions
Print Functions The print functions return the name of the file, the current page, and the number of pages with headers and footers when printing documents. Function Description FII.ENAME ( ) Returns the mename of the current file for inclusion in a Spreadsheet header or footer.
Page 236: String Functions
Function Description Standard deviation of a population. You can use as many t_dues as you want. STDP (valuel, value2,..) Simple variance of a sample population. You can use as many arguments as you VAR (valuel, want. value2, . .) Population variance of the values in a list.
Page 237 Function Description Returns the characters in the leftmost position in a string. Num is the number LEFT (string, hum) characters to return. The first character in the string is in position O. A reference cells containing values produces an error. The RIGHT function extracts characters beginning with the rightmost character,...
Page 238: Time And Date Functions
Time and Date Functions Spreadsheet uses serial numbers to represent times and dates. The serial numbers begin with 1 = January 1, 1900. The DATE and DATEVALUE functions return the serial number for a given date. Function Description DATE (year, month, Converts a numeric date (day,...
Page 239: Trigonometric Functions
Function Description Returns the current date (month, day, and year) in the serial number format TODAYO WEEKDAY (date Returns the number for the from the serial number format for date va/ue. The WEEKDAY returns a number representing the day of the week: 1 for Sunday, 2 for value) •...
Page 240 Function Description COS (angle) Returns the cosine of an angle, expressed in radians. If you know an angle degrees, can use the RADIANS function to convert it to radians. COSH (value) Returns the hyperix_lic cosine of a value. DEGREES Converts radials to degrees.
Page 241: Glossary
Glossary absolute reference - in Spreadsheet, a reference to a cen address based on its column and row number argument - in Spreadsheet, a piece of information you enter into a formula ASCH - American Standard Code for Information Interchange, a common exchange format...
Page 242 continuous printing - a Spreadsheet printing option that allows you to print a spreadsheet one continuous page control keys - the keyboard keys that modify the effect of the other keys. CODE, MENU & SHIFT are control keys. - Comma Separated Values format used in database and spreadsheet programs...
Page 243 file selector - the New Disk button and the scrolling list in dialog boxes for selecting a file, folder, or diskette fixed notation - a format option for numbers in which you set the number of decimal places that you want to appear, such as two decimal places:...
Page 244 header - a page element that appears at the top of each page. See footer. highlight - to select text or graphics to be able to work with that chosen item. Highlighted text has a black background, and highlighted graphics have square handles around them.
Page 245 legend- the part of a graph that uses text for explanation llne chart - a chart that represents values with points on an x-y axis, connecting the values with • straight lines line status - in Communication, the quality of the phone connection linear progression - a progression of numbers...
Page 246 pica - 1/6 of an inch or 12 points pie chart - a round chart that represents values as pieces of a pie pinning a menu - keeping a pull-down menu on the screen pixd - the smallest dot on the monitor screen pixd view...
Page 247 scrolling list - a box listing various items used in conjunction with a scroll bar such that you are able to see all the selections from which to choose select highlight an item using the on-screen pointer or keyboard. Selected items will darken - to Select button - the top button on a glidepad or left button on a mouse used to select an item on the screen.
Page 248 transform - a submenu item that contains the options flip, rotate, skew, and scale tmformatted diskette - a diskette that has not been prepared for saving documents. uniform resource locator (url) - the address of a document (web page) on the Intemet's World Wide Web user...
Page 249: Index
border Index ATAN(value) trigonometric function, 227 color, 25 customizing, ATAN2(x,y) trigonometric paragraphs, function, 227 shadow width, 25 ATANH(value) trigonometric spacing, 25 function, 227 abbreviatiotis for long phrases, types, 25 width, 25 AVG(value 1,value2,...) statistical function, 223 ABS(value) mathematical brush tool, drawing, 127 function, 222 built-in, formulas,...
Page 250 creating CODE, function (string), 224 Word Processing, a master page, 36 text appearance, 12 color Addressbook records, 174 text size, 13 background of text, 16 arcs, lines, objects, 134 user dictionary, 51 bitmap, 161 bibliography, CHAR(value) string function, Drawing, 136, 138 bitmap lines and shapes, 158 spreadsheet, chart legends, Spreadsheet,...
Page 251 bitmap text files, 205 inserting, 61 ellipse,127 longhand format, 60 drag and drop, 11 line, 127 numeric format, 60 Drag button, 1, 69, rectangle, 127 DATEVALUE(string) definition, 230 brush, 127 function, 226 copy, 127 dragging, definition, 230 crossed arrows DAY(date-value) function, Drawing diagonal, 128...
Page 252 changing style, 14 ERR() function, 217 proportional, Word error, Spreadsheet, Processing, games EXACT(stringl,string2) style and size, 154 Solitaire, 210 function, 224 footers Turnabout, 209 EXP(value) f_ction, creating GIF format, 165 Spreadsheet, 79" exporting graphic Word Processing, 27 Addressbook, adding, Spreadsheet, printing Spreadsheet, graphics attn_outes, Drawing, 136...
Page 253 insert, row/column, locking rows/columns, printing Spreadsheet, 120 Spreadsheet, spreadsheet, HLOOKUP(value,range,offset inserting, graphic layout, 45 logical ) function, 218 functions, list, 220 HOUR(time_value) function, insertion point, Word operators, spreadsheet, 221 Processing, logical functions, Spreadsheet, INT(value) function, 222 hyphenatioia maximumlines, 26 invisible characters, displaying, LOWER(string) function, 225 prefix, shortest, 26...
Page 254 PMT(prineipal,interest,term) MOD(value,divisor) function, page numbers function, 216 automatic, 27 inserting point size relative, style sheets, MONTH(date_.value) Spreadsheet, 79 function, 226 Word Processing, 27, 61 move, objects, 146 pointer, tool, drawing, 126, viewing current, 61 front to back, 146 viewing total number, 61 polygon radius option, 135 moving, text, 10, 11 PAGE() function, 223...
Page 255 spaces, displaying marks, 58 special scale to fit, Spreadsheet, character, 12 RANDOM() function, 223 bullet, 1 RANDOMN(value) function, scheduling, repeating events, em dash, 1 Planner, 193 searching for, 18 scheduling events_ Planner, RATE(futfirevalue,present_v times, document creation, 63 flue,term) function, 216 spell checking, 49 read, book reader, 202 scientific notation,...
Page 256 copying, 10 STRING(value,N) function, formulas, 72 cutting, 10 grid fonts, 13 description, 65 style sheets in drawings, 152 show/hide, 78 applying, 31 moving, 10 header, 65 changing format, 33 pasting, 10 headers and footers, 79 defining new, 32 style sheets, 31 incremental'values, deleting, 34 tool, drawing,126...
Page 257 VAR(valuel,value2,...) thesaurus, 51 basic functions, Spreadsheet, function, 224 title page, 28, 58 Bitmap, 156 tool bars, 3, 5 VARP(valuel,value2,...) Graphics, Word Processing, word wrap, 1, 7 function, 224 VLOOKUP(value,range, transforming objects, Drawing, offset) function, 218 trigonometric functions YEAR(datevalue) function, listing, Spreadsheet, WEEKDAY(date_value) TRIM(string)
Page 258 ___he_® Printed in USA Part Number US3475001...

This manual is also suitable for:

Geobook nb-60

Brother GeoBook NB-80C Instructions Manual

1 Word Processing 13Ps

2 Spreadsheet

3 Drawing

4 Scrapbook

5 Addressbook

6 Planner

7 Book Reader

8 Text File Editor

9 Games

APPENDIX Spreadsheet Built-In Functions

Quick Links

Related Manuals for Brother GeoBook NB-80C

Summary of Contents for Brother GeoBook NB-80C