04815nam 2200601Ia 450 991082298040332120200520144314.00-585-47784-11-59095-641-9(CKB)2550000000035643(EBL)3410571(SSID)ssj0000626339(PQKBManifestationID)11384174(PQKBTitleCode)TC0000626339(PQKBWorkID)10658554(PQKB)10897395(MiAaPQ)EBC3410571(Au-PeEL)EBL3410571(CaPaEBR)ebr10077722(OCoLC)842581841(EXLCZ)99255000000003564320050324d2003 uy 0engur|n|---|||||txtccrExamInsight for Microsoft Office specialist certification Excel 2000 expert exam /B.J. Schipper, Mary Lemond1st ed.Friendswood, TX TotalRecall Publicationsc20031 online resource (357 p.)The IT TotalRecall Certification System SeriesDescription based upon print version of record.""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""IT TotalRecall certification system series.Microsoft softwareExaminationsStudy guidesOperating systems (Computers)ExaminationsStudy guidesMicrosoft softwareExaminationsOperating systems (Computers)ExaminationsSchipper B. J1614676Lemond Mary1614677MiAaPQMiAaPQMiAaPQBOOK9910822980403321ExamInsight for Microsoft Office specialist certification3944569UNINA