The Microsoft test 77-602 (MCAS: Using Microsoft Office Excel 2007) evaluates the skills of all candidates that have six months to one year of hands-on experience of creating business reports with Microsoft Office Excel 2007. It also requires to have knowledge of using previous versions of Microsoft Office Excel.
Microsoft has specified more than twenty-eight objectives for the test 77-602 MCAS: Using Microsoft Office Excel 2007, which are grouped under five topics. Following are the important areas in which an individual should possess good knowledge before taking the 77-602 test:
- Creating and manipulating data
- Formatting data and content
- Creating and modifying formulas
- Presenting data visually
- Collaborating on and securing data
