1. Managing the Worksheet Environment Backstage: Edit Default File Location, Pg 75   2. Creating Cell Data Cell Data: Cut, Pg 42 Cell Data: Move, Pg 43   3. Formatting Cells and Worksheets 3.1. Apply and modify cell formats Cell Data: Using Hot Keys, Pg 224 Format Cells: Using the Ribbon, Pg 60 Format Cells: With Format Painter, Pg 63   3.2. Merge or Split Cells Merge Cells Dialog Box, Pg 208 Merge & Center Button, Pg 34     3.4. Hide and Unhide Rows and Columns Format Cells: Hide a Column, Pg 60 Format Cells: Unhide a Column, Pg 61 Format Cells: Hide a Row, Pg 64 Format Cells: Unhide a Row, Pg 64 3.6. Create and Apply Cell Styles Cell Styles, Pg 67 Create New Cell Styles, Pg 209   4.2. Manipulate Window Views View: Split Screen, Pg 197 View: Arrange All, Pg 201 View: New Window, Pg 200   5.1. Create Formulas Use Basic Operators (+, -,*,/), Pg 56 Revise Range, Pg 91 Microsoft Excel 2010 Study Guide: Beginning Excel              Microsoft Office Specialist (MOS): Exam 77-882 for Excel 2010