MCAS: 77-602 Excel Exam Syllabus breakdown

The Excel 2007 exam syllabus has many changes comparing to the previous exam (2003, 2003 Expert)
The objectives are also became abstracted. The content in 2003 are much detailed to task level.
If you get confused with some 2007 sub-topic.
let's check with the breakdown below. The breakdown is summarized from the official study guide.

1. Creating and Manipulating Data
1.1. Insert data by using AutoFill
- Filling Series
- AutoFill Option on adjacent cell e.g. format
- Custom Fill List
- Copy text/format to adjacent cell
1.2. Ensure data integrity
- Validation
- Remove Duplicate Rows
1.3. Modify cell contents and formats
- Paste special
1.4. Change Worksheet Views
- page layout: Views (e.g. page break view)
- Zoom
- Ribbon Display/Formula bar
- Freeze and split
- Multiple Window
1.5. Manage worksheets
- Hide/Show
- moving and copying



2. Formatting Data and Content
2.1. Format worksheets
-Themes(Apply,Modify,Custom Template)
-Page Layout: Grid lines and heading
-Worksheet Tabs name/Color/Background(WordArts)
2.2. Insert and modify rows and columns
- Insert/Delete, Hide/Show, Height/Width/AutoFit,
- Other Formating e.g. TextWrap/Align/Orientation
2.3. Format cells and cell content
- Standard Format(curreny/text/date...) , Custom Format
- Hyperlinks
- Merged Cell
- Formating(Font,border)
- Cell styles
2.4. Format data as a table
- Include Table Style,Total Row


3. Creating and Modifying Formulas
3.1. Reference data in formulas
- absolute reference, 3D reference
- name: define, manage
3.2. Summarize data using a formula
- sum/count/counta(Count empty)/average/min/max
3.3. Summarize data using subtotals
- subtotal (outlining)
3.4. Conditionally summarize data by using a formula
- averageif,countif,sumif,averageifs,countifs,sumifs
3.5. Look up data by using a formula
- vlookup/hlookup
3.6. Use conditional logic in a formula
- if,and,or,not,iferror
3.7. Format or modify text by using formulas
- lower,proper,upper,
- replace substitute
- text to columns feature
3.8. Display and print formulas
- display formula (ctrl+`)

4. Presenting Data Visually
4.1. Create and format charts
plot chart-chart type, switch column
moving to another sheet
sizing, format ->size
4.2. Modify charts
editing data
range selector
chart element
chart title/format,axes/legend, data labels,gridlines
4.3. Apply conditional formatting
4.4. Insert and modify illustrations
- insert/replace
- insert in footer
- smart arts
- sharps/replace/add text/modify
4.5. Outline data
4.6. Sort and filter data

5. Collaborating and Securing Data
5.1. Manage changes to workbooks
- change tracking
- comment
5.2. Protect and share workbooks
- password protect workbooks
- workbook/worksheet protection
- workbook sharing
5.3. Prepare workbooks for distribution
- workbook properties
- document inspectors
- restrict permission
- digital signatures
- finalizing
5.4. Save workbooks
- file format
- compatibiltiy checker
5.5. Set print options for printing data, worksheets, and workbooks
- page break
- page setup
- header and footer

Sub topics removed from the final syllabus (May be merged with others)
5.6. Filter data by using AutoFilter
5.7. Filter and sort data by using conditional formatting
5.8. Filter and sort data by using cell attributes


However, It's recommended to practice some feature not appeared but related too, for example, pivot table.