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 |
| Real Exam Qty: | 16–18 (33–37 tasks) |
| Exam Duration: | 45–50 |
| Exam Format: | Performance-based, Scenario-based, Task-oriented |
| Available Languages: | English, French, German, Spanish, Italian, Japanese, Korean, Chinese Simplified, Chinese Traditional |
| Passing Score: | 640 (scale 0–1000) |
| Certificate Validity Period: | Lifetime (no expiration) |
| Exam Price: | $65–$75 USD (varies by region/center) |
| Related Certifications: | MOS: Excel 2002 Expert MOS Master (Office XP/2002) |
| Recommended Training: | Microsoft Official Curriculum for Office XP Certiport Learning Resources |
| 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 |
|---|---|---|
| Formatting and Printing Worksheets | 20% | - Adjusting row height, column width, and page setup - Applying cell, font, alignment, and border formatting - Using AutoFormat, styles, and conditional formatting - Previewing and printing worksheets and workbooks |
| Managing Workbooks | 20% | - Creating, opening, saving workbooks and templates - Using workbook properties and file management - Sending workbooks via email - Saving in different formats and locations |
| Creating and Modifying Charts and Graphics | 10% | - Inserting and formatting clip art, images, and objects - Arranging and resizing graphical elements - Creating, formatting, and modifying charts |
| Modifying Worksheets and Workbooks | 20% | - Inserting, deleting, moving, copying, and renaming worksheets - Working with multiple sheets and linking data - Hiding/unhiding and freezing panes - Checking spelling and using find/replace |
| Creating and Revising Formulas and Functions | 25% | - Constructing basic formulas and using cell references - Defining and using named ranges - Troubleshooting formula errors - Using functions: SUM, AVERAGE, COUNT, MIN, MAX, IF, DATE, NOW |
| Workgroup Collaboration and Data Management | 5% | - Tracking changes and sharing workbooks - Using AutoFilter and basic data organization - Inserting, viewing, and editing comments |
By Bishop
