ExamInsight for Microsoft Office specialist certification : Excel 2002 (XP) expert exam / B.J. Schipper, Mary Lemond.

Format:

Book

Author/Creator:

Schipper, B. J.

Contributor:

Lemond, Mary.

Series:

IT TotalRecall certification system series.

The IT TotalRecall Certification System Series

Language:

English

Subjects (All):

Microsoft software--Examinations--Study guides.

Microsoft software.

Operating systems (Computers)--Examinations--Study guides.

Operating systems (Computers).

Microsoft Excel (Computer file).

Physical Description:

1 online resource (345 p.)

Edition:

1st ed.

Place of Publication:

Friendswood, TX : TotalRecall Publications, c2003.

Language Note:

English

Contents:

Intro

Table of Contents

ExamInsight For Microsoft Excel 2002

About the Author

About the Book

Introduction

Exam Preparation Guide

UNIT ONE Chapter One: Introduction to Excel 2002

Starting Excel

To start Excel 2002, simply

Title Bar

Menus

Toolbars

Spreadsheet Window

Status Bar

Shortcut Menus

View Options

Terminology

The following list of terms will be helpful when using Excel

Help

Office Assistant

OR

Traditional Help

Applying the Knowledge

Lesson Review

Review Questions

Review Answers

UNIT ONE Chapter Two: Creating a Spreadsheet

Entering and Editing Worksheet Entries

Text

Numbers

Entering Dates

TRY IT:

Editing Data

Moving the cursor

Inserting Characters

Replacing Characters

To replace characters:

Deleting Characters

The Marvelous Undo Button

Navigating a Spreadsheet

Navigating with the keyboard

Navigating with a mouse

Saving Your Work

The Save As Command

To save a workbook for the first time:

The Save Command

Opening Existing Workbooks

Navigating Multiple Workbooks

You wish to create a new spreadsheet. To do this you will b

UNIT ONE Chapter Three: Formatting Spreadsheets

Formatting Spreadsheets

The Number tab

Alignment

Related toolbar buttons:

Fonts

Borders

Related toolbar button:

Patterns

The Protection tab

Using the Toolbar

Column Width

To set the width of one column:

To set the width of a RANGE of columns:

To have Excel set the width of the column (AutoFit) to accom

Inserting Rows and Columns

To insert COLUMNS into a spreadsheet:

Inserting a ROW into a spreadsheet:

Using the Keyboard Shortcuts

Applying the Knowledge.

You wish to format a new file. You will open the file you cr

UNIT ONE Chapter Four: Working With Content

Selecting Cells

Methods of Selecting

Selecting cells using the I-beam pointer:

To select cells using the keyboard:

To select an entire worksheet:

To deselect text:

Selecting Ranges

Select a range using the mouse:

Select a range using the keyboard:

Selecting non-contiguous ranges:

Moving Cells

To Move a single cells content:

To Move multiple cells:

Copying Cells

To Copy a single cells content:

To Copy multiple cells:

Find and Replace

To Find specific content:

The result is:

To Replace content:

Right click on a toolbar.

Lists

To create lists:

UNIT ONE Chapter Five: Formulas and Functions

Formulas

Mathematical Operators

Entering Formulas

Subtraction:

Functions

Categories of Functions

Function Examples

Average Function:

The Results:

The Auto Function Feature

UNIT ONE Chapter Six: Printing

Print Preview

To use print preview:

Printing a spreadsheet:

To print:

Page Setup

The page tab.

The Margins Tab

The Header/Footer Tab

The Sheet tab

The options on this screen include:

Manual/Auto Calculations

To set manual calculation:

To establish automatic calculation:

Cell Referencing

Relative Cell Reference

Absolute Cell References

The Absolute Key

Copying Formulas (Fill Handle)

Using the Fill Handle:

UNIT TWO Chapter One: Customization and Styles

Customizing The Work Area.

Using Built-in Toolbars

Adding, deleting, and rearranging toolbars buttons

Try it:

Restoring a toolbar to its default settings.

Creating Custom Toolbars

To Delete a Custom toolbar:

Styles

Using built-in styles

AutoFormat

Creating your own styles

Creating a style by example:

Creating a style by definition:

Applying your new style:

Deleting a Style

Sharing Styles

UNIT TWO Chapter Two: Multiple Worksheet Fundamentals

Moving Between Worksheets

To select contiguous worksheets:

To select a non-contiguous set of sheets:

To deselect multiple sheets:

Adding Worksheets

Moving Worksheets

To move a worksheet:

To copy a worksheet:

Naming Worksheets

To rename a worksheet

Deleting Worksheets

To delete one or more worksheets:

Copying Data Between Two Worksheets

To copy data between two worksheets:

Viewing Multiple Worksheets

To view multiple worksheets:

Three Dimensional Formulas

The Keyboard Entry method:

The Cell Selection Method:

Workspaces

Saving multiple Workbooks as a Workspace.

To test the Workspace:

Closing Multiple Files

UNIT TWO Chapter Three: Formatting and Validation

Special Formats

To apply a special formula:

Conditional Formatting

To apply conditional formatting:

To locate all cells containing conditional formatting:

Data Validation

To set data validation:

To create an input message that displays when the cell(s) is

Information

Warning

Stop

To locate all cells in a worksheet containing data validatio

Charts

To create a chart:

Using the Chart Wizard

To change the chart type:

Chart Location.

To place a chart as a new sheet:

To place the chart in an existing worksheet:

Working with Charts

The Chart Toolbar

To use the Chart Objects and Format tools:

The Chart Menu

Deleting a Chart

Printing a Chart

To print a chart only:

User-Defined Charts

To create a user-defined chart:

To apply a user-defined chart:

You wish to create charts.

Create a separate sheet chart:

Create an embedded chart:

UNIT TWO Chapter Four: Range Names and Functions

Range Names

To name a range:

Using Named Ranges in Formulas:

More Functions

IF function

The example:

Vlookup Function

UNIT TWO Chapter Five: Viewing files

Hiding and Unhiding

To hide a column using the menu:

To hide columns using the mouse:

Unhiding Columns

To unhide a column using the menu:

To unhide a column using the mouse:

Freeze Panes

To freeze row panes:

To freeze column panes:

To freeze both rows and columns:

Split View

To horizontally split the worksheet into two views:

To vertically split a worksheet into two views:

To split a worksheet into four views:

Moving between split views:

Clearing a Split View:

Adding Comments

To add a comment to a cell:

To edit a comment:

To delete a comment:

To Print comments associated with a worksheet:

Example:

Custom Views

Creating Views:

Showing Views:

Outlining

UNIT TWO Chapter Six: Managing Workbooks

Building a Linking Formula with External References

Building formals that link workbooks:

Let's practice on a real example.

Saving linked files.

Maintaining Workbook Links

Workbook versus links and workspaces

Consolidation

Preparing to consolidate

Goal Seek and Solver Utilities

Using Goal Seek

Now use the Goal Seeker utility to do the work for you.

Solver

The difference between Goal seek and Solver is:

Excel Default Settings and Options

UNIT THREE Chapter One: Excel Templates

Creating Your Own Templates:

Opening a Template file:

Built-In Interactive Templates

To use the specialized templates:

Try some of the other Spreadsheet Solutions.

UNIT THREE Chapter Two: Protection

Protect workbooks

To unprotect a workbook:

Protect worksheets

Testing the protection:

File Password Protection

To save a file with a password:

To remove a password:

Other File Protection Options

UNIT THREE Chapter Three: Graphics in Excel

Importing Graphics

To insert a picture from Excel's Clip Art Gallery:

To insert an existing graphic:

Drawing Worksheet Elements

To view the Drawing toolbar:

To draw a rectangle, oval, line or arrow:

To create a text box:

To create other shapes:

Word Art

To create WordArt:

WordArt Toolbar Options

Adding a border to an object:

UNIT THREE Chapter Four: Databases

An Example of an Excel worksheet being used as a database:

Designing a Database:

To create a database:

Entering Data

To enter data using a form:

Adding Records

To add a record:

Editing and Deleting Records

To edit records:.

To delete records:.

Notes:

Bibliographic Level Mode of Issuance: Monograph

ISBN:

978058547785X

0-585-47785-X

OCLC:

70724145