1. Managing the Worksheet Environment 1.1. Navigate Through a Worksheet Navigate with Named Ranges, Pg 88   1.2. Print a Worksheet or Workbook Print: Print Selected Worksheets, Pg 168 Print: Print Entire Workbook, Pg 167 Page Setup: Headers and Footers, Pg 159 Page Layout: Sheet Options, Pg 165   2. Creating Cell Data, 2.1. Construct cell data, Cell Data: Paste Special, Pg 57   2.2. Apply AutoFill, AutoFill: Copy the Data, Pg 20 AutoFill: Fill a Series, Pg 18 AutoFill: Drop Down List Options, Pg 19   2.3. Apply and manipulate hyperlinks, Hyperlink: Create a Hyperlinkl, Pg 198 Hyperlink: Modify Hyperlink Options, Pg 195 Hyperlink: Modify Hyperlink in a Cell, Pg 193 Hyperlink: Remove a Hyperlink, Pg 199 3. Formatting Cells and Worksheets 3.1. Apply and modify cell formats Cell Data: Paste Special, Pg 57   3.2. Merge or split cells, Formatting Issues with Merge, Pg 45 Format Cells: Unmerge Cells, Pg 44   3.3. Create Row and Column Titles Page Setup: Print Titles, Pg 156 Print Rows that Repeat, Pg 156 Print Columns that Repeat, Pg 156 Headers/Footers: Odd or Even Pages, Pg 164 Headers/Footers: Different First Page, Pg 161     3.4. Hide and Unhide Rows and Columns 3.5. Page Setup Options for Worksheets Page Setup: Orientation, Pg 149 Page Layout: Page Scaling, Pg 166 Page Setup: Margins, Pg 150 Header and Footer: Scale and Align, Pg 161 Microsoft Excel 2010 Study Guide: Intermediate Excel              Microsoft Office Specialist (MOS): Exam 77-882 for Excel 2010