OPEN OFFICE

DOWNLOAD FROM:  www.openoffice.org - "I Want To Download Open Office"

DOCUMENTS

TO START NEW DOCUMENT

1.  Double Click "Open Office" icon

2.  Click "Text Document"

3.  Start typing

TO SAVE AS WORD (.doc) DOCUMENT

1.  Click "File" then "Save As"

2.  Find desired folder, then type in new name of document

3.  Click down triangle to right of "ODT" in "Save As Type" line

4.  Click "Microsoft Word 97/2000/XP (.doc)"

5.  Click "Save"

TO OPEN DOCUMENT

1.  Click "File" then "Open"

2.  Find desired folder, then click desired file

TO SET MARGINS

1.  Click "Format" then "Page" then "Page"

2.  Change margins then click "OK"

BOLD, ITALIC, UNDERLINE, FONT, FONT SIZE

1.  Click, hold, and drag to highlight desired text

2.  On Toolbar at top, click "B" for Bold, "I" for Italic, "U" for Underline

3.  On Toolbar at top, click current font, scroll up or down, click desired font

4.  On Toolbar at top, click number next to font, scroll up or down, click desired size

TO PRINT

1.  Click "File"

2.  Click "Print"

SPREADSHEETS

TO START NEW SPREADSHEET

1.  Double Click "Open Office" icon

2.  Click "Spreadsheet"

3.  Start entering data

TO SAVE AS EXCEL (.xls) SPREADSHEET

1.  Click "File" then "Save As"

2.  Find desired folder, then type in new name of spreadsheet

3.  Click down triangle to right of "ODS" in "Save As Type" line

4.  Click "Microsoft Excel 97/2000/XP (.xls)"

5.  Click "Save"

TO OPEN SPREADSHEET

1.  Click "File" then "Open"

2.  Find desired folder, then click desired file

TO CHANGE COLUMN WIDTHS

1.  Place mouse arrow on line to right of desired column letter at top of spreadsheet

2.  When double-arrows appear, click and hold mouse button, and drag left or right

3.  Release when column is at desired width

CALCULATIONS AND FORMULAS

Always start formula with "="

"+" = Add     "-" = Subtract     "*" = Multiply     "/" = Divide

Use Cell Address (Column Letter and Row Number)  Ex:  =C5+C6

Formulas:

            =SUM(start,end)  to total column or row                             Ex:  =SUM(C3:C20)

            =AVERAGE(start,end)  to average a column or row        Ex:  =AVERAGE(C3:C20)

[CLICK HERE to download printable Word version]

Updated
10/3/2012