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