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


5.3. Apply Cell References in Formulas

Cell References: Relative, Pg 84


5.4. Apply Conditional Logic (<,>,=),

Formulas: Logical (IF), Pg 97


6.2. Apply and Manipulate Illustrations

Illustrations: Picture, Pg 145

Illustrations: SmartArt, Pg 179

Illustrations: Shapes, Pg 170

Illustrations: Screenshot, Pg 203


6.3. Create and Modify Images by Using the Image Editor

Picture Tools: Corrections, Pg 153

Picture Tools: Adjust Color, Pg 155

Picture Tools: Artistic Effects, Pg 148


From the Excel 2010 Expert Exam 77-888

3.1. Apply Advanced Chart Features

Working with Dual Axes, Pg 134

Use a Chart Template, Pg 131