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

News Releases Student Recognized Nationally on ALL IN Student Voting Honor Roll Posted Thursday, April 25, 2024
Read More
Link to Student Recognized Nationally on ALL IN Student Voting Honor Roll
News Releases Students Receive National Honors with United States President’s Volunteer Service Award Posted Monday, April 15, 2024
Read More
Link to Students Receive National Honors with United States President’s Volunteer Service Award
News Releases RVCC to Receive Sapling from Original Tree Mentioned in Anne Frank’s Diary Posted Friday, March 29, 2024
Read More
Link to RVCC to Receive Sapling from Original Tree Mentioned in Anne Frank’s Diary