Author Schipper, BJ
Title ExamInsight For Microsoft Office Specialist Certification : Excel 2000 Expert Exam
Imprint Friendswood : TotalRecall Publications, 2004
©2003
book jacket
Descript 1 online resource (357 pages)
text txt rdacontent
computer c rdamedia
online resource cr rdacarrier
Note 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
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 -- UNIT ONE Chapter Six: Printing, Calculations, and Referenci -- 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 -- Manual/Auto Calculations -- To establish automatic calculation -- Cell Referencing -- Relative Cell Reference -- Absolute Cell References -- The Absolute Key -- Copying formulas (Fill Handle) -- Using the Fill Handle -- Applying the Knowledge -- Lesson Review -- Review Questions -- Review Question -- UNIT TWO Chapter One: 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 -- Applying the Knowledge -- Lesson Review -- Review Questions -- Review Answers -- 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 -- To add one worksheet to a workbook -- 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 -- Applying the Knowledge -- Lesson Review -- Review Questions -- Review Answers -- UNIT TWO Chapter Three: Special Formats -- To apply a special format -- Conditional Formatting -- Set condition 1 as follows -- 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 -- Options on this toolbar include -- 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 -- Applying the Knowledge -- Lesson Review -- Review Questions -- Review Answers -- UNIT TWO Chapter Four: Range Names -- To name a range -- Using Named Ranges in formulas -- More Functions -- IF function -- Vlookup function -- Applying the Knowledge -- Lesson Review -- Review Questions -- Review Answers -- 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 -- Applying the Knowledge -- Lesson Review -- Review Questions -- Review Answers -- UNIT TWO Chapter Six: Managing Workbooks -- Building a linking formula with external references -- Building formals that link workbooks -- 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 -- Applying the Knowledge -- Lesson Review -- Review Questions -- Review Answers -- UNIT THREE Chapter One: Excel Templates -- Creating Your Own Templates
Opening a Template file -- Built-In Interactive Templates -- To use the specialized templates -- Applying the Knowledge -- Lesson Review -- Review Questions -- Review Answers -- UNIT THREE Chapter Two: Protection -- Protect workbooks -- To unprotect a workbook -- Protect worksheets -- Observe an example of the importance of protecting ranges -- To protect a file while leaving a range of cells unprotected -- Testing the protection -- File Password Protection -- To save a file with a password -- To remove a password -- Other File Protection Options -- Applying the Knowledge -- Lesson Review -- Review Questions -- Review Answers -- 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 -- Changing the WordArt object -- Borders -- Adding a border to an object -- Applying the Knowledge -- Lesson Review -- Review Questions -- Review Answers -- UNIT THREE Chapter Four: Databases -- Terminology -- An Example of an Excel worksheet being used as a database -- Designing a Database -- To create a database -- Entering Data -- To enter date using a form -- Adding Records -- To add a record -- Editing and Deleting Records -- To edit records -- To delete records -- Sorting a Database -- To sort data -- Querying A Database Using A Form -- To query a database -- Special Characters and Operators -- Queries Using AutoFilter -- To query a database using AutoFilter -- Using Operators With AutoFilter -- To query a database using relational operators -- Applying the Knowledge -- Lesson Review -- Review Questions -- Review Answers -- UNIT THREE Chapter Five: Macros
Introduction to Macros
Description based on publisher supplied metadata and other sources
Electronic reproduction. Ann Arbor, Michigan : ProQuest Ebook Central, 2020. Available via World Wide Web. Access may be limited to ProQuest Ebook Central affiliated libraries
Link Print version: Schipper, BJ ExamInsight For Microsoft Office Specialist Certification : Excel 2000 Expert Exam Friendswood : TotalRecall Publications,c2004
Subject Microsoft Excel (Computer file);Microsoft software -- Examinations -- Study guides.;Operating systems (Computers) -- Examinations -- Study guides
Electronic books