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

77-882-lab
Microsoft Office Specialist Excel 2010 LAB
ISBN : 978-1-61691-265-9
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.

Labs

Online labs can be used to supplement training. uCertify labs are an inexpensive & safe way to explore and learn. uCertify labs are versatile - labs simulate real-world, hardware, software & command line interface environments and can be mapped to any text-book, course & training.

Here's What You Get

Video tutorials
113+
Minutes
55+

Hands on Activities

Managing the Worksheet Environment

  • 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

Creating Cell Data

  • 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 Cells and Worksheets

  • 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

Managing Worksheets and Workbooks

  • 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

Applying Formulas and Functions

  • 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

Presenting Data Visually

  • 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 worksheet data with other users

  • Sharing a workbook
  • Saving a file in PDF format
  • Inserting and deleting comments
  • Editing a comment
  • Enabling Track Changes

Analysing and Organising Data

  • 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

Mentoring

Mentoring is Add-on licence, please select while purchasing. Our Mentors are available 24/7 to provide you an expert support via online chating. They are subject matter experts and ready to provide answer to your questions.

Exam Information

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.

Prepare for the following certifications

Career Prospects
  • Accountants
  • Data Analysts
  • Financial Analysts
  • Sales Professionals
  • Information Workers
  • Office Professionals
  • Commercial Bankers
  • Program/Project Managers
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.
uCertify

uCertify provides courses, simulator, labs, test prep kits for IT certifications including Microsoft, Oracle, Cisco, CompTIA, CIW, PMI, ISC2, Linux, Zend, Google, IC3 , Adobe and many more.

© 2002-2017 uCertify. All Rights Reserved
app_store
google_play