We're so confident of our products that we provide no hassle product exchange.
Microsoft MOS-EXP2002 Exam Overview:
| Certification Vendor: | Microsoft |
|---|---|
| Exam Name: | Microsoft Excel 2002 Core |
| Exam Number: | MOS-EXP2002 |
| Related Certifications: | MOS Master (Office XP/2002) MOS: Excel 2002 Expert |
| Available Languages: | Italian, Spanish, Korean, Chinese Traditional, Chinese Simplified, Japanese, English, French, German |
| Exam Duration: | 45–50 |
| Real Exam Qty: | 16–18 (33–37 tasks) |
| Passing Score: | 640 (scale 0–1000) |
| Exam Price: | $65–$75 USD (varies by region/center) |
| Certificate Validity Period: | Lifetime (no expiration) |
| Exam Format: | Scenario-based, Task-oriented, Performance-based |
| Recommended Training: | Certiport Learning Resources Microsoft Official Curriculum for Office XP |
| Exam Registration: | Certiport Registration |
| Exam Way: | Onsite proctored exam at Certiport authorized testing centers |
| Pre Condition: | No prerequisites required |
| Official Syllabus URL: | https://learn.microsoft.com/en-us/previous-versions/office/office-xp/aa190782(v=office.10) |
Microsoft MOS-EXP2002 Exam Syllabus Topics:
| Section | Weight | Objectives |
|---|---|---|
| Topic 1: Formatting and Printing Worksheets | 20% | - Previewing and printing worksheets and workbooks - Using AutoFormat, styles, and conditional formatting - Adjusting row height, column width, and page setup - Applying cell, font, alignment, and border formatting |
| Topic 2: Workgroup Collaboration and Data Management | 5% | - Inserting, viewing, and editing comments - Tracking changes and sharing workbooks - Using AutoFilter and basic data organization |
| Topic 3: Managing Workbooks | 20% | - Using workbook properties and file management - Sending workbooks via email - Saving in different formats and locations - Creating, opening, saving workbooks and templates |
| Topic 4: Creating and Modifying Charts and Graphics | 10% | - Arranging and resizing graphical elements - Creating, formatting, and modifying charts - Inserting and formatting clip art, images, and objects |
| Topic 5: Modifying Worksheets and Workbooks | 20% | - Working with multiple sheets and linking data - Checking spelling and using find/replace - Hiding/unhiding and freezing panes - Inserting, deleting, moving, copying, and renaming worksheets |
| Topic 6: Creating and Revising Formulas and Functions | 25% | - Troubleshooting formula errors - Constructing basic formulas and using cell references - Defining and using named ranges - Using functions: SUM, AVERAGE, COUNT, MIN, MAX, IF, DATE, NOW |
By Felix
