Microsoft Office Specialist: Excel 2002 Expert

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: 14-16
Tasks: 35-39
Time Limit: 45-50
Launch Date: 9/16/02

Certification: MOS

301 Moved Permanently

nginx

Exam Vouchers:
Discount Vouchers

Exam Registration:
Certiport

Exam Objectives:

Importing and Exporting Data

Import data to Excel

Export data from Excel

Publish worksheets and workbooks to the Web

Managing Workbooks

Create, edit, and apply templates

Create workspaces

Use data consolidation

Formatting Numbers

Create and apply custom number formats

Use conditional formats

Working with Ranges

Use named ranges in formulas

Use Lookup and Reference functions

Customizing Excel

Customize toolbars and menus

Create, edit, and run macros

Auditing Worksheets

Audit formulas

Locate and resolve errors

Identify dependencies in formulas

Summarizing Data

Use subtotals with lists and ranges

Define and apply filters

Add group and outline criteria to ranges

Use data validation

Retrieve external data and create queries

Create Extensible Markup Language (XML) Web queries

Analyzing Data

Create a Microsoft PivotTable®, Microsoft PivotChart®, and PivotTable/PivotChart Reports

Forecast values with what-if analysis

Create and display scenarios

Analyzing Data

Workgroup Collaboration

Modify passwords, protections, and properties

Create a shared workbook

Track, accept and reject changes to workbooks

Merge workbooks