MCAS Excel Excel Beginning Excel Intermediate Excel Advanced  

3. Creating and Modifying Formulas SUMIF, 24 SUMIFS, 25 COUNTIF, 26 COUNTIFS, 27 AVERAGEIF, 28 AVERAGEIFS, 29 VLOOKUP: find an exact match, 59 HLOOKUP: find an exact match, 65 Conditional Logic: AND, 68 Conditional Logic: OR/ NOT, 69 Conditional Logic: IFERROR, 70 Format text by using formulas, 14 Format text: PROPER, 18 Format text: UPPER/ LOWER, 17 Format text: SUBSTITUTE, 19 Convert text to columns, 35 Display and print formulas, 39   4. Presenting Data Visually Select data sources for charts, 83 Chart part of a range of data, 62 Chart two data sets over time, 71 Add and remove chart elements, 64 Move an embedded chart, 98 Size a chart , 96, Scale a Chart, 97 Change Chart types, 95 4. Presenting Data Visually SmartArt graphics, 75 Add effects to SmartArt graphics, 77 Insert and modify shapes, 77 Subtotal data, 48 Sort data using multiple criteria, 47 Filter data using AutoFilter, 12 Custom AutoFilter, 47 Filter data with conditional formatting, 55 Filter data using cell attributes, 46   5. Collaborating and Securing Data Track Changes, 105 Insert comments, 103 Protect workbooks and worksheets, 106 Allow users to edit ranges, 107 Require passwords, 109 Enable multiple users, 107 Remove private data, 108 Document Inspector, 108 Information rights management, 113 Add keywords to the properties, 114 Add digital signatures, 110 Mark workbooks as final, 115 Save as a template, 116 Save as a PDF, 120 Save as a Web page, 118
1. Creating and Manipulating Data Cut, copy, and paste data, 4 Transpose data during paste, 7 Paste without borders, 6 Paste Special (Paste values), 6 Freeze and unfreeze panes, 23 Split windows, 22   2. Formatting Data and Content Show/hide gridlines and headers, 40 Format worksheet watermark, 102 Hide and unhide rows and columns, 51 Format cells using other methods, 67 Convert text to columns, 36 Use hyperlinks, 100 Add and remove header rows, 84 Add rows to a table, 85   3. Creating and Modifying Formulas Use data from other worksheets, 56 Select and name a range of cells, 58 Modify a named range, 32 Use named ranges in formulas, 25 COUNT, 87 Subtotals: SUM  a filtered list, 52		Microsoft Excel 2007 Study Guide Microsoft Certified Application Specialist (MCAS):  Microsoft Excel 2007 Exam 77-602 Guide