Examinsight for Microsoft Office Specialist Certification : Excel 2000 Expert Exam.

Detalles Bibliográficos
Clasificación:Libro Electrónico
Autor principal: Schipper, BJ
Formato: Electrónico eBook
Idioma:Inglés
Publicado: Friendswood : Palo Alto : TotalRecall Publications, Incorporated, Ebrary, Incorporated [distributor] Jan. 2004 ;
Temas:
Microsoft Excel (Computer file)
Microsoft software > Examinations > Study guides.
Operating systems (Computers) > Examinations > Study guides.
Logiciels Microsoft > Examens > Guides de l'étudiant.
Systèmes d'exploitation (Ordinateurs) > Examens > Guides de l'étudiant.
Microsoft software > Examinations
Operating systems (Computers) > Examinations
Study guides
Acceso en línea:Texto completo
Tabla de Contenidos:
  • 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
  • The Auto Function Feature
  • Completed Example
  • Another Example
  • Applying the Knowledge
  • Lesson Review
  • Review Questions
  • Review Answers.

Ejemplares similares