MCAS Excel Excel Beginning Excel Intermediate Excel Advanced  

Index Intermediate Microsoft Excel 2007 Exam 77-602 Guide
Autofit row height and column width, 5 Conditional formatting  55  Rules Manager, 60  Color scales, 58  Data bars, 57  Highlight, 44  Icon sets, 59  More than one rule, 56  Top and bottom rules, 56 Copy a series, 73 Copy worksheets, 76 Data Validation: Data integrity, 49 Drop-down lists, 39 Fill a series without formatting, 29 Format all cells in a row or column, 72 Format rows and columns, 19 Format text: font, alignment, 48 Format the date, 69 Format:  number formats, 72 Format: Cell borders, 32 Format: Create custom cell formats, 70 Format: Merge and split cells, 48 Formula:  absolute references, 86 Formula: SUM, 30 Formula: Troubleshoot a formula, 79 Formula: Using data from other worksheet, 80	Insert a column or row above, below, to the left, or right, 31 Insert and delete cells, rows, and columns, 79 Insert and delete worksheets, 79 Insert multiple rows or columns simultaneously, 83 Pictures: Insert pictures, 46 Pictures: Modify pictures, 47 Print: Define the print area, 23 Print: Define the print area, 23 Print: Move a page break, 22 Print: Orientation, 21 Print: Scale to fit a printed page, 24 Print: Set print options, 23 Remove duplicate rows from spreadsheet, 41 Rename worksheets, 33 Rename worksheets, 76 Reposition worksheets, 76 Restrict data using data validation, 35 Restrict the type of data that can be entered, 38 Restrict the values entered, 39 Restrict to: Less than x, 50 Restrict to: Specified length, 50	Save to the Excel 97-2003 format, 63 Sort and filter data, 6 Table: Add and remove header rows, 12 Table: Add rows, 19 Table: Quick Styles, 15 Table: Band the rows or columns,16 Table: Change rows to columns, 16 Table: Change the total row function, 18 Table: Format the columns, 16 Table: Format data as a table, 8 Table: Insert and delete rows and columns, 19 Use Compatibility Checker, 63 View:  normal, page layout, and page break preview, 20