MCAS Excel Excel Beginning Excel Intermediate Excel Advanced  

Index Advanced Microsoft Excel 2007 Exam 77-602 Guide
Allow users to edit ranges, 107 Chart Legends, 63 Chart part of a range of data, 62 Chart Percentages, 64 Chart two data sets over time, 71 Chart: Add and remove elements, 64 Chart: Change Chart types, 95 Chart: Move an embedded chart, 98 Chart: Scale a Chart, 97 Chart: Select appropriate data, 83 Chart: Size a chart , 96 Comments: Delete comments, 104 Comments: Edit comments, 104 Comments: Insert comments, 103 Conditional Logic: AND, 68 Conditional Logic: IFERROR, 70 Conditional Logic: NOT, 69 Conditional Logic: OR, 69 Convert text to columns, 35 Convert text to columns, 36 Custom AutoFilter, 47 Cut, copy, and paste data, 4 Delete a named range, 31 Digital signatures, 110 Display and print formulas, 39 Document Inspector, 108 Enable multiple users, 107	Filter data using cell attributes, 46 Filter and sort data using conditional formatting, 55 Filter data using AutoFilter, 12 Format cells using other methods, 67 Format text by using formulas, 14 Format text: LOWER, 17 Format text: PROPER, 18 Format text: SUBSTITUTE, 19 Format text: UPPER, 17 Format worksheet watermark, 102 Function: AVERAGEIF, 28 Function: AVERAGEIFS, 29 Function: COUNT, 87 Function: COUNTIF, 26 Function: COUNTIFS, 27 Function: SUMIF, 24 Function: SUMIFS, 25 Group and ungroup data, 49 Hide and unhide rows and columns, 51 Hyperlinks, 100 Information rights management, 113 Keywords: Add to workbooks, 114 Lookup: HLOOKUP find a match, 65 Lookup: HLOOKUP find the closest, 66 Lookup: VLOOKUP find a match, 59 Lookup: VLOOKUP find the closest, 60 Mark workbooks as final, 115 Modify a named range, 32	Paste Special (Paste values), 6 Paste Special: Transpose data, 7 Paste without borders, 6 Protect workbooks and worksheets, 106 Get data from other worksheets, 56 Remove private data, 108 Require passwords, 109 Save as a PDF, 120 Save as a template, 116 Save as a Web page, 118 Select and name a range of cells, 24 Select and name a range of cells, 58 Shapes: Insert and modify shapes, 77 Share workbooks, 107 Show /hide gridlines and headers, 40 SmartArt: Insert SmartArt graphics, 75 SmartArt: Quick Styles, 77 Sort data using multiple criteria, 47 Subtotal data, 48 Subtotals: Add to grouped data, 49 Subtotals: SUM  a filtered list, 52 Table: Add and remove header rows, 84 Table: Add rows to a table, 85 Track Changes, 105 Track Changes: Resolve changes, 105 Use named ranges in formulas, 25 Using data named in different range, 29 View: Freeze and unfreeze panes, 23 View: Split windows, 22