Microsoft Excel Spreadsheets

A. General Windows Usage

1. Using the Mouse
   • (Left-)Click, Double-click, Right-click
   • Point, Highlight, Drag, Scroll
2. Using the Keyboard
   • Pointer Movement Keys (Home, PgUp, PgDn, End, Tab, arrows)
   • Shortcut keys
3. Using Screen Objects: Button, Icon, Menu (submenu, More...)
4. Windows
   • Title, Min, Max/Restore, Close (exit)
   • Move, Resize
   • Rulers, Status bar, Scroll bars
5. Dialog Boxes: Buttons, Tabs, Radio buttons, Checkmarks, Lists

   B. General Excel Features

   1. Opening and Closing Spreadsheets
      • Start a New Spreadsheet (New)
      • Save a Spreadsheet (Save, Save As)
      • Open an Existing Spreadsheet (Open)
      • Exit Excel (File menu, or Exit button)
      
      
      
   2. Identifying parts and navigating Spreadsheets
      • Menu bar, tool bar, title bar, status bar
      • Formula bar, Enter button
      • Columns (letters) and Rows (numbers)
      • Cells (where column & row meet): text, numbers, formulas
      • Select row(s), column(s), cell(s), All
      
      
      
   3. Editing Spreadsheets
      • Enter text and numbers
      • Cut, Copy, Paste
      • Series -- fill handle (lower right corner)
      • Sort (up or down)
      • Adding and deleting rows, columns, and data
      
      
      
   4. Printing Spreadsheets
      • Page setup (margins, orientation, gridlines,headers and footers)
      • Print Preview (File menu)
      • Print highlighted only; Scaling to fit; Page range
      
      
      
   5. Spreadsheet Solutions (templates, wizards)
      
      
   6. Formating
      • Format Toolbar (font & size, bold, etc., case, center)
      • Column width, row height
      • Borders
      • AutoFormat (Format menu)

   C. Advanced Topics

   1. Charts and Graphs
   2. MailMerge (Word Tools menu) -- mailing labels
   3. Workbooks (multiple worksheets)