LEADER 00000nam a22004333i 4500
001 EBC3410568
003 MiAaPQ
005 20200713055408.0
006 m o d |
007 cr cnu||||||||
008 200713s2004 xx o ||||0 eng d
020 9781590956427|q(electronic bk.)
035 (MiAaPQ)EBC3410568
035 (Au-PeEL)EBL3410568
035 (CaPaEBR)ebr10077714
035 (OCoLC)923426679
040 MiAaPQ|beng|erda|epn|cMiAaPQ|dMiAaPQ
050 4 QA76.3.S3577 2003
100 1 Schipper, BJ
245 10 ExamInsight For Microsoft Office Specialist Certification
:|bExcel 2002 (XP) Expert Exam
264 1 Friendswood :|bTotalRecall Publications,|c2004
264 4 |c©2003
300 1 online resource (345 pages)
336 text|btxt|2rdacontent
337 computer|bc|2rdamedia
338 online resource|bcr|2rdacarrier
505 0 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
505 8 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
505 8 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
505 8 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
505 8 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
:
505 8 To delete records:
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 2002 (XP) Expert
Exam|dFriendswood : TotalRecall Publications,c2004
856 40 |uhttps://ebookcentral.proquest.com/lib/sinciatw/
detail.action?docID=3410568|zClick to View
