ExamInsight for Microsoft Office specialist certification : Excel 2000 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 (357 p.)

Edition:

1st ed.

Place of Publication:

Friendswood, TX : TotalRecall Publications, c2003.

Language Note:

English

Contents:

""Table of Contents""; ""ExamInsight For Microsoft Excel 2000 Expert""; ""About the Author""; ""About the Book""; ""Introduction to Excel 2000""; ""Exam Information""; ""Exam Tips""; ""General Tips""; ""Tips for Completing Questions""; ""Tips for Avoiding Errors""; ""Exam Preparation Guide""; ""UNIT ONE Chapter One: Introduction to Excel 2000""; ""Starting Excel""; ""Title Bar""; ""Menus""; ""Toolbars""; ""Spreadsheet Window""; ""Shortcut Menus""; ""View Options""; ""Terminology""; ""Help""; ""Office Assistant""; ""Traditional Help""; ""The Web""; ""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""; ""Editing Data""; ""Moving the cursor""; ""Inserting Characters""; ""Replacing Characters""; ""To replace characters""; ""Deleting Characters""; ""The Undo Feature""; ""Navigating a spreadsheet""; ""Navigating with the keyboard""; ""Navigating with a mouse""; ""Saving Your Work""; ""The Save As Command""; ""The Save Command""; ""Opening Existing Workbooks""; ""Navigating Multiple Workbooks""

""Applying the Knowledge""""Lesson Review""; ""Review Questions""; ""Review Answers""; ""UNIT ONE Chapter Three: Formatting Spreadsheets""; ""Using the Format Menu""; ""The Number tab""; ""Alignment""; ""To set the alignment of cells""; ""Fonts""; ""To change the font in a cell""; ""Borders""; ""To set the border format of cells""; ""Patterns""; ""To set a pattern for cells or ranges""; ""The Protection tab""; ""Using the Toolbar""; ""Column Width""; ""To set the width of all columns in the worksheet""; ""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""; ""Lesson Review""; ""Review Questions""; ""Review Answers""; ""UNIT ONE Chapter Four: Working with Content and Selecting C""; ""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 keyboard""

""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""; ""To Replace content""; ""Shortcut Menus""; ""Lists""; ""To create a lists""; ""Applying the Knowledge""; ""Lesson Review""; ""Review Questions""; ""Review Answers""; ""UNIT ONE Chapter Five: Formulas and Functions""; ""Mathematical Operators""; ""Entering Formulas""; ""Subtraction""; ""Functions""; ""Categories of Functions""; ""Function Examples""; ""Average Function""

""Observe the formula""

Notes:

Description based upon print version of record.

ISBN:

0-585-47784-1

1-59095-641-9

OCLC:

842581841