77-727 Excel 2016 - Core Data Analysis, Manipulation and Presentation
share to:

Equip yourself with hands-on experience and practical knowledge with the Microsoft Practice Lab environment course.

Exam Prep

77-727

77-727 Excel 2016 - Core Data Analysis, Manipulation and Presentation

R1,590.00

Exam Prep

Entry

1 hour 30 minutes

The following practice exam will help you prepare for taking the real certification exam. Use Learn Mode to help validate your knowledge and understanding on an exam objective basis. When you feel you have a good understanding of the objectives attempt Exam Mode, this option will simulate the live exam experience. When you have successfully achieved a score above the pass score on a number of occasions you should feel confident to take the next step and tackle the live exam.

As much as we would like to provide the actual test questions we can’t, what we aim to do is give you a set of tools that help you in succeeding in gaining the certification you require. The key to success is to make sure you are fully prepared, this includes theoretical understanding, hands on exposure and knowledge validation. When you have all these components your path to succeeding is greatly improved.

For additional questions and support on this practice exam, please review the help section.

R1,590.00

course fees

5

modules

1 hour 30 minutes

duration

Anytime

registration

R1,590.00

course fees

5

modules

1 hour 30 minutes

duration

Anytime

registration

Payment options available to you

Certification

Once you feel confident to take the Microsoft certification exam, you will need to follow the process below to register and pay for your exam. The exam can be taken online or in a test centre near you.

  • Go to Certifications and select the certification you would like to write, click register for exam
  • Select “Schedule with Pearson VUE” when choosing an exam delivery partner
  • Sign into your Microsoft account, or create a certification profile
  • Complete the required information
  • Follow the on-screen steps to select a proctoring method (if available), schedule your exam appointment, and complete payment (if applicable).
  • Run a systems check if taking the exam online
  • Once registered, your appointment should appear in the Certification Dashboard. You can also cancel or reschedule your appointment here if you need. If you are taking an online exam, you will start your exam from here as well.

Module Outline

  • MODULE 1 | Create and manage worksheets and workbooks
  • MODULE 2 | Manage data cells and ranges
  • MODULE 3 | Create tables
  • MODULE 4 | Perform operations with formulas and functions
  • MODULE 5 | Create charts and objects

Related Products

Practice Lab

MD-100

MD-100 Windows 10

Practice Lab

77-729

77-729 PowerPoint 2016 - Core Presentation Design and Delivery Skills

Exam Prep

77-884

77-884 Outlook 2010

Practice Lab

98-366

98-366 Networking Fundamentals

Practice Lab

MO-100

MO-100 Microsoft Word 2019

Practice Lab

77-725

77-725 Microsoft Office – Word 2016

Practice Lab

MO-200

MO-200 Microsoft Excel 2019

Practice Lab

MD-101

MD-101 Managing Modern Desktops

Practice Lab

98-382

98-382 Introduction to Programming Using JavaScript

Practice Lab

98-383

98-383 Introduction to Programming Using HTML and CSS

Practice Lab

98-375

98-375 HTML5 Application Development Fundamentals

Exam Prep

77-882

77-882 Excel 2010

Practice Lab

98-364-r1

98-364-r1 Database Fundamentals - SQL Server 2016 Update

Practice Lab

98-364

98-364 Database Administration Fundamentals

Practice Lab

ORACLE-1Z0-062

ORACLE-1Z0-062 Oracle Database 12c - Installation and Administration

Exam Prep

1Z0-051

1Z0-051 Database 11g SQL Fundamentals 1

Practice Lab

SY0-601

SY0-601 CompTIA Security+

Practice Lab

N10-008

N10-008 CompTIA Network+

Practice Lab

N10-007

N10-007 CompTIA Network+

Practice Lab

XK0-004

XK0-004 CompTIA Linux+

Practice Lab

FC0-U61

FC0-U61 CompTIA IT Fundamentals+

Practice Lab

CS0-002

CS0-002 CompTIA Cybersecurity Analyst (CySA+)

PLAB-SERVER-2016-SANDBOX

PLAB-SERVER-2016-SANDBOX Practice Labs Server 2016 Sandbox

PLAB-SERVER-2012-R2-SANDBOX

PLAB-SERVER-2012-R2-SANDBOX Practice Labs Server 2012R2 Sandbox

PLAB-WS01

PLAB-WS01 Practice Labs Introduction to Wireshark

PLAB-CEH-v10

PLAB-CEH-v10 Practice Labs - Ethical Hacker v10

PLAB-WS-NMAP

PLAB-WS-NMAP Introduction to Network Security Tools

IC3-GS5 IC3

IC3-GS5 IC3 Digital Literacy Certification - Global Standard 5

Practice Lab

PLAB-DIG-LIT

PLAB-DIG-LIT Digital Literacy

Practice Lab

PLAB-CS-FUND

PLAB-CS-FUND Cyber Security Fundamentals

Practice Lab

PLABS-DFORENSIC

PLABS-DFORENSIC Computer Forensics and Investigations

Practice Lab

PLAB-AZ3

PLAB-AZ3 Azure Storage Management

Practice Lab

PLAB-AZ4

PLAB-AZ4 Azure Security Concepts

Practice Lab

PLAB-AZ2

PLAB-AZ2 Azure Management Concepts

Practice Lab

PLAB-AZ2

PLAB-AZ1 Azure Fundamentals

Practice Lab

200-301

200-301 Cisco Certified Network Associate (CCNA)