77-888 : MOS: Microsoft Excel 2010 Expert LABS

77-888-lab
MOS: Microsoft Excel 2010 Expert LABS
ISBN : 978-1-61691-548-3
Gain hands-on expertise in Microsoft 77-888 certification exam by MOS: Microsoft Excel 2010 Expert 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 Excel 2010 Expert performance based labs cover all the objectives of 77-888 exam which includes sharing and maintaining workbooks, applying formulas and functions, creating and manipulating data, formatting data and content, creating and modifying formulas and functions, presenting data visually, and working with macros and forms.

Here's what will you get

The Microsoft Office Specialist: Excel 2010 Expert certification is an industry recognized credential. This certification is proof of a person's competence across a spectrum of skills which measures your knowledge and efficiency especially at sharing and maintaining workbooks, applying formulas and functions, creating and manipulating data, formatting data and content, creating and modifying formulas and functions, presenting data visually, and working with macros and forms and so on.

The Excel 2010 Expert exam is a standalone certification from Microsoft with the exam code 77-888. The certification is targeted at creating business deliverable with Microsoft Office Excel 2010 Expert and might have experience with previous versions of Microsoft Office Excel. This exam is an upgrade of Microsoft Office Excel 2007 Expert.

Performance based lab
69+
Video tutorials
69+
Minutes
32+
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-888 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 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-888-lab, click here.
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 will you learn

Hands on Activities (Labs)

  • Adding a custom document property
  • Saving a workbook as a template
  • Displaying formulas instead of values
  • Enabling the R1C1 reference style for formulas
  • Modifying cell styles
  • Creating a custom fill sequence
  • Displaying the Developer tab
  • Setting the language option
  • Translating a text
  • Checking a workbook for compatibility issues
  • Using Gradient Fill formatting for cells
  • Using Color Scales formatting for cells
  • Checking accessibility issues and exporting a worksheet as an XPS file
  • Removing all conditional formatting
  • Print comments as displayed on sheet
  • Adding an entry for AutoCorrect
  • Applying the percent number formatting
  • Applying the custom number formatting
  • Encrypting a workbook and marking it as final
  • Adding a digital signature
  • Allowing formatting of cells in a protected sheet
  • Configuring the saving of change history
  • Tracking the changes made by other users
  • Listing tracked changes in a separate sheet
  • Disabling tracking
  • Viewing comments one-by-one
  • Deleting comments
  • Adding Compare and Merge button to the Quick Access Toolbar
  • Adding a cell to Watch Window
  • Evaluating and correcting a formula
  • Enabling the error checking rules for formulas
  • Enabling background error checking for formulas
  • Configuring formula error checking rules
  • Ignoring invalid data entered in a table
  • Enabling iterative calculation for formulas
  • Disabling the AutoComplete feature for formulas
  • Configuring a calculation option for formulas
  • Configuring error checking rules for formulas
  • Applying rules
  • Using conditional formatting rules manager
  • Using the AVERAGEIFS function
  • Using multiple criteria in the COUNTIFS function
  • Using multiple criteria with the SUMIFS function
  • Using the SUMIF function
  • Using the MODE function
  • Using the MIN function
  • Using the conditional formatting formula
  • Using the ROWS and COLUMNS functions
  • Using the ISERR function
  • Using the COUNTBLANK function
  • Using a nested function
  • Printing the current date and time
  • Transposing a cell range
  • Using the TRIM function
  • Applying a custom date format
  • Customizing date format
  • Removing leading and trailing spaces
  • Creating a custom color set for a theme
  • Adding an exponential trendline to a chart
  • Saving a chart template file
  • Hiding the chart tips
  • Adding the Solver option in the Ribbon
  • Using icons in conditional formatting
  • Creating a pivot table
  • Creating a pivot table on a certain location
  • Adding a column to a pivot table
  • Creating a pivot chart and a pivot table
  • Applying a built-in style on a chart
  • Viewing existing data connections
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