MOS 2010 Study Guide for Microsoft® Excel® by Lambert, Joan -- Read -- Imperial Library of Trantor

Index

MOS 2010 Study Guide for Microsoft® Excel®

A Note Regarding Supplemental Files Taking a Microsoft Office Specialist Exam

Microsoft Office Specialist Certification Selecting a Certification Path Test-Taking Tips Certification Benefits For More Information

Using This Book to Study for a Certification Exam

Features and Conventions of This Book

Using the Book’s Companion Content

Exam 77-882: Microsoft Excel 2010

Modifying the Display of the Ribbon

Dynamic Ribbon Elements Changing the Width of the Ribbon Adapting Procedure Steps

Getting Support and Giving Feedback

Errata Getting Help with Microsoft Office 2010 We Want to Hear from You Stay in Touch

Exam 77-882 Microsoft Excel 2010

Prerequisites

Managing Worksheets Managing Worksheet Content Managing Excel Tables Managing Data Entries

1. Managing the Worksheet Environment

Navigate Through a Worksheet Print a Worksheet or Workbook

Printing Part or All of a Workbook Setting Page Breaks Printing Gridlines and Headings Printing Page Headers and Footers

Personalize the Excel Environment

Managing Program Functionality

Managing Formula Options Managing Advanced Options

Customizing the Ribbon and Quick Access Toolbar

Customizing the Ribbon Customizing the Quick Access Toolbar

Managing Workbooks

Working with Properties Working with Versions

Objective Review

2. Creating Cell Data

Construct Cell Data

Pasting Structured Data Inserting and Deleting Data

Apply Auto Fill

Filling a Data Series Copying Data

Apply and Manipulate Hyperlinks

Creating Hyperlinks Modifying Hyperlinks

Objective Review

3. Formatting Cells and Worksheets

Apply and Modify Cell Formats

Formatting Cell Content Formatting Cell Fills and Borders Setting Row Height and Column Width Formatting Numbers

Merge or Split Cells Create Row and Column Titles Hide or Unhide Rows and Columns Manipulate Page Setup Options for Worksheets Create and Apply Cell Styles Objective Review

4. Managing Worksheets and Workbooks

Create and Format Worksheets Manipulate Window Views

Freezing and Splitting Windows Displaying Multiple Windows

Manipulate Workbook Views

Switching Worksheet Views Customizing the Program Window Customizing Worksheet Appearance Changing the Zoom Level

Objective Review

5. Applying Formulas and Functions

Create Formulas Enforce Precedence Apply Cell References in Formulas Apply Conditional Logic in Formulas

Creating Conditional Formulas Nesting Functions

Apply Named Ranges in Formulas Apply Cell Ranges in Formulas Objective Review

6. Presenting Data Visually

Create Charts Based on Worksheet Data

Plotting Charts Applying Layouts and Styles Moving and Sizing Charts Editing Data Configuring Chart Elements

Apply and Manipulate Illustrations

Inserting and Formatting Clip Art Inserting and Modifying SmartArt Diagrams Inserting and Formatting Shapes Capturing Screenshots

Create and Modify Images Apply Sparklines Objective Review

7. Sharing Worksheet Data with Other Users

Share Spreadsheets

Saving Workbooks in Specific Formats Sending Workbooks

Manage Comments Objective Review

8. Analyzing and Organizing Data

Filter Data Sort Data Apply Conditional Formatting Objective Review

A. About the Authors

Joan Lambert Joyce Cox The Team Online Training Solutions, Inc. (OTSI)

About the Authors

← Prev
Back
Next →

← Prev
Back
Next →