MS OFFICE 97 QUICK REFERENCE GUIDE

The MS Office 97 Quick Reference Guide, written by an experienced instructor in MS Office, provides an alphabetical, comprehensive, step-by-step summary of features for the following MS Office software programs:

• Windows 95 (or Windows 98)
  
• Access 97
  
• Excel 97
  
• PowerPoint 97
  
• Word 97 (Sample) (requires Word 6.0 or higher)
  

(Note: Quick Reference Guides are also available for Office 95.) The cost for the complete Quick Reference Guide is $16.95 (S&H and tax included). (Contact us at 250 727-2700 for information on volume discounts for orders over 25.)

The contents for each section is as follows:

WINDOWS 95 Top of Page

• Access Programs on Taskbar
  
• Activate Window
  
• Add File or Folder to Start Menu
  
• Add Printer
  
• Add Program to Desktop
  
• Add Program to Start Menu
  
• Arrange Icons
  
• Automatically Run Program
  
• Cancel All Print Jobs
  
• Cancel Print Job
  
• Cascade Multiple Windows
  
• Clear Document Menu
  
• Close Window
  
• Copy Disk
  
• Copy File/Folder
  
• Create Control Panel Feature Shortcut
  
• Create Control Panel Shortcut
  
• Create File Shortcut
  
• Create Folder
  
• Create Printer Shortcut
  
• Cycle Through Open Applications
  
• Date and Time
  
• Define Dialog Box Options
  
• Defragment Disk
  
• Delete File/Folder
  
• Desktop Colors
  
• Desktop Patterns
  
• Desktop Wallpaper
  
• Disk Properties
  
• Display Contents of Disk
  
• Display Contents of Folder
  
• Display Contents of My Computer
  
• Display File Type Icons
  
• Display Print Jobs
  
• Display Toolbar
  
• Double-click Speed
  
• Empty Recycle Bin
  
• File Properties
  
• Find File/Folder
  
• Format Disk
  
• Help-Contents
  
• Help-Context Sensitive
  
• Help-Exit
  
• Help-Find
  
• Help-Index
  
• List Disk Contents
  
• Maximize Window
  
• Menus-Keyboard
  
• Minimize All Windows
  
• Minimize Window
  
• Mouse Pointer Speed
  
• Move File/Folder
  
• Move Window
  
• Open Associated File
  
• Open Previously Used Documents
  
• Open Unassociated File
  
• Open Window
  
• Pop-Up Menus
  
• Refresh Display
  
• Remove Program from Desktop
  
• Remove Program from Start Menu
  
• Remove Program from Startup Menu
  
• Remove Shortcut
  
• Rename File/Folder
  
• Restore Window
  
• Run a Program
  
• Run DOS
  
• Run Program on Desktop
  
• Run Shortcut
  
• Sample of Fonts
  
• Screen Saver
  
• Screen Saver Password
  
• Select Files
  
• Set Default Printer
  
• Shut Down Windows 95
  
• Size Window
  
• Sort Files
  
• Start Application
  
• Switch Mouse Buttons
  
• Taskbar Options
  
• Tile Multiple Windows
  
• Undelete File/Folder
  

ACCESS 97 Top of Page

• Add Field-Table
  
• Align Control Boxes
  
• Align Text in Control
  
• Allow Zero Length
  
• AutoForm
  
• AutoForm Wizards
  
• AutoNumber Field
  
• AutoReport
  
• Caption
  
• Close Database
  
• Close Table
  
• Column Width
  
• Command Button
  
• Command Button-Delete
  
• Control Border
  
• Control Color-Text/Fill
  
• Control Font
  
• Copy Data
  
• Copy Database
  
• Copy Table
  
• Create Database
  
• Create Query
  
• Create Table
  
• Currency Field
  
• Data Type
  
• Date/Time Field
  
• Date-Report
  
• Decimal Places
  
• Default Value
  
• Delete Control-Form/Report
  
• Delete Database
  
• Delete Field-Table
  
• Delete Form
  
• Delete Query
  
• Delete Report
  
• Delete Table
  
• Display Database Information
  
• Display Datasheet
  
• Display Form Design
  
• Display Record
  
• Display Report Design
  
• Display Table Design
  
• Edit Cell Contents
  
• Edit Query
  
• Enter Data
  
• Exit Access
  
• Exit Windows95/98
  
• Expand/Compress Text Box
  
• Field Description
  
• Field Name
  
• Field Properties
  
• Field Size
  
• Filter by Form
  
• Filter by Selection
  
• Find Data
  
• Find Record
  
• Form Background Color
  
• Form Wizard
  
• Format Data
  
• Freeze Columns
  
• Header/Footer-Datasheet
  
• Header/Footer-Form/Report
  
• Help-Index
  
• Help-Office Assistant
  
• Hide Columns
  
• Indexed Option
  
• Input Mask
  
• Keep Record Together-Form/Report
  
• Label Name-Form/Report
  
• Labels
  
• Memo Field
  
• Move Columns
  
• Move Control-Form/Report
  
• Move Data
  
• Move Field-Table
  
• Number Field
  
• OLE Object Field
  
• Open Database
  
• Open Form
  
• Open Table
  
• Page Margins
  
• Page Number-Report
  
• Paper Orientation-Report
  
• Paper Size/Orientation-Table
  
• Parameter Value
  
• Print Preview
  
• Print-Datasheet
  
• Print-Form/Report
  
• Print Query Results
  
• Query Wizard
  
• Quick Report
  
• Redisplay All Records
  
• Rename Column
  
• Rename Database
  
• Rename Query
  
• Replace Cell Contents
  
• Replace Data
  
• Report Wizard
  
• Required Text
  
• Resize Control-Form/Report
  
• Row Height
  
• Run Access
  
• Run Query
  
• Save Filter as Query
  
• Save Design Changes
  
• Select Controls
  
• Sort Data-Datasheet
  
• Sort Data-Report
  
• Tab Order-Form
  
• Text Field
  
• Undelete Table
  
• Unfreeze Columns
  
• Unhide Columns
  
• Validation Rule
  
• Yes/No Field
  

EXCEL 97 Top of Page

• Absolute Cell Reference
  
• Adjust Print
  
• Align Center
  
• Align Left
  
• Align Right
  
• AutoFill
  
• AutoFormat
  
• Automatic Backup
  
• AutoSum
  
• Bold
  
• Border
  
• Cascade Open Workbooks
  
• Cell Movement Keys
  
• Center Across Columns
  
• Center Pages
  
• Chart
  
• Chart-Change Chart Type
  
• Chart-Change Data Range
  
• Chart-Change Data Series
  
• Chart-Colors
  
• Chart-Data Labels/Values
  
• Chart-Delete
  
• Chart-Grid Lines
  
• Chart-Legend
  
• Chart-Move
  
• Chart-Rotate Axis Text
  
• Chart-Show Data Table
  
• Chart-Size
  
• Chart-Titles
  
• Clear Cell Contents
  
• Clear Cell Formatting
  
• Close Workbook
  
• Color Text
  
• Column Width
  
• Column Width-Standard Width
  
• Copy and Insert Data
  
• Copy Data (Overwrite destination)
  
• Copy Cell Formatting
  
• Copy Worksheet
  
• Create New Workbook
  
• Create New Worksheet
  
• Create Range Name
  
• Currency
  
• Currency Style
  
• Custom Lists
  
• Decimal Places
  
• Delete Column(s)/Row(s)
  
• Delete Workbook
  
• Delete Worksheet
  
• Display/Access Open Workbooks
  
• Display Formula Bar
  
• Display Formulas
  
• Display Toolbars
  
• Double Underline
  
• Edit Contents of Cell
  
• Enter Data
  
• Enter Data-Multiple Worksheets
  
• Enter Dates
  
• Erase Contents of Cell
  
• Erase Selected Cells
  
• Exit Excel 97
  
• Exit Windows 95/98
  
• Fill Cell with Same Characters
  
• Fill Cells with New Data
  
• Fill Patterns
  
• Fill Series-Date
  
• Fill Series-Growth
  
• Fill Series-Linear
  
• Fit to Specified Pages
  
• Font/Font Size
  
• Format Date
  
• Format Numbers
  
• Format Time
  
• Formulas
  
• Fractions
  
• Freeze Column(s)/Row(s)
  
• Function Wizard
  
• Functions
  
• Go To
  
• Go To Range Name
  
• Grid Lines
  
• Headers/Footers
  
• Headers/Footers-Top/Bottom Margins
  
• Help-Contents
  
• Help-Index
  
• Help-Office Assistant
  
• Hide Column(s)/Row(s)
  
• Insert Blank Column(s)/Row(s)
  
• Insert Blank Worksheet
  
• Italic
  
• Justify Text
  
• Justify-Horizontal/Vertical
  
• Margins
  
• Merge Cells
  
• Move and Insert Data
  
• Move Data (overwrite destination)
  
• Move Worksheet
  
• Number Style
  
• Numeric Text
  
• Open Workbook
  
• Page Break
  
• Paper Orientation
  
• Paper Size
  
• Percent
  
• Percent Style
  
• Print One Copy of Worksheet
  
• Print Preview
  
• Print Row and Column Titles
  
• Print Worksheet
  
• Rename Worksheet
  
• Replace Contents of Cell
  
• Replace File
  
• Reset Menus and Toolbars
  
• Rotate Data
  
• Row and Column Headings
  
• Run Excel 97
  
• Save Workbook
  
• Save Workspace
  
• Select Cells/Columns/Rows
  
• Select to End of Worksheet
  
• Select Worksheet
  
• Shade/Color
  
• Shrink to Fit
  
• Spelling
  
• Strikethrough
  
• Superscript/Subscript
  
• System Default Drive
  
• Tile Open Workbooks
  
• Underline
  
• Undo
  
• Unfreeze Column(s)/Row(s)
  
• Unhide Column(s)/Row(s)
  
• Vertical Row Alignment
  
• Wrap Text
  

POWERPOINT 97 Top of Page

• Action Buttons
  
• Add Slide
  
• Add Slide-Same Layout
  
• Animation-Customized
  
• Animation-Preview
  
• Automatic Spell Checking
  
• Background Color
  
• Background Fill/Pattern/Texture
  
• Background Picture
  
• Bold
  
• Border Lines
  
• Build Bullets
  
• Bullets-Add/Remove
  
• Bullets-Change
  
• Bullets-Demote/Promote
  
• Cascade Open Documents
  
• Change Case
  
• ClipArt
  
• ClipArt-Border Lines
  
• ClipArt-Brightness
  
• ClipArt-Contrast
  
• ClipArt-Crop
  
• ClipArt-Delete
  
• ClipArt-Fill
  
• ClipArt-Move
  
• ClipArt-Recolor
  
• ClipArt-Resize
  
• ClipArt-Restore Image
  
• ClipArt-Watermark
  
• Close Document Window
  
• Color Scheme-Add
  
• Color Scheme-Copy
  
• Copy Slide
  
• Copy Text
  
• Create New File
  
• Date/Time
  
• Delete Slide
  
• Delete Text
  
• Display Different Slide
  
• Display Formatting Toolbar
  
• Display Standard Toolbar
  
• Emboss Text
  
• Exit PowerPoint
  
• Exit Windows 95/98
  
• Fill Color
  
• Font
  
• Font Size
  
• Footer
  
• Handouts-Page Numbers, Date, Time
  
• Handouts-Print
  
• Help-Context Sensitive
  
• Help-Index
  
• Indent-Add/Remove
  
• Italic
  
• Line Spacing
  
• Lines-Add
  
• Lines-Arrowheads
  
• Lines-Arrowheads Added
  
• Lines-Color
  
• Lines-Copy
  
• Lines-Delete
  
• Lines-Dashed
  
• Lines-Move
  
• Lines-Thickness
  
• Load PowerPoint 97
  
• Move Slide-Outline View
  
• Move Slide-Slide Sorter
  
• Move Text
  
• Notes Page View
  
• Object-Add Text
  
• Object-Align
  
• Object-Border
  
• Object-Copy
  
• Object-Create AutoShape
  
• Object-Create Oval/Circle
  
• Object-Create Rectangle/Square
  
• Object-Delete
  
• Object-Fill
  
• Object-Group Objects
  
• Object-Move
  
• Object-Resize
  
• Object-Rotate
  
• Office Assistant
  
• Open Presentation
  
• Org Chart
  
• Org Chart-Add Boxes
  
• Org Chart-Background
  
• Org Chart-Box Border
  
• Org Chart-Box Fill
  
• Org Chart-Delete
  
• Org Chart-Delete Box
  
• Org Chart-Edit
  
• Org Chart-Edit Text
  
• Org Chart-Exit
  
• Org Chart-Move Box
  
• Org Chart-Select Boxes
  
• Org Chart-Style
  
• Org Chart-Text Align
  
• Org Chart-Text Color
  
• Org Chart-Text Font
  
• Outline View
  
• Overwrite File
  
• Page Numbering
  
• Page Orientation
  
• Presentation-Copy
  
• Presentation-Unpack
  
• Print All Slides
  
• Print Current Slide
  
• Print Slides
  
• Renumber Slides
  
• Reset Menu Bar
  
• Save Presentation
  
• Select Slides
  
• Select Text
  
• Select View
  
• Slide Layout
  
• Slide Master
  
• Slide Show-Automatic
  
• Slide Show-Run
  
• Slide Sorter View
  
• Slide View
  
• Speaker Notes
  
• Speaker Notes-Move Box
  
• Speaker Notes-Page Numbers
  
• Speaker Notes-Print
  
• Speaker Notes-Resize Image/Text Box
  
• Speller
  
• Stacking Order
  
• Superscript/Subscript
  
• System Default Drive
  
• Tabs-Delete
  
• Tabs-Move
  
• Tabs-Set
  
• Template
  
• Text Alignment
  
• Text Box-Delete
  
• Text Box-Move
  
• Text Box-Resize
  
• Text Color
  
• Text Shadow
  
• Text Tool-Add Text
  
• Tile Open Documents
  
• Transition
  
• Underline
  
• Undo
  
• Video Clip-Add
  
• WordArt
  
• Zoom
  

WORD 97 Top of Page
Sample (requires Word 6.0 or higher)

• Accented Character
  
• All Caps
  
• Animate Text
  
• Automatic Backup
  
• Bold
  
• Bullet List
  
• Bullet List-Remove Bullets
  
• Center Pages Vertically
  
• Change Case
  
• Change System Default Drive
  
• Character Formatting
  
• Close All Document Windows
  
• Close Document Window
  
• Color Text
  
• Copy File
  
• Copy Formatting
  
• Copy Text
  
• Date
  
• Delete File
  
• Delete Text
  
• Display Formatting
  
• Display Formatting Toolbar
  
• Display Hidden Text
  
• Display Nonprinting Characters
  
• Display Open Windows
  
• Display Ruler
  
• Display Standard Toolbar
  
• Display Status Bar
  
• Dotted Underline
  
• Double Underline
  
• Drop Cap
  
• Exit Windows 95/98
  
• Exit Word for Windows 97
  
• Find Text
  
• Font
  
• Font Size
  
• Force Paragraph to New Page
  
• Go To
  
• Hanging Indent
  
• Hanging Indent-Remove
  
• Help-Contents
  
• Help-Context Sensitive
  
• Help-Index
  
• Hidden Text
  
• Highlight Text
  
• Hyphenation
  
• Hyphen-Nonbreaking
  
• Hyphen-Optional
  
• Indent
  
• Indent-Remove
  
• Insert File
  
• Insertion Movement Keys
  
• Italic
  
• Keep Paragraphs Together
  
• Keep Single Paragraph Together
  
• Line Spacing
  
• List Open Files
  
• Load Word for Windows 97
  
• Manual Page Break
  
• Margins
  
• Move File
  
• Move Text
  
• New Document
  
• Nonbreaking Space
  
• Normal View
  
• Numbered List
  
• Numbered List-Remove Numbers
  
• Office Assistant
  
• Open File
  
• Page Layout
  
• Page Numbering-Add
  
• Page Numbering-Change Style
  
• Page Numbering-Remove
  
• Paper Size/Orientation
  
• Paragraph Alignment
  
• Preview Page
  
• Print Current Page
  
• Print Entire Document
  
• Print Multiple Pages
  
• Printer-Select
  
• Remove Character Formatting
  
• Remove Paragraph Formatting
  
• Rename File
  
• Repeat Typing
  
• Replace File
  
• Replace Text
  
• Restore Menu Bar
  
• Save Document
  
• Section Break
  
• Select Text
  
• Select Text-Cancel
  
• Select Text-Mouse
  
• Small Caps
  
• Spelling
  
• Strikethrough
  
• Subscript
  
• Superscript
  
• Symbols
  
• Tab Stops
  
• Tab Stops-Clear
  
• Tab Stops-Move
  
• Thesaurus
  
• Turn Off Character Format
  
• Underline
  
• Undo
  
• View Modes
  
• WingDings
  

For more information on the MS Office Quick Reference Guide, please call/fax [250] 727-2700.