Study Guide Computer Proficiency Exam (Lab Only)

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 2012 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 2007/2010
    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 2007/2010
    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