Overview

If you are looking to better represent data visually and validate your skills on Microsoft Excel 2016, this is the ideal skill enhancement tool for you.

Professionals seeking a comprehensive understanding of workbook and worksheet creation and management will greatly benefit from The Microsoft 77-727 Practice Lab. Not only will this lab allow you to gain hands-on skills needed to navigate Excel 2016 in an enterprise environment, but it will also prepare you to confidently ace the Microsoft 77-727 certification exam.

Microsoft Office Specialist (MOS) 2016 certification exams introduce a new performance-based format for improved testing of a candidate's knowledge, skills, and abilities using the MOS 2016 programs:

  • MOS 2016 exam task instructions generally do not include the command name, as in previous versions. For example, function names are avoided and are replaced with descriptors. This means candidates must understand the purpose and common usage of the program functionality in order to successfully complete the tasks in each of the projects.

  • The MOS 2016 exam format incorporates multiple projects.

Obtaining your certification signifies that you possess the fundamental knowledge to create and edit a workbook with multiple sheets, and use graphic elements to represent data visually. Workbook examples include professional-looking budgets, financial statements, team performance charts, sales invoices, and data-entry logs.

Topics of Emphasis

  • Create Worksheets and Workbooks

  • Navigate Excel

  • Modify a Worksheet

  • Customize Excel

  • Print Workbooks and Worksheets

  • Understand Workbook Properties

  • Manage Data Entry

  • Format Cells and Ranges

  • Summarize, Organize and Format Data

  • Create and Manage Tables

  • Manage Table Styles and Options

  • Understand Cell References and Formulas

  • Perform Calculations using SUM MIN MAX Functions

  • Perform Conditional Operations Using Functions

  • Format and Modify Text Using Functions

  • Create Charts

  • Insert and Format Objects

Practice Lab Specifications

Practice Labs are pre-configured hardware layouts with accompanying lab guides for fast, convenient access that make studying for an exam or learning new technologies an engaging experience. Develop your comprehensive IT skills in a safe, working environment without the need to invest in your own hardware and software.

  • Practical Training on the Latest Industry Technology

  • Real Equipment, No Simulations

  • 6 Month Unified Access Available on Any Device

  • No Hardware or Licensing Costs

System Requirements

Recommended Hardware:

  • Screen dimensions: 1920px x 1080px or higher (full HD or higher)

  • Processor speed: 2Ghz / multi-core

  • Broadband / Internet access requirements: 5mb download, 1mb upload

Minimum Hardware:

  • Screen dimensions: 1280px x 1024px

  • Processor speed: 1.5Ghz

  • Broadband / Internet access requirements: 2mb download, 256kpbs upload

Operating Systems:

  • Microsoft Windows XP with SP2/Vista/7/8/8.1/10

  • Microsoft Windows Server 2003/2008/2013

  • Linux Red Hat, Fedora, SUSE, Ubuntu

  • Apple Mac OS X

Networking:

  • Internet connection minimum of 512Kbs

  • HTTPS Access (Port 443)

  • HTTP Access (Port 80)

Software:

  • Oracle Java version 1.7+ (If using our Java client)

Browser:

HTML 5 Client

  • Microsoft Edge 13 or later

  • Microsoft Internet Explorer 10 or later

  • Chrome 29 or later

  • Firefox 45 or later

  • Apple Safari 9.1 or later

Java Client

  • Internet Explorer 10 or later

Note: For both client technologies, if you have a Pop up blocker enabled on your computer

you will need to allow popups from *.practice-labs.com as an exception.

Delivered By

Practice Labs

Practice Labs offers industry relevant IT study from the convenience of your browser, with access to "real hardware" Practice Labs, paired with step-by-step lab guides for a true reflection of real world scenarios.