excel-2013-expert-lab : Microsoft Excel 2013 Expert Lab (77-427 & 77-428)

excel-2013-expert-lab
Microsoft Excel 2013 Expert Lab (77-427 & 77-428)
ISBN : 978-1-61691-348-9
Gain hands-on expertise in Microsoft Excel 2013 Expert certification exam by Microsoft Excel 2013 Expert (77-427 & 77-428) 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 2013 Expert certification program validates the skills and expertise of IT professionals to create advanced formulas, charts, and tables. Manage, apply, and share workbooks, custom formats, and layouts.Gain hands-on expertise in Microsoft Excel 2013 Expert certification exam by Microsoft Excel 2013 Expert (77-427 & 77-428) 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 2013 Expert certification program validates the skills and expertise of IT professionals to create advanced formulas, charts, and tables. Manage, apply, and share workbooks, custom formats, and layouts.

Here's what will you get

The MOS: Excel 2013 is a standalone certification from Microsoft with the exam code 77-427.

Professionals should be able to create, manage, and distribute professional spreadsheets for a variety of specialized purposes and situations, as well as customize their Excel environment to meet needs and enhance productivity. They should know and demonstrate the use of advanced and specialized features within the application.

Video tutorials
53+
Minutes
28+
Exam FAQs
What are the prerequisites for this exam? There are no technical prerequisites for this certification.
What is the exam registration fee? USD 100
Where do I take the exam? The Microsoft MOS certification 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 linear, performance based questions and is conducted in a live or simulated environment. The MOS 2013 certification presents the candidate with a project to build with tasks and steps that build on each other.
How many questions are asked in the exam? The exam contains 40-60 questions.
What is the duration of the exam? 90 minutes
What is the passing score? 700

(on a scale of 1-1000)

What is the exam's retake policy?

In the event that you fail your first attempt at passing the 77-427 and 77-428 examination, Microsoft's retake policy is:

  • Retake vouchers can only be used to retake the same exam that was failed.
  • All vouchers must be used prior to their expiration dates, without exception.
  • Retake vouchers must be used within 30 days of the initial failed exam.
  • There is no waiting period for retaking a failed MOS exam.
What is the validity of the certification? Microsoft Office Specialist certification does not expire. The 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 excel-2013-expert-lab, click here.
Which certification covers this exam?
What are the career opportunities after passing this exam?

The Microsoft Office Specialist(MOS): Microsoft Office Excel 2013 Expert certified professional has several career opportunities open up to them, including:

  • 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)

  • Configuring the saving of change history
  • Adding a custom document property
  • You need to see all the comments on a worksheet one-by-one.
  • Disabling tracking
  • Applying conditional formatting using multiple criteria
  • Applying conditional formatting on the cells
  • Applying conditional formatting
  • Applying rules
  • Using conditional formatting rules manager
  • Using icons in conditional formatting
  • Displaying the Developer tab
  • Checking accessibility issues
  • Setting the language option
  • Translating a text
  • Transposing a cell range
  • Using the VLOOKUP function
  • Using the HLOOKUP function
  • Printing the current date
  • Printing the current date and time
  • Increasing chart length and breadth
  • Adding an exponential trendline to a chart
  • Saving a template file
  • Creating a pivot table
  • Putting a pivot table on a certain location
  • Adding a column to a pivot table
  • Viewing existing data connections
  • Encrypting a workbook and marking it as final
  • Adding a digital signature
  • Checking a workbook for compatibility issues
  • Viewing all changes made in a workbook
  • Enabling tracking
  • Password protecting a workbook
  • Listing tracked changes in a separate list
  • Tracking the changes made by other users
  • Adding a custom series for the Fill Series option
  • Creating a custom fill sequence
  • Applying a custom date format
  • Customizing date format
  • Modifying cell styles
  • Creating a custom color set for a theme
  • Saving a workbook as a template
  • Using the AVERAGEIFS function
  • Using multiple criteria in the COUNTIFS function
  • Using multiple criteria with the SUMIFS function
  • Changing a relative reference to an absolute reference
  • Using the COUNTIF function
  • Displaying an average of selected values
  • Using the SUMIF function
  • Using a nested function
  • Enabling the error checking rules for formulas
  • Adding a cell to Watch Window
  • Evaluating and correcting a formula
  • Displaying formulas instead of values
  • Enabling iterative calculation for formulas
  • Enabling background error checking for formulas
  • Enabling the R1C1 reference style for formulas
  • Disabling the AutoComplete feature for formulas
  • Configuring a calculation option for formulas
  • Configuring error checking rules for formulas
  • Enforcing immediate calculation of formulas
  • Showing cell dependency
  • Displaying and evaluating formulas
  • Using the Goal Seek feature
  • Adding the Solver option in the Ribbon
  • Creating a pivot chart and a pivot table
  • Applying a built-in style on a chart
  • Changing the color theme of a style
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