ExamInsight For Microsoft Office Specialist Certification : (Record no. 90646)
[ view plain ]
| 000 -LEADER | |
|---|---|
| fixed length control field | 11232nam a22004813i 4500 |
| 001 - CONTROL NUMBER | |
| control field | EBC3410571 |
| 003 - CONTROL NUMBER IDENTIFIER | |
| control field | MiAaPQ |
| 005 - DATE AND TIME OF LATEST TRANSACTION | |
| control field | 20240729125549.0 |
| 006 - FIXED-LENGTH DATA ELEMENTS--ADDITIONAL MATERIAL CHARACTERISTICS | |
| fixed length control field | m o d | |
| 007 - PHYSICAL DESCRIPTION FIXED FIELD--GENERAL INFORMATION | |
| fixed length control field | cr cnu|||||||| |
| 008 - FIXED-LENGTH DATA ELEMENTS--GENERAL INFORMATION | |
| fixed length control field | 240724s2004 xx o ||||0 eng d |
| 020 ## - INTERNATIONAL STANDARD BOOK NUMBER | |
| International Standard Book Number | 9781590956410 |
| Qualifying information | (electronic bk.) |
| 035 ## - SYSTEM CONTROL NUMBER | |
| System control number | (MiAaPQ)EBC3410571 |
| 035 ## - SYSTEM CONTROL NUMBER | |
| System control number | (Au-PeEL)EBL3410571 |
| 035 ## - SYSTEM CONTROL NUMBER | |
| System control number | (CaPaEBR)ebr10077722 |
| 035 ## - SYSTEM CONTROL NUMBER | |
| System control number | (OCoLC)842581841 |
| 040 ## - CATALOGING SOURCE | |
| Original cataloging agency | MiAaPQ |
| Language of cataloging | eng |
| Description conventions | rda |
| -- | pn |
| Transcribing agency | MiAaPQ |
| Modifying agency | MiAaPQ |
| 050 #4 - LIBRARY OF CONGRESS CALL NUMBER | |
| Classification number | QA76.3.S345 2003 |
| 100 1# - MAIN ENTRY--PERSONAL NAME | |
| Personal name | Schipper, BJ. |
| 245 10 - TITLE STATEMENT | |
| Title | ExamInsight For Microsoft Office Specialist Certification : |
| Remainder of title | Excel 2000 Expert Exam. |
| 250 ## - EDITION STATEMENT | |
| Edition statement | 1st ed. |
| 264 #1 - PRODUCTION, PUBLICATION, DISTRIBUTION, MANUFACTURE, AND COPYRIGHT NOTICE | |
| Place of production, publication, distribution, manufacture | Friendswood : |
| Name of producer, publisher, distributor, manufacturer | TotalRecall Publications, |
| Date of production, publication, distribution, manufacture, or copyright notice | 2004. |
| 264 #4 - PRODUCTION, PUBLICATION, DISTRIBUTION, MANUFACTURE, AND COPYRIGHT NOTICE | |
| Date of production, publication, distribution, manufacture, or copyright notice | ©2003. |
| 300 ## - PHYSICAL DESCRIPTION | |
| Extent | 1 online resource (357 pages) |
| 336 ## - CONTENT TYPE | |
| Content type term | text |
| Content type code | txt |
| Source | rdacontent |
| 337 ## - MEDIA TYPE | |
| Media type term | computer |
| Media type code | c |
| Source | rdamedia |
| 338 ## - CARRIER TYPE | |
| Carrier type term | online resource |
| Carrier type code | cr |
| Source | rdacarrier |
| 505 0# - FORMATTED CONTENTS NOTE | |
| Formatted contents 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. |
| 505 8# - FORMATTED CONTENTS NOTE | |
| Formatted contents note | 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# - FORMATTED CONTENTS NOTE | |
| Formatted contents note | 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# - FORMATTED CONTENTS NOTE | |
| Formatted contents note | 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# - FORMATTED CONTENTS NOTE | |
| Formatted contents note | 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# - FORMATTED CONTENTS NOTE | |
| Formatted contents note | Introduction to Macros. |
| 588 ## - SOURCE OF DESCRIPTION NOTE | |
| Source of description note | Description based on publisher supplied metadata and other sources. |
| 590 ## - LOCAL NOTE (RLIN) | |
| Local note | Electronic reproduction. Ann Arbor, Michigan : ProQuest Ebook Central, 2024. Available via World Wide Web. Access may be limited to ProQuest Ebook Central affiliated libraries. |
| 650 #0 - SUBJECT ADDED ENTRY--TOPICAL TERM | |
| Topical term or geographic name entry element | Microsoft Excel (Computer file). |
| 650 #0 - SUBJECT ADDED ENTRY--TOPICAL TERM | |
| Topical term or geographic name entry element | Microsoft software -- Examinations -- Study guides. |
| 650 #0 - SUBJECT ADDED ENTRY--TOPICAL TERM | |
| Topical term or geographic name entry element | Operating systems (Computers) -- Examinations -- Study guides. |
| 655 #4 - INDEX TERM--GENRE/FORM | |
| Genre/form data or focus term | Electronic books. |
| 776 08 - ADDITIONAL PHYSICAL FORM ENTRY | |
| Relationship information | Print version: |
| Main entry heading | Schipper, BJ |
| Title | ExamInsight For Microsoft Office Specialist Certification |
| Place, publisher, and date of publication | Friendswood : TotalRecall Publications,c2004 |
| 797 2# - LOCAL ADDED ENTRY--CORPORATE NAME (RLIN) | |
| Corporate name or jurisdiction name as entry element | ProQuest (Firm) |
| 856 40 - ELECTRONIC LOCATION AND ACCESS | |
| Uniform Resource Identifier | <a href="https://ebookcentral.proquest.com/lib/orpp/detail.action?docID=3410571">https://ebookcentral.proquest.com/lib/orpp/detail.action?docID=3410571</a> |
| Public note | Click to View |
No items available.