Microsoft Excel 2010 (77-882)

About This Exam

77-882: Microsoft Excel 2010 Certification

Overview

The Microsoft Office Specialist (MOS) 77-882 exam is designed to validate proficiency in using Microsoft Excel 2010. This certification demonstrates that the candidate has the skills needed to get the most out of Excel 2010 by utilizing its features effectively and efficiently in a professional environment.

Exam Details

• Exam Name: Microsoft Excel 2010
• Exam Code: 77-882
• Certification Type: Microsoft Office Specialist (MOS)
• Software Tested: Microsoft Excel 2010
• Exam Format: Performance-based testing in a live Excel environment
• Duration: 50 minutes
• Number of Questions: Approximately 30-35 tasks
• Passing Score: 700 (on a scale of 1-1000)

Skills Measured

The 77-882 exam measures the candidate's ability to:

1. Managing the Worksheet Environment
   • Navigate through worksheets and workbooks
   • Print and distribute workbooks
   • Personalize the Excel environment
2. Creating Cell Data
   • Construct cell data
   • Apply auto fill
   • Apply and manipulate hyperlinks
3. Formatting Cells and Worksheets
   • Apply and modify cell formats
   • Merge and split cells
   • Create row and column titles
   • Hide and unhide rows and columns
   • Manipulate page setup options for worksheets
   • Create and apply cell styles
4. Managing Worksheets and Workbooks
   • Create and format worksheets
   • Manipulate window views
   • Manipulate workbook properties
5. Applying Formulas and Functions
   • Create formulas
   • Enforce precedence
   • Apply cell references in formulas
   • Apply conditional logic in a formula
   • Apply named ranges in formulas
   • Apply cell ranges in formulas
6. Presenting Data Visually
   • Create and format charts
   • Apply chart elements
   • Manipulate chart layouts
   • Apply sparklines
7. Sharing Worksheet Data with Other Users
   • Share spreadsheets by using Backstage
   • Manage comments
8. Analyzing and Organizing Data
   • Filter data
   • Sort data
   • Apply conditional formatting

Preparation Resources

Candidates preparing for the 77-882 exam can utilize various resources:

• Official Microsoft training materials
• MOS Study Guides
• Practice exams
• Instructor-led training courses
• Online tutorials and video courses

Target Audience

This certification is ideal for:

• Office workers
• Administrative assistants
• Business professionals
• Students
• Anyone who needs to demonstrate Excel 2010 competency in the workplace

Value of Certification

Earning the MOS Excel 2010 certification:

• Validates technical expertise with Excel 2010
• Demonstrates dedication to professional development
• May lead to increased job opportunities
• Can serve as a stepping stone to advanced Excel certifications