Hi,
The first place that you should look at is the official Microsoft Learning page for the exams.
There are two exams for Excel 2010. The fist exam is #77-882. This exam covers all of the most commonly used features. Here is the link for that exam:
http://www.microsoft.com/learning/en/us/exam.aspx?ID=77-882
The second exam is an expert level exam. It covers more advanced features. Here is the link for this exam:
http://www.microsoft.com/learning/en/us/exam.aspx?ID=77-888
Goth pages include a "skills measured" section. This will give you a detailed list of the skills that you may be tested on. There is also a "preparation materials" section that will link you to courseware, books and practice tests to help you study.
The Office exams are simulations. This means that you will be given a task and you will be expected to complete the task. You can complete the task however you like as long as the goal is achieved. For this reason it is important to try out each of the skills
measured. Remind yourself where you would go in the Excel interface to compete certain tasks and what steps are involved.
You generally have plenty of time allotted to finish the exam but if you do not know where to go for the required features you may struggle. Practice, practice, practice!
Good luck. Please let me know if you have additional questions.
Mike Corkery, MCT, MVP (Office Systems), MCSD (Windows Store Apps), MCITP, MCPD, MSF, etc. Please do not forget to click “Vote as Helpful” if any post helps you and "Mark as Answer”if it solves the issue.
