ExamInsight For Microsoft Office Specialist Certification : Excel 2000 Expert Exam

Intro -- 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.