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

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.

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