From the Excel 2010 CORE Exam 77-882 1. Managing the Worksheet Environment 1.1. Navigate Through a Worksheet Keyboard: Hot keys, Pg 283   1.3. Personalize the Excel Environment by Using the Backstage Quick Access: Add a Command, Pg 220 Backstage: Ribbons, Tabs, Groups, Pg 184 Data: Import Data to Excel, Pg 276 Data: Export Data From Excel, Pg 290 Backstage: Workbook Properties, Pg 223 Backstage: Save, Save As, Pg 71   2. Creating Cell Data 2.2. Apply AutoFill Format Same as Above or Below, Pg 252 From the Excel 2010 CORE Exam 77-882 7.2. Manage Comments Review: Add New Comment, Pg 215 Review: Show/Hide Comment, Pg 217 Review: Edit Comment, Pg 216 Review: Delete Comment, Pg 217   8. Analyzing and Organizing Data 8.1. Filter Data Data Filter: Define, Pg 52 Data Filter: Apply, Pg 54 Data Filter: Clear, Pg 55 Data Filter: Search, Pg 53 Data: AutoFilter, Pg 53   8.2. Sort Data Data: Sort Options, Pg 51   8.3. Apply Conditional Formatting Conditional Formatting: Apply Conditional Formatting, Pg 31 Conditional Formatting: Rules Manager, Pg 38 Conditional Formatting: Apply Conditional Formatting Based on Logical Formula, Pg 31 Conditional Formatting: Icon Sets, Pg 37 Conditional Formatting: Data Bars, Pg 35 Conditional Formatting: Clear the Rules, Pg 34 Microsoft Excel 2010 Study Guide: Advanced Excel              Microsoft Office Specialist (MOS): Exam 77-882 and 77-888 for Excel 2010