Preparation Guide for Exam 77-602
MCAS: Using Microsoft Office Excel 2007
On This Page
 | Exam news |
| Exam topics covered |
| Audience profile |
| Credit toward certification |
| Preparation tools and resources |
| Skills measured |
Exam news
The Microsoft Certified Application Specialist (MCAS) Exam 77-602: Using Microsoft Office Excel 2007 became available in March 2007.
Exam topics covered
The following list includes the topic areas covered on this exam.
| • | Creating and manipulating data |
| • | Formatting data and content |
| • | Creating and modifying formulas |
| • | Presenting data visually |
| • | Collaborating on and securing data |
Audience profile
Candidates for this exam should have the equivalent of six months to one year of hands-on experience creating business deliverables with Microsoft Office Excel 2007 and might have experience with previous versions of Microsoft Office Excel. These candidates are especially effective and efficient at creating and manipulating data, formatting data and content, creating and modifying formulas, presenting data visually, and collaborating on and securing data.
Credit toward certification
When you pass Exam 77-602: Using Microsoft Office Excel 2007, you complete the requirements for the following certification:
| • | Microsoft Certified Application Specialist: Microsoft Office Excel 2007 |
Preparation tools and resources
To help you prepare for this exam, Microsoft Learning recommends that you have hands-on experience with the product and that you use the following training resources. These training resources do not necessarily cover all of the topics listed in the "Skills measured" section.
Classroom training
Classroom courseware is being developed. Please check back here for updated information.
Microsoft E-Learning
| • | Course 4623: What's New in Microsoft Office Excel 2007: This e-learning course, offered free for a limited time, covers the differences between Microsoft Office Excel 2007 and previous versions of the product. |
| • | Collection 5259: Core Training for Microsoft Office Excel 2007: This e-learning collection was crafted specifically to help prepare you for the exam topics. |
Microsoft Press books
| • | |
| • | Microsoft Certified Application Specialist Study Guide: 2007 Microsoft Office System Edition |
Microsoft Official Academic Course (MOAC)
| • | Course 77-602: Microsoft Office Excel 2007 (Wiley.com): This comprehensive Microsoft Official Academic Course includes a textbook, lab manual, and software. The course provides students with the conceptual understanding and real-world experience they need to be ready for the work force and to pass the Microsoft Certified Application Specialist (MCAS) exams for Microsoft Office Excel 2007. Each Microsoft Official Academic Course is aligned to existing MCAS exam objectives and includes:
|
Certiprep for 2007 Microsoft Office Certifications (Certiport.com)
Certiprep for Microsoft Office Certifications is the premier certification-simulation solution for Microsoft Certified Application Specialist certifications. Designed to replicate the certification-testing environment accurately, Certiprep corresponds directly to certification exam objectives and employs the same "live application" technology that is used in the exams.
Certiprep offers the following features and benefits.
| • | Certiprep maintains a large bank of test items that align to specific certification skill objectives. |
| • | The performance-based technology is similar to that of the certification exams, resulting in an authentic certification exam experience. |
| • | Each Microsoft Office application features a Practice Test and Learning Mode, which provide test-takers with self-paced learning and exam simulation. |
| • | Practice Test provides a testing experience that is similar to the actual certification exam experience, including time limitations and a similar user interface. Practice Test assesses initial skills or certification-exam preparedness. |
| • | Learning Mode provides feedback and step-by-step instruction for each question. |
Microsoft online resources
| • | 2007 Microsoft Office System – Learning Portal: Find special offers and information on training and certification. |
| • | Product information: Visit the Microsoft Office Excel 2007 Web site for detailed product information and download a free trial version of the product. |
| • | Microsoft Learning Community: Join newsgroups and visit community forums to connect with your peers for suggestions on training resources and advice on your certification path and studies. |
| • | TechNet: Designed for IT professionals, this site includes how-to instructions, best practices, downloads, technical resources, newsgroups, and chats. |
| • | MSDN: Designed for developers, the Microsoft Developer Network (MSDN) features code samples, technical articles, downloads, newsgroups, and chats. |
Skills measured
This exam measures your ability to accomplish the technical tasks listed in the following table.
| Skills measured by Exam 77-602 |
| Creating and Manipulating Data |
Insert data by using AutoFill. |
Ensure data integrity. |
Modify cell contents and formats. |
Change worksheet views. |
Manage worksheets. |
| Formatting Data and Content |
Format worksheets. |
Insert and modify rows and columns. |
Format cells and cell content. |
Format data as a table. |
| Creating and Modifying Formulas |
Reference data in formulas. |
Summarize data by using a formula. |
Summarize data by using subtotals. |
Conditionally summarize data by using a formula. |
Look up data by using a formula. |
Use conditional logic in a formula. |
Format or modify text by using formulas. |
Display and print formulas. |
| Presenting Data Visually |
Create and format charts. |
Modify charts. |
Apply conditional formatting. |
Insert and modify illustrations. |
Outline data. |
Sort and filter data. |
| Collaborating on and Securing Data |
Manage changes to workbooks. |
Protect and share workbooks. |
Prepare workbooks for distribution. |
Save workbooks. |
Set print options for printing data, worksheets, and workbooks. |
Note This preparation guide is subject to change at any time without prior notice and at the sole discretion of Microsoft. Microsoft exams might include adaptive testing technology and simulation items. Microsoft does not identify the format in which exams are presented. Please use this preparation guide to prepare for the exam, regardless of its format.
| • | Learn more and download samples |