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 Outline
MODULE 1 | Managing the Worksheet Environment
MODULE 2 | Creating Cell Data
MODULE 3 | Formatting Cells and Worksheets
MODULE 4 | Manging Worksheets and Workbooks
MODULE 5 | Applying Formulas and Functions
MODULE 6 | Presenting Data Visually
MODULE 7 | Sharing worksheet data with other users
MODULE 8 | Analysing and Organising Data
NEED MORE INFORMATION ABOUT THIS COURSE?
Complete the fields below to receive the course information pack. *Required fields
By providing us with your contact details, you agree to the use of your data as described in our terms and conditions to receive communications. You may opt out of receiving communications at any time.
