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, 29 Copy a series, 73 Ensure Data integrity, 49 Restrict data using data validation, 35 Restrict the type of data entered, 38 Restrict to: Less than x, 50 Restrict to: Specified length, 50 Restrict the values entered, 39 Create drop-down lists, 39 Remove duplicate rows 41 Change view to normal, page layout, and page break preview, 20 Copy worksheets, 76 Reposition worksheets, 76 Rename worksheets, 33 Insert and delete worksheets, 79	2. Formatting Data and Content Insert cells, rows, columns, 79 Insert above, below, left, or right, 31 Insert multiple rows or columns, 83 Format rows and columns, 19 Format all cells in a row or column, 72 Autofit row height and column width, 78 Apply number formats, 72 Format the date, 69 Create custom cell formats, 70 Format text: font, alignment, 48 Merge and split cells, 48 Add and remove cell borders, 32 Format data as a table, 8 Apply Quick Styles to tables, 15 Apply and change Quick Styles, 15 Add and remove header rows, 12 Band the rows or columns in a table, 16 Change banded rows to columns, 16 Add rows to a tables, 17 Change the total row function, 18 Insert and delete rows and columns, 19 3. Creating and Modifying Formulas Using absolute references, 86 Mixed references, 86 Troubleshoot a formula, 79 Use data from other worksheets, 80 SUM, 30   4. Presenting Data Visually Conditional formatting, 55 Edit a conditional formatting rule, 60 More than one rule, 56 Highlight, 44, Top and bottom rules, 56 Data bars, 57, Color scales, 58 Icon sets, 59 Insert pictures, 46, Modify pictures, 47 Sort and filter data, 6   5. Collaborating and Securing Data Use Compatibility Checker, 63 Save to the Excel 97-2003 format, 63 Set print options, 23 Define the print area, 23 Move a page break, 22 Preview and change a page break, 22 Change the orientation  21 Scale worksheet to fit  24