MCAS Excel Excel Beginning Excel Intermediate Excel Advanced  

Microsoft Excel 2007 Study Guide Microsoft Certified Application Specialist (MCAS):  Microsoft Excel 2007 Exam 77-602 Guide
1. Creating and Manipulating Data Fill a series without formatting, 4 Fill a series with formatting only, 4 Paste Special (Paste values), 17 Change zoom level, 71 Hide the Ribbon 76 Open and arrange windows, 72 Hide and unhide worksheets, 73   2. Formatting Data and Content Use themes, 39 Modify and save a theme, 40 Add color to worksheet tabs, 33 Format worksheet color, 15 Format worksheet color, 42 Format cells in a row or column, 26 Format cells in a row or column, 53 Unhide a row or column, 32 Hide a row or column, 32 Autofit row height and column width, 5 Modify row height and column width, 6 Format the decimal places, 58 Format cells using Quick Styles, 44 Format text: font, alignment, 25 Add and remove cell borders, 31	3. Creating and Modifying Formulas Using relative references, 28 Using relative references, 55 SUM, 60 COUNT, 63 COUNTA, 64 AVERAGE, 61 MIN, 67 MAX, 66 Subtotals: AVERAGE  a filtered list, 61 Conditional Logic: IF, 68	4. Presenting Data Visually Select data sources for charts, 7 Create a column chart, 8 Charts: Represent data sources, 34 Chart a trend over time, 10 Format charts, 14 Format charts using Quick Styles, 35 Format charts using Quick Layouts, 35 Add and remove chart elements, 34 Axis information, 11 Axis information, 38 Chart Titles, 16 Chart Percentages, 35 Size a chart , 9 Insert pictures, 36   5. Collaborating and Securing Data Save workbooks, 77 Save in a previous version, 79 Save as a macro-enabled workbook, 80 Set margins, 46 Set margins to specified values, 47 Add and modify headers and footers, 48 Change the date in a footer, 49 Change the orientation, 45