MS Office 2007 Level II Placement Test

Placement testing is required prior to registering for all Level II computer workshops to help ensure that participants in the Level II workshops are proficient with Level I material.  All testing is free and will be offered at our Marlborough, Newton, and Norwood Career Centers.

Note:  Currently we are only offering the placement test and Level II class for MS Excel 2007 and MS PowerPoint 2007.  When additional level II classes are offered, other placement tests will be available.

Testing consists of two parts:

• Prove It!® testing – a hands-on computerized test.  Customers will have a chance to demonstrate their mastery of the pre-requisite skills for Word, Excel, or PowerPoint 2007 Level II class. (Specifics below.)

• Complete a short assignment to demonstrate navigation skills to quickly find folders and drives in the Windows Vista environment.

  Note: To sign up for any Level II class, you will need to pass both the Prove It!® exam, with a score of 80% or higher, and the folder navigation assignment.  Failing either component means that you will not be able to register for the Level II class until you retake and pass the component you failed.

EXCEL 2007 LEVEL 2 PRE-REQUISITE SKILLS

• Start Excel and open existing workbooks
• Start a blank new workbook
• Cut, copy and paste data
• Select cells and cell ranges
• Change cell formats
• Insert new rows, columns and worksheets
• Set up basic functions
• Use the Save and Save As commands
• Merge and center cells
• Change column and row width
• Rename and rearrange worksheets
• Change margins and page orientation
• Center data horizontally and vertically on a page for printing purposes
• Scale worksheets for printing purposes
• Spell check worksheets
• Print worksheets

POWERPOINT 2007 LEVEL 2 PRE-REQUISITE SKILLS

• Insert slides with different layouts
• Enter and edit text on slides
• Change text alignment
• Change views
• Insert pictures and other objects
• Rearrange slides
• Hide and unhide slides
• Move objects on slides
• Delete slides
• Apply a theme
• Run the slide show
• Save copies of PP files
• Add slide transitions
• Customize slide animation
• Add speaker notes

WORD 2007 LEVEL 2 PRE-REQUISITE SKILLS

• Open a Word document
• Cut Copy, and Paste text
• Change font style and font size
• Change line spacing
• Emphasize text through bolding, italics, underlining, etc.
• Change margin settings, and page orientation
• Insert and customize bulleted and numbered lists
• Change paragraph indentation
• Use Find and Replace
• Insert and remove page breaks
• Insert and customize tables
• Insert page numbers
• Use the Undo and Redo buttons
• Spell check Word documents
• Save copies of Word documents in different formats including Compatibility Mode

Additional Information:

• You may register in person or on the phone to take the test.  Please call the ETR office where you wish to take the test(s) for testing dates and times.



• When multiple Level II classes are available, you may take multiple tests on the same date (e.g., Word and Excel tests).



• Registration for Level II classes will be on a rolling basis.  That is, if you pass the placement test for the Level II workshop that you wish to take, you may register for the next available workshop.  There is no need to wait for “Sign-Up Day".  You may sign up once the workshop schedule is known.  Please ask the testing facilitator for the schedule.



• If the class you wish to sign up for is full, please select another date.  You may also request to be placed on the standby list for your first choice.