Scroll to top button

MOS: Microsoft Excel 2010 (Course & Lab)

ISBN : 9781616916428

Gain hands-on expertise in Microsoft MOS- Excel 2010 exam by Microsoft 77-882 course and performance-based labs. Performance based labs simulate real-world, hardware, software & command line interface environments and can be mapped to any text-book, course & training. Microsoft MOS-Excel 2010 is a globally recognized, foundational-level credential designed for IT professionals, IT network practitioners. Microsoft 77-882 exam validates the expertise and technical knowledge required to manage worksheets, workbooks, and worksheet environment; create and format cells, worksheet, and cell data; and apply formula and functions.

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.

Glossary of terms
Pre Assessment Questions
Post Assessment Questions
Performance lab
Exam related 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
  • 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

Hands on Activities (Labs)

  • Hiding the formula bar
  • Showing the formula bar
  • Using formulas
  • Saving a file in PDF format
  • Clearing contents from a cell
  • Changing a relative reference to an absolute reference
  • Displaying an average of selected values
  • Setting column width and row height
  • Merging and centering cell text
  • Applying number format
  • Applying conditional formatting
  • Applying conditional formatting using multiple criteria
  • Copying format of one range to another
  • Formatting a worksheet
  • Deleting duplicate rows and sorting the table
  • Configuring Page Setup for printing
  • Setting margins for printing
  • Adding a header and footer
  • Printing repeated header rows
  • Specifying a print area and checking its layout
  • Increasing chart length and breadth
  • Splitting a worksheet horizontally
  • Adding and hiding a column and a row
  • Inserting, renaming, and hiding a worksheet
  • Creating a sheet and coloring the sheet tab
  • Copying a sheet to another workbook
  • Applying Solid Fill Blue Data Bar to a range
  • Applying conditional formatting on the cells
  • Inserting SmartArt
  • Adding watch options for cell values
  • Using the text function
  • Changing the font size of a heading style
  • Applying a theme to a worksheet
  • Unmerging previously merged cells
  • Splitting range into columns
  • Removing a background image
  • Adding a custom view
  • Editing a defined range
  • Filtering data
  • Applying a Table Style
  • Resetting chart formatting to match the existing style
  • Using Sparklines to illustrate data trends
  • Changing the Sparkline style
  • Configuring arrow width
  • Allowing users to format cells in a protected sheet
  • Enabling Track Changes
  • Hiding sheet tabs and scroll bars
  • Changing default display options
  • Changing the movement behavior of a selection
  • Configuring default workbook settings
  • Changing the gridline color
  • Using the COUNTIF function
  • Displaying formulas
  • Creating a table
  • Implementing data validation