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 Theatre Announces 40th Season, Offering Shows for Audiences of All Ages, Interests Posted Tuesday, September 5, 2023
Read More
Link to Theatre Announces 40th Season, Offering Shows for Audiences of All Ages, Interests
News Releases Students Create Tunnel Mural for Bound Brook Train Station Posted Tuesday, June 6, 2023
Read More
Link to Students Create Tunnel Mural for Bound Brook Train Station
News Releases Honors College Student Awarded National Community College Transfer Scholarship Posted Tuesday, May 30, 2023
Read More
Link to Honors College Student Awarded National Community College Transfer Scholarship