|
|
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
|
|