Free Certification Practice Tests and Study Guides
Join Us! | Login | Help




Microsoft Office Specialist: Excel 2002


Study Resources:
Practice Exam - Our free online practice exam
Forum - Get answers and help others
Find Training - CBT, testing software, online training, etc.

Links:
Official Exam Site
Microsoft Excel Tutorials
Money Saving Tips
Intro to Microsoft Certifications

About This Exam:
This Microsoft Office Specialist exam is performance-based, requiring you to perform a series of tasks using Microsoft Excel version 2002. Many of the questions in this Microsoft Office Specialist exam require you to complete a series of tasks to create or modify a typical business document.

This exam uses the actual Microsoft Excel version 2002 program. All menu items, keyboard shortcuts and right-click options will be available to complete the tasks. The help menu, including use of the Office Assistant, is not available in any of the exams.

There is one to three points are possible per question, depending on the number of specified tasks. At the conclusion of an exam your final score is derived by converting the task score to a 1000-point scale. While some questions involve more tasks than others, each question is scored on a total-score basis (i.e.; number correct) rather than on a pass/fail basis. For example, a 20-question exam may have 34 possible points; one point for each task.

Cost: $75
Format: Performance-based
Passing Score: Unknown
Questions: 16-18
Tasks: 33-37
Time Limit: 45-50
Launch Date: 9/16/02

Certification: MOS

Exam Difficulty:
Rated: 1.66

Exam Vouchers:
Discount Vouchers

Exam Registration:
Certiport
Exam Objectives:

Working with Cells and Cell Data
  • Insert, delete and move cells
  • Enter and edit cell data including text, numbers, and formulas
  • Check spelling
  • Find and replace cell data and formats
  • Work with a subset of data by filtering lists


  • Managing Workbooks
  • Manage workbook files and folders
  • Create workbooks using templates
  • Save workbooks using different names and file formats


  • Formatting and Printing Worksheets
  • Apply and modify cell formats
  • Modify row and column settings
  • Modify row and column formats
  • Apply styles
  • Use automated tools to format worksheets
  • Modify Page Setup options for worksheets
  • Preview and print worksheets and workbooks


  • Modifying Workbooks
  • Insert and delete worksheets
  • Modify worksheet names and positions
  • Use 3-D references


  • Creating and Revising Formulas
  • Create and revise formulas
  • Use statistical, date and time, financial, and logical functions in formulas


  • Creating and Modifying Graphics
  • Create, modify, position, and print charts
  • Create, modify, and position graphics


  • Workgroup Collaboration
  • Convert worksheets into Web pages
  • Create hyperlinks
  • View and edit comments






  • IT Showcase