MCAS Excel Excel Beginning Excel Intermediate Excel Advanced  

Index Beginning Microsoft Excel 2007 Exam 77-602 Guide
Autofit row height and column width, 5 Chart a trend over time, 10 Chart Percentages, 35 Chart Titles, 16 Charts: Add and remove elements, 34 Charts: Axis information, 11 Charts: Axis information, 38 Charts: Create a column chart, 8 Charts: Format with Quick Layouts, 35 Charts: Format with Quick Styles, 14 Charts: Represent data sources, 34 Charts: Select data sources, 7 Charts: Size a chart , 9 Conditional Logic: IF, 68	Fill a series with formatting only, 4 Fill a series without formatting, 4 Format all cells in a row or column, 26 Format all cells in a row or column, 53 Format cell borders, 31 Format cells using Quick Styles, 44 Format text: font, alignment, 25 Format the decimal places, 58 Format worksheet color, 15 Format worksheet color, 42 Formula using relative references, 28 Formula using relative references, 55 Function: AVERAGE, 61 Function: COUNT, 63 Function: COUNTA, 64 Function: MAX, 66 Function: MIN, 67 Function: SUM, 60	Headers and Footers,48 Headers and Footers: Add the date  49 Hide a row or column, 32 Hide and unhide worksheets, 73 Margins: Set  to specified values, 47 Margins: Set margins, 46 Modify row height and column width, 6 Page Setup: Change the orientation, 45 Paste Special (Paste values), 17 Picture: Insert pictures, 36 Save as a macro-enabled workbook, 80 Save in a previous version, 79 Save workbooks, 77 Subtotals: AVERAGE  a filtered list, 61 Tabs: Add color to worksheet tabs, 33 Theme: Modify and save a theme, 40 Theme: Use themes on worksheets, 39 Unhide a row or column, 32 View: Change zoom level, 71 View: Hide the Ribbon, 76 View: Open and arrange windows, 72