Computer Proficiency Exam Study Guide (Lab Portion)

This study guide is for the lab portion of the proficiency exam only. To study for the lecture portion of the exam, you will need to study the text, Discovering Computers 2010 Living in a Digital World, Brief version, Shelly-Vermaat, Course Technology, ISBN 978-0-324-78647-7.

1. Windows Explorer or My Computer
   1. Start Windows Explorer or My Computer and Identify Screen Elements
   2. File Management - You Should Be Able to Use the Mouse, Keystrokes, or Menus as Needed to Perform the Following:
      1. Create Folders
      2. Move Folders
      3. Delete Folders
      4. Copy Files
      5. Move Files
      6. Rename Files and Folders
      7. Delete Files
      8. Restore or Delete Files From the Trash Bin
      9. Select files singly or select multiple files
      10. Organize Files in a Logical Manner
      11. Change Drives
   3. Know What a File Path Is
   4. Accomplish File Management Tasks Given a File Path or Paths in the Form driveletter:\folderA\folderB\filename.ext
2. Internet Explorer
   1. Start Internet Explorer and Identify Internet Explorer Screen Elements
   2. Navigate the Internet
      1. Use the Standard Buttons Toolbar
      2. Use the Address Bar
      3. Use Hyperlinks
      4. Use Internet Explorer History
   3. Work with Favorites
      1. Add an Address to the Favorites List
      2. Display a Favorite Web Site
      3. Delete a Web Address From Favorites
   4. Search the Internet
   5. Download and Save a Web Page
   6. Print Web Pages
3. Word 2003/2007
   1. Explore and Navigate the Word Window
      1. Start Word and Identify Parts of the Word Window
      2. Open an Existing Document
      3. Access Menu/Ribbon Commands and Display the Task Pane
      4. Navigate a Document Using the Vertical Scroll Bar
      5. Navigate a Document Using the Keyboard
   2. View Documents
      1. Display Formatting Marks
      2. Change Document Views
      3. Use the Zoom Button
   3. Use the Spelling and Grammar Checker
   4. Create Headers and Footers
   5. Organize, Save, and Print Documents
   6. Create and Edit a New Document
      1. Create a New Document
      2. Enter Text and Insert Blank Lines
      3. Edit Text with the Delete and Backspace Keys
      4. Insert New Text and Overtype Existing Text
   7. Select and Format Text
      1. Select Text
      2. Change Font and Font Size
      3. Add Emphasis to Text
   8. Preview and Print Documents, Close a Document, and Close Word
   9. Use the Microsoft Help System
   10. Change Document and Paragraph Layout
       1. Set Margins
       2. Align Text
       3. Change Line Spacing
       4. Add Space After Paragraphs
       5. Indent Paragraphs
       6. Use the Format Painter
   11. Change and Reorganize Text
       1. Find and Replace Text
       2. Select and Delete Text
       3. Cut and Paste Text
       4. Copy and Paste Text
       5. Drag Text to a New Location
       6. Undo and Redo Changes
   12. Create and Modify Lists
       1. Create a Bulleted List
       2. Create a Numbered List
       3. Format Lists
       4. Customize Bullets
   13. Work with Headers and Footers
       1. Insert and Format Page Numbers
       2. Insert the Current Date and Time
       3. Insert AutoText
   14. Insert Frequently Used Text
       1. Record AutoCorrect Entries
       2. Use AutoCorrect Shortcuts
       3. Record and Insert AutoText
       4. Insert Symbols
   15. Insert References
       1. Insert Footnotes
       2. Format Footnotes
       3. Create a Reference Page
       4. Format a Reference Page
   16. Insert and Modify Clip Art and Pictures
       1. Insert Clip Art
       2. Insert a Picture From a File
       3. Wrap Text Around Graphic Objects
       4. Resize a Graphic Object
       5. Move a Graphic Object
   17. Work with the Drawing Toolbar
       1. Insert a Text Box
       2. Move and Resize a Text Box
       3. Insert an Arrow
       4. Insert an AutoShape
   18. Work with Tab Stops
       1. Set Tab Stops
       2. Format and Remove Tab Stops
       3. Use Tab Stops to Enter Text
       4. Move Tab Stops
   19. Create and Format Tables
       1. Create a Table
       2. Add a Row to a Table
       3. Change the Width of a Table Column
       4. Add a Column to a Table
       5. Format Text in Cells
       6. Shade Cells
       7. Change the Table Border
       8. Center a Table
       9. Convert Text to Tables
       10. Apply a Predefined Format to a Table
       11. Merge Cells and Align Text Verticall
   20. Create a Decorative Masthead
       1. Insert WordArt
       2. Format WordArt
       3. Add a Border Line
   21. Create Multi-Column Text
       1. Change One Column to Two Columns
       2. Format Multiple Columns
       3. Insert a Column Break
   22. Add Special Paragraph Formatting
       1. Add a Border to a Paragraph
       2. Shade a Paragraph
   23. Use Special Character Formats
       1. Change Font Color
       2. Use Small Caps
   24. Insert Hyperlinks
   25. Preview and Save a Document as a Web Page
   26. Locate Supporting Information
       1. Use Collect and Paste to Gather Images
       2. Collect Information from Other Documents
       3. Paste Information from the Clipboard Task Pane
       4. Use the Thesaurus
4. Excel 2003/2007
   1. Start Excel and Navigate a Workbook
      1. Start Excel and Identify the Parts of the Window
      2. Use the Menu Bar/Ribbon, ScreenTips, and the Toolbars
      3. Open an Existing Workbook
      4. Select Columns, Rows, Cells, Ranges, and Worksheets
      5. Navige Using the Scroll Bars
      6. Navigate Using the Name Box
      7. Navigate Among the Worksheets in a Workbook
      8. View a Chart
      9. Rename a Sheet Tab
   2. Create Headers and Footers
   3. Preview and Print a Workbook
   4. Save and Close a Workbook
   5. Create a New Workbook
   6. Enter and Edit Data in a Worksheet
      1. Enter Text
      2. Use AutoComplete to Enter Data
      3. Enter Numbers
      4. Type Dates Into a Worksheet
      5. Edit Data in Cells
      6. Use Undo and Redo
      7. Clear a Cell
   7. Create Formulas
      1. Type a Formula in a Cell
      2. Use Point and Click to Enter Cell References in a Formula
      3. Sum a Column of Numbers with AutoSum
   8. Zoom a Worksheet
   9. Check for Spelling Errors
   10. Preview and Print a Worksheet
   11. Use Excel Help
   12. Enter Constant Values with Autofill and the Fill Handle
       1. Insert Titles and Headings
       2. Create a Series Using AutoFill
       3. Duplicate Data Using AutoFill
   13. Working with Rows and Columns
       1. Adjust Column Width and Row Height
       2. Insert and Delete Rows and Columns
   14. Working with Cells
       1. Align Cell Contents
       2. Use Merge and Center
       3. Copy Cell Contents
       4. Copy Multiple Selections Using Collect and Paste
       5. Move Cell Contents Using the Cut Command
       6. Move Cell Contents Using Drag-And-Drop
   15. Formatting Cells
       1. Change the Font and Font Size
       2. Merge Cells
       3. Apply Cell Borders
       4. Apply Cell Shading
       5. Use Format Painter
       6. Clear Cell Formats
       7. Use the Format Cells Dialog Box to Format Numbers
       8. Select and Apply the Currency Format
       9. Change Horizontal Alignment Using the Format Cells Dialog Box
       10. Indent Cell Contents
       11. Fill a Cell
       12. Align Cell Contents Vertically
       13. Rotate Text
       14. Wrap Text in a Cell
   16. Apply Workbook Formatting
       1. Select Page Orientation, Scaling, and Paper Size
       2. Set Margins and Center the Worksheet
       3. Create Headers and Footers with Inserted Pictures
       4. Set Header and Footer Margins
   17. Edit and Copy Formulas
       1. Select Ranges Using the AutoSum Function
       2. Edit Within the Formula Bar
       3. Edit Within a Cell Using Edit Mode
       4. Copy a Formula with Relative Cell References Using the Fill Handle
       5. Copy Formulas Containing Absolute Cell References
   18. Display and Print Underlying Formulas
   19. Print Gridlines and Row and Column Headings