77-882-lab : Microsoft Office Specialist Excel 2010 LAB

Microsoft Office Specialist Excel 2010 LAB
Rating :
Gain hands-on expertise in Microsoft 77-882 certification exam by Microsoft Office Specialist Excel 2010 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 Office Specialist Excel 2010 performance-based labs cover all the objectives of Microsoft 77-882 certification exam and include topics such as managing worksheets, workbooks, and worksheet environment; creating and formatting cells, worksheet, and cell data; applying formula and functions; and much more.

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.

Video tutorials
Exam FAQs
What are the prerequisites for this exam? There are no technical prerequisites for this certification.
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.
Where can I find more information about this exam? To know more about the 77-882-lab, click here.
Which certification covers this exam?
What are the career opportunities after passing this exam?
  • Accountants
  • Data Analysts
  • Financial Analysts
  • Sales Professionals
  • Information Workers
  • Office Professionals
  • Commercial Bankers
  • Program/Project Managers

Here's what you will learn

Hands on Activities (Labs)

  • Creating a blank workbook
  • Creating a workbook using a template
  • Using the Go To feature
  • Moving, hiding, and deleting a worksheet
  • Printing an individual worksheet
  • Specifying a print area and checking its layout
  • Adding a header and footer
  • Configuring headers and footers options
  • Setting up the AutoRecover option
  • Changing the movement behavior of a selection
  • Hiding sheet tabs and scroll bars
  • Configuring default workbook settings
  • Changing the gridline color
  • Disabling AutoRecover
  • Changing default error checking rules
  • Changing default display options
  • Saving a template file
  • Maintaining backward workbook compatibility
  • Opening a template file as a copy
  • Inspecting and marking workbooks as final
  • Protecting a workbook by encrypting it
  • Grouping multiple rows
  • Filling content through autofill
  • Cutting, Copying, and Pasting Text
  • Inserting a row in a table
  • Using the Cut and Paste commands
  • Deleting data in a cell range
  • Converting text to columns
  • Adding a custom series for the Fill Series option
  • Implementing data validation
  • Inserting a hyperlink
  • Formatting a cell
  • Changing the font size of a heading style
  • Inserting a sheet background
  • Copying format of one range to another
  • Merging and centering cell text
  • Merging cells
  • Unmerging previously merged cells
  • Moving and copying a sheet
  • Printing repeated header rows
  • Adding and hiding a column and a row
  • Configuring Page Setup for printing
  • Setting margins for printing
  • Applying a cell style to a cell range
  • Splitting range into columns
  • Applying Color Scales
  • Banding rows by conditional formatting
  • Applying a Table Style
  • Changing the theme
  • Password-protecting a workbook structure and worksheet
  • Formatting a worksheet
  • Copying a sheet to another workbook
  • Creating a sheet and coloring the sheet tab
  • Inserting, renaming, and hiding a worksheet
  • Moving and renaming a sheet
  • Applying cell borders
  • Configuring margins and orientation
  • Configuring sheet options
  • Setting column width and row height
  • Password protecting a workbook
  • Inserting a watermark
  • Applying a theme to a worksheet
  • Splitting a worksheet horizontally
  • Viewing a worksheet in full screen mode
  • Displaying formulas
  • Displaying the Page Break preview
  • Adding a custom view
  • Hiding the formula bar
  • Showing the formula bar
  • Displaying and evaluating formulas
  • Using the MIN and MAX functions
  • Using the AVERAGE function
  • Using the CONCATENATE function
  • Using the RATE function
  • Using the CONVERT function
  • Using the ROUND function
  • Using the MROUND function
  • Using the VLOOKUP function
  • Using the HLOOKUP function
  • Using the COUNTIF function
  • Concatenating text
  • Using the RIGHT and UPPER functions
  • Enforcing immediate calculation of formulas
  • Changing a relative reference to an absolute reference
  • Calculating the product of two cells
  • Using the SUBSTITUTE function
  • Calculating the surface area of a sphere
  • Editing a defined range
  • Showing cell dependency
  • Using the REPT function
  • Banding rows using Excel's table style
  • Inserting SmartArt
  • Configuring arrow width
  • Increasing chart length and breadth
  • Removing a background image
  • Using Sparklines to illustrate data trends
  • Changing the Sparkline style
  • Sharing a workbook
  • Saving a file in PDF format
  • Inserting and deleting comments
  • Editing a comment
  • Enabling Track Changes
  • Filtering data
  • Sorting a table
  • Deleting duplicate rows and sorting the table
  • Applying conditional formatting using multiple criteria
  • Applying conditional formatting
  • Using conditional formatting to highlight cells
  • Highlighting cells through Conditional Formatting
  • Formatting a cell range using conditional formatting
  • Using the Goal Seek feature
  • Adding watch options for cell values
  • Applying conditional formatting on the cells