Record:   Prev Next
Author Schipper, BJ
Title ExamInsight For Microsoft Office Specialist Certification : Excel 2002 (XP) Expert Exam
Imprint Friendswood : TotalRecall Publications, 2004
©2003
book jacket
Descript 1 online resource (345 pages)
text txt rdacontent
computer c rdamedia
online resource cr rdacarrier
Note Intro -- Table of Contents -- ExamInsight For Microsoft Excel 2002 -- About the Author -- About the Book -- Introduction -- Exam Preparation Guide -- UNIT ONE Chapter One: Introduction to Excel 2002 -- Starting Excel -- To start Excel 2002, simply -- Title Bar -- Menus -- Toolbars -- Spreadsheet Window -- Status Bar -- Shortcut Menus -- View Options -- Terminology -- The following list of terms will be helpful when using Excel -- Help -- Office Assistant -- OR -- OR -- Traditional Help -- 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 -- TRY IT: -- Editing Data -- Moving the cursor -- Inserting Characters -- Replacing Characters -- To replace characters: -- Deleting Characters -- The Marvelous Undo Button -- Navigating a Spreadsheet -- Navigating with the keyboard -- Navigating with a mouse -- Saving Your Work -- The Save As Command -- To save a workbook for the first time: -- The Save Command -- Opening Existing Workbooks -- Navigating Multiple Workbooks -- Applying the Knowledge -- You wish to create a new spreadsheet. To do this you will b -- Lesson Review -- Review Questions -- Review Answers -- UNIT ONE Chapter Three: Formatting Spreadsheets -- Formatting Spreadsheets -- The Number tab -- Alignment -- Related toolbar buttons: -- Fonts -- Related toolbar buttons: -- Borders -- Related toolbar button: -- Patterns -- The Protection tab -- Using the Toolbar -- Column Width -- 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
You wish to format a new file. You will open the file you cr -- Lesson Review -- Review Questions -- Review Answers -- UNIT ONE Chapter Four: Working With Content -- Selecting Cells -- Methods of Selecting -- Selecting cells using the I-beam pointer: -- To select cells using the keyboard: -- To select an entire worksheet: -- OR -- To deselect text: -- Selecting Ranges -- Select a range using the mouse: -- Select a range using the keyboard: -- Selecting non-contiguous ranges: -- 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: -- The result is: -- To Replace content: -- Shortcut Menus -- Right click on a toolbar. -- Lists -- To create lists: -- Applying the Knowledge -- Lesson Review -- Review Questions -- Review Answers -- UNIT ONE Chapter Five: Formulas and Functions -- Formulas -- Mathematical Operators -- Entering Formulas -- Subtraction: -- Functions -- Categories of Functions -- Function Examples -- Average Function: -- The Results: -- The Auto Function Feature -- Applying the Knowledge -- Lesson Review -- Review Questions -- Review Answers -- UNIT ONE Chapter Six: 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 -- The options on this screen include: -- Manual/Auto Calculations -- To set manual calculation: -- 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 -- UNIT TWO Chapter One: Customization and Styles -- 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 -- Moving Worksheets -- To move a worksheet: -- To copy a worksheet: -- Naming Worksheets -- To rename a worksheet -- Deleting Worksheets -- To delete one or more worksheets: -- OR -- 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: Formatting and Validation -- Special Formats -- To apply a special formula: -- Conditional Formatting -- To apply conditional formatting: -- 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 -- 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 -- You wish to create charts. -- Create a separate sheet chart: -- Create an embedded chart: -- Lesson Review -- Review Questions -- Review Answers -- UNIT TWO Chapter Four: Range Names and Functions -- Range Names -- To name a range: -- Using Named Ranges in Formulas: -- More Functions -- IF function -- The example: -- 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: -- Let's practice on a real example. -- 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: -- Try some of the other Spreadsheet Solutions. -- Applying the Knowledge -- Lesson Review -- Review Questions -- Review Answers -- UNIT THREE Chapter Two: Protection -- Protect workbooks -- To unprotect a workbook: -- Protect worksheets -- 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: -- TRY IT: -- 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 -- Borders -- Adding a border to an object: -- OR -- 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 data using a form: -- Adding Records -- To add a record: -- Editing and Deleting Records -- To edit records:
To delete records:
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 2002 (XP) Expert Exam Friendswood : TotalRecall Publications,c2004
Subject Microsoft Excel (Computer file);Microsoft software -- Examinations -- Study guides.;Operating systems (Computers) -- Examinations -- Study guides
Electronic books
Record:   Prev Next