COMPUTER LITERACY TECHNOLOGICAL COMPETENCY TEST: WINDOWS 7 / OFFICE 2010

COMPUTER LITERACY TECHNOLOGICAL COMPETENCY TEST: WINDOWS 7 / OFFICE 2010

The exam consists of 70 questions to be answered within 70 minutes. Please be familiar with the concepts below in order to earn the 70% required to pass the test. The questions are both hands on and multiple choice.

Basic Concepts
  •  Bytes/kilobytes/megabytes/terabytes
  •  Computer security
  •  Copyright Protection
  •  Data storage
  •  E-commerce
  •  Hardware and software
  •  Identifying operating systems
  •  Internet and World Wide Web
  •  Measuring processor speed
  •  ROM
  •  User licenses

File Management
  •  Adding a desktop background
  •  Control Panel
  •  Creating a screenshot
  •  Creating folders
  •  File Compression
  •  Identifying file types by their icon
  •  Keyboard shortcuts
  •  Minimize/maximize/restore down
  •  Navigating Windows (folders, icons)
  •  Restarting computer
  •  Selecting multiple folders simultaneously
  •  Sorting files in a dialog box
  •  Windows Task Manager

Information and Communication
  •  Accessing Internet Explorer (IE) home page
  •  Adding favorites in IE
  •  Email – To/CC/BCC
  •  IE back button
  •  IE Options
  •  Opening a new tab in IE
  •  Reloading Web pages in IE
  •  Saving images on a Web page
  •  Smartphone operating systems
  •  Web cookie

Access 2010
  •  Adding labels to a form
  •  Adding new records using a form
  •  Changing from design view to datasheet view
  •  Data types
  •  Deleting records
  •  Filtering queries using criteria
  •  Navigating through records
  •  Primary keys/relationships
  •  Record vs. field
  •  Running queries
  •  Tables

Word 2010
  •  Adding a first line indent using ruler
  •  Adding a new paragraph
  •  Headers and Footers
  •  Navigating commands on the ribbon
    •  Changing font color/size/line spacing/alignment
    •  Converting text to uppercase
    •  Creating bulleted lists
    •  Format painter tool
    •  Hiding non-printable characters
    •  Inserting picture/clip art/symbols
    •  Undoing your last action  
  •  Setting tab stops using ruler

PowerPoint 2010
  •  Adding shapes/smart art
  •  Animations vs. transitions
  •  Applying themes
  •  Inserting clipart
  •  Moving pictures without distorting size
  •  Notes pane
  •  Printing notes/handouts
  •  Saving in other file formats
  •  Slide layouts
  •  Slide views
  •  The more button
  •  Viewing a slide show

Excel 2010
  •  Adding additional worksheets
  •  Adding borders
  •  Adding formulas/functions
  •  Auto Sum
  •  Changing decimal places
  •  Copying formulas/functions
  •  Fill handle
  •  Merge and center
  •  Printing
  •  Selecting all cells in a sheet
  •  Sorting content
  •  Undoing your last action
  •  Zoom tool

Latest News From Campus

Blog Program Spotlight: Arts & Design at RVCC! Posted Monday, November 29, 2021
Read More
Link to Program Spotlight: Arts & Design at RVCC!
Blog Learn About the Honors College at RVCC! Posted Monday, November 15, 2021
Read More
Link to Learn About the Honors College at RVCC!
Blog International Students: Find a World of Opportunity at RVCC Posted Friday, October 29, 2021
Read More
Link to International Students: Find a World of Opportunity at RVCC