LEADER 00000nam a22004333i 4500 
001    EBC3410571 
003    MiAaPQ 
005    20200713055408.0 
006    m     o  d |       
007    cr cnu|||||||| 
008    200713s2004    xx      o     ||||0 eng d 
020    9781590956410|q(electronic bk.) 
035    (MiAaPQ)EBC3410571 
035    (Au-PeEL)EBL3410571 
035    (CaPaEBR)ebr10077722 
035    (OCoLC)842581841 
040    MiAaPQ|beng|erda|epn|cMiAaPQ|dMiAaPQ 
050  4 QA76.3.S345 2003 
100 1  Schipper, BJ 
245 10 ExamInsight For Microsoft Office Specialist Certification 
       :|bExcel 2000 Expert Exam 
264  1 Friendswood :|bTotalRecall Publications,|c2004 
264  4 |c©2003 
300    1 online resource (357 pages) 
336    text|btxt|2rdacontent 
337    computer|bc|2rdamedia 
338    online resource|bcr|2rdacarrier 
505 0  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 
505 8  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 
505 8  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 
505 8  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 
505 8  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 
505 8  Introduction to Macros 
588    Description based on publisher supplied metadata and other
       sources 
590    Electronic reproduction. Ann Arbor, Michigan : ProQuest 
       Ebook Central, 2020. Available via World Wide Web. Access 
       may be limited to ProQuest Ebook Central affiliated 
       libraries 
650  0 Microsoft Excel (Computer file);Microsoft software -- 
       Examinations -- Study guides.;Operating systems 
       (Computers) -- Examinations -- Study guides 
655  4 Electronic books 
776 08 |iPrint version:|aSchipper, BJ|tExamInsight For Microsoft 
       Office Specialist Certification : Excel 2000 Expert Exam
       |dFriendswood : TotalRecall Publications,c2004 
856 40 |uhttps://ebookcentral.proquest.com/lib/sinciatw/
       detail.action?docID=3410571|zClick to View