77-882 : MOS: Microsoft Excel 2010

MOS: Microsoft Excel 2010
Includes:
147+ Videos
146+ Test Prepkits
98+ Flash Cards
Rating :
(16)
Gain hands-on expertise in Microsoft MOS Excel 2010 exam with the Microsoft 77-882 course. The cert guide provides complete coverage of the 77-882 exam objectives and provides technical knowledge required to manage worksheets, workbooks, and worksheet environment; create and format cells, worksheet, and cell data; and apply formula and functions. The course is designed to provide all the basic and advanced skills needed for working with the Microsoft Excel 2010 application successfully.

Here's what you will get

The MOS: Excel 2010 is a standalone certification from Microsoft with the exam code 77-882. This certification is targeted at professionals who can create and manage worksheets & workbooks with Microsoft Office Excel 2010 and may have experience with previous versions of Microsoft Office Excel. They are also strong in performing tasks like creating tables, applying formulas and functions, creating charts & objects.

Lessons
Lessons
26+
Exercises
79+
Quizzes
146+
Flashcards
98+
Glossary of terms
98+
TestPrep
Pre-assessment Questions
30+
Full Length Tests
4+
Post-Assessment Questions
50+

Videos and How To..

uCertify course includes videos to help understand concepts. It also includes How Tos that help learners with how to accomplish certain tasks.

Video Lessons
Videos
147+
Hours
02:27+
Exam FAQs
What are the prerequisites for this exam? There are no technical prerequisites for this certification.
What is the exam registration fee? USD 96
Where do I take the exam? The Microsoft 77-882 exam is administered by Certiport at testing centers worldwide. Click here to find a testing center near you.
What is the format of the exam? The exam consists of performance based questions and is conducted in a live or simulated environment.
How many questions are asked in the exam? The exam contains 40-60 questions.
What is the duration of the exam? 50 minutes
What is the passing score? 700

(on a scale of 0-1000)

What is the exam's retake policy?

As of 1 July 2014, Microsoft's retake policy changed to the following:

  • If a candidate does not achieve a passing score on an exam the first time, the candidate must wait 24 hours before retaking the exam.
  • If a candidate does not achieve a passing score the second time, the candidate must wait 48 hours before retaking the exam.
  • A two-day waiting period is imposed for each subsequent exam retake.
  • If a candidate achieves a passing score on an exam, the candidate may take it again.
What is the validity of the certification? Microsoft Office Specialist certification does not expire. This certification holder is certified for life unless the vendor changes their policy. Click here for more information.
Which certification covers this exam?
What are the career opportunities after passing this exam?
  • Information Workers
  • Office Professionals
  • Accountants
  • Financial Analysts
  • Data Analysts
  • Commercial Bankers
  • Program/Project Managers
  • Sales Professionals

Here's what you will learn

  • Topic A: Spreadsheet terminology
  • Topic B: The Excel environment
  • Topic C: Getting help
  • Topic D: Navigating a worksheet
  • Unit summary: Getting started
  • Review Questions
  • Topic A: Entering and editing text and values
  • Topic B: Entering and editing formulas
  • Topic C: Working with pictures
  • Topic D: Saving and updating workbooks
  • Unit summary: Entering and editing data
  • Review Questions
  • Topic A: Moving and copying data
  • Topic B: Moving and copying formulas
  • Topic C: Absolute and relative references
  • Topic D: Inserting and deleting ranges, rows, and columns
  • Unit summary: Modifying a worksheet
  • Review Questions
  • Topic A: Entering functions
  • Topic B: AutoSum
  • Topic C: Other common functions
  • Unit summary: Using functions
  • Review Questions
  • Topic A: Text formatting
  • Topic B: Row and column formatting
  • Topic C: Number formatting
  • Topic D: Conditional formatting
  • Topic E: Additional formatting options
  • Unit summary: Formatting
  • Review Questions
  • Topic A: Preparing to print
  • Topic B: Page Setup options
  • Topic C: Printing worksheets
  • Unit summary: Printing
  • Review Questions
  • Topic A: Chart basics
  • Topic B: Formatting charts
  • Unit summary: Charts
  • Review Questions
  • Topic A: Viewing large worksheets
  • Topic B: Printing large worksheets
  • Topic C: Working with multiple worksheets
  • Unit summary: Managing large workbooks
  • Review Questions
  • Topic A: Conditional formatting with graphics
  • Topic B: SmartArt graphics
  • Topic C: Screenshots
  • Unit summary: Graphics and screenshots
  • Review Questions
  • Topic A: Using multiple workbooks
  • Topic B: Linking worksheets with 3-D formulas
  • Topic C: Linking workbooks
  • Topic D: Managing workbooks
  • Unit summary: Using multiple worksheets and workbooks
  • Review Questions
  • Topic A: Using special number formats
  • Topic B: Using functions to format text
  • Topic C: Working with styles
  • Topic D: Working with themes
  • Topic E: Other advanced formatting
  • Unit summary: Advanced formatting
  • Review Questions
  • Topic A: Outlining and consolidating data
  • Topic B: Creating subtotals
  • Unit summary: Outlining and subtotals
  • Review Questions
  • Topic A: Creating and using names
  • Topic B: Managing names
  • Unit summary: Cell and range names
  • Review Questions
  • Topic A: Sorting and filtering data
  • Topic B: Advanced filtering
  • Topic C: Working with tables
  • Unit summary: Tables
  • Review Questions
  • Topic A: Saving workbooks as Web pages
  • Topic B: Using hyperlinks
  • Topic C: Sharing workbooks
  • Unit summary: Web and sharing features
  • Review Questions
  • Topic A: Chart formatting options
  • Topic B: Combination charts
  • Topic C: Graphical elements
  • Unit summary: Advanced charting
  • Review Questions
  • Topic A: Auditing features
  • Topic B: Comments in cells and workbooks
  • Topic C: Protection
  • Topic D: Workgroup collaboration
  • Unit summary: Documenting and auditing
  • Review Questions
  • Topic A: Changing application settings
  • Topic B: Using built-in templates
  • Topic C: Creating and managing templates
  • Unit summary: Templates and settings
  • Review Questions
  • Topic A: Working with PivotTables
  • Topic B: Rearranging PivotTables
  • Topic C: Formatting PivotTables
  • Topic D: Using PivotCharts
  • Unit summary: PivotTables and PivotCharts
  • Review Questions
  • Topic A: Logical functions
  • Topic B: Math and statistical functions
  • Unit summary: Logical and statistical functions
  • Review Questions
  • Topic A: Financial functions
  • Topic B: Date and time functions
  • Topic C: Array formulas
  • Topic D: Displaying and printing formulas
  • Unit summary: Financial and date functions
  • Review Questions
  • Topic A: Using lookup functions
  • Topic B: Using MATCH and INDEX
  • Topic C: Creating data tables
  • Unit summary: Lookups and data tables
  • Review Questions
  • Topic A: Validating cell entries
  • Topic B: Exploring database functions
  • Unit summary: Advanced data management
  • Review Questions
  • Topic A: Exporting and importing text files
  • Topic B: Exporting and importing XML data
  • Topic C: Getting external data
  • Unit summary: Exporting and importing
  • Review Questions
  • Topic A: Goal Seek and Solver
  • Topic B: The Analysis ToolPak
  • Topic C: Scenarios
  • Unit summary: Analytical tools
  • Review Questions
  • Topic A: Running and recording a macro
  • Topic B: Working with VBA code
  • Topic C: Creating functions
  • Unit summary: Macros and custom functions
  • Review Questions