Ottawa PC Users’ Group Beginner’s Workshop Word Processor and Spreadsheet Jocelyn Doire
Which Word Processor? There are lots of word processors available n Notepad and Word. Pad – Available with all versions of Windows – Limited set of features. n MS Word and Corel Word. Perfect – Need to buy them, usually as a Suite – Advanced set of features n Open Office (http: //www. openoffice. org/) – Free, open source code – Advanced set of features
Open. Office. org
Keys n n n n Writing a paragraph (wrap) Enter Up, down, right, left Space and tab Insert and Overwrite Delete and Back Space Home, End, Page Up, Page down Non-printing characters (ctrl-F 10)
Block Shift key + cursor keys n left mouse button and drag n Cut n Copy n Paste n
Attributes Bold n Italic n Underline n Left, center, right or justified align n Number and bullet list n Indentation n Font n
Tab Ruler bar n Left, center, right and decimal tab Left Center Right n Margin (grey bar at left and right) n Line Indent n – First line (top) – Paragraph (bottom)
Footer and Header n Header, Footer n Insert fields 1. Page number 2. Page count n Height, margin n Alternating text/position
Style Select text then style n Stylist (F 11) floating menu n Modify n Style type n – Paragraph – Character – Frame – Page – Numbering
Graphics Insert Graphics from file n Tool > Gallery n Wrap n – None, through, after, etc n Anchor – Page, paragraph, character n Edit graphic
Save and Load Save n Save as n Export n – PDF – HTML – Word, etc n Load
Print n Print Preview n Print range n Number of copies n Print Properties (printer specific) n Option n – Brochure
Auto Pilot n Auto Pilot – Memo, fax, web, form, etc
Help Shift F 1 n Content n Index n Find n Support n – FAQ
Spreadsheet Rows Columns Cell C 5
Columns & Rows Selecting a cell, a column, a row or a sheet, or a combination n Adjust column width with vertical bar n Adjust row height with horizontal bar n Optimal adjust: format, column, optimal width n Inserting one or more columns or rows n
Cell Formatting n Select a cell, column, row, etc, then click on format, cells, etc
Sorting n To sort data: – Select columns – Click on Data, Sort by…, direction – Select the options (include labels and don’t include formatting)
Floor Renovation Merging cells n Align: center, left, right n Format numbers: currency n Calculate: for example =B 3*C 3 n Function: for example SUM n
Floor Renovation
Investment Growth Copy cells with a value : Value Grow! n Copy cells with an address: cells address grow! n If a cell address should be constant, add $ n
Investment Growth
Investment Growth Chart To make a chart, select the area of interest, including the labels n Select Insert, chart, then go through all the choices n Click on any of the elements to edit it n
Investment Growth Chart
Questions & References n n http: //www. openoffice. org/ http: //support. openoffice. org/ http: //java. sun. com/j 2 se/1. 4. 2/download. html http: //opcug. ca/
Скачать презентацию Ottawa PC Users Group Beginner s Workshop Word Processor
dfc9af483bf2ea5a4a837de266fca06e.ppt