Exam 77-602:

MCAS: Using Microsoft Office Excel 2007

Published:	February 28, 2007
Language(s):	English, Russian,
Audience(s):	Information Workers
Technology:	Microsoft Office Excel 2007
Type:	Proctored Exam

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 CertificationWhen you pass Exam 77-602: MCAS: Using Microsoft Office Excel 2007, you complete the requirements for the following certification(s):

Microsoft Certified Application Specialist: Microsoft Office Excel 2007

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.

Skills Being MeasuredThis exam measures your ability to accomplish the technical tasks listed below.The percentages indicate the relative weight of each major topic area on the exam.

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.

Preparation Tools and ResourcesTo 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" tab.

Classroom Training

50041A: Preparing for the Microsoft Certified Application Specialist Exam in Microsoft Office Excel 2007

Microsoft E-Learning

Microsoft Press Books There are no Microsoft Press books currently available.

Practice Tests There are no practice tests currently available.

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:

A six-month trial copy of Microsoft Office Professional 2007
Instruction materials that emphasize building skills to prepare students for workforce success by using an instruction strategy that provides:

Authentic business scenarios
Immediate introduction of hands-on practice in each lesson
Highlighted skills that apply to the workplace and the MCAS exam

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.