| 000 | 11232nam a22004813i 4500 | ||
|---|---|---|---|
| 001 | EBC3410571 | ||
| 003 | MiAaPQ | ||
| 005 | 20240729125549.0 | ||
| 006 | m o d | | ||
| 007 | cr cnu|||||||| | ||
| 008 | 240724s2004 xx o ||||0 eng d | ||
| 020 |
_a9781590956410 _q(electronic bk.) |
||
| 035 | _a(MiAaPQ)EBC3410571 | ||
| 035 | _a(Au-PeEL)EBL3410571 | ||
| 035 | _a(CaPaEBR)ebr10077722 | ||
| 035 | _a(OCoLC)842581841 | ||
| 040 |
_aMiAaPQ _beng _erda _epn _cMiAaPQ _dMiAaPQ |
||
| 050 | 4 | _aQA76.3.S345 2003 | |
| 100 | 1 | _aSchipper, BJ. | |
| 245 | 1 | 0 |
_aExamInsight For Microsoft Office Specialist Certification : _bExcel 2000 Expert Exam. |
| 250 | _a1st ed. | ||
| 264 | 1 |
_aFriendswood : _bTotalRecall Publications, _c2004. |
|
| 264 | 4 | _c©2003. | |
| 300 | _a1 online resource (357 pages) | ||
| 336 |
_atext _btxt _2rdacontent |
||
| 337 |
_acomputer _bc _2rdamedia |
||
| 338 |
_aonline resource _bcr _2rdacarrier |
||
| 505 | 0 | _aIntro -- 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 | _aLesson 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 | _aAutoformat -- 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 | _aUser-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 | _aOpening 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 | _aIntroduction to Macros. | |
| 588 | _aDescription based on publisher supplied metadata and other sources. | ||
| 590 | _aElectronic 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 | _aMicrosoft Excel (Computer file). | |
| 650 | 0 | _aMicrosoft software -- Examinations -- Study guides. | |
| 650 | 0 | _aOperating systems (Computers) -- Examinations -- Study guides. | |
| 655 | 4 | _aElectronic books. | |
| 776 | 0 | 8 |
_iPrint version: _aSchipper, BJ _tExamInsight For Microsoft Office Specialist Certification _dFriendswood : TotalRecall Publications,c2004 |
| 797 | 2 | _aProQuest (Firm) | |
| 856 | 4 | 0 |
_uhttps://ebookcentral.proquest.com/lib/orpp/detail.action?docID=3410571 _zClick to View |
| 999 |
_c90646 _d90646 |
||