Excel 2000 Expert

Word 2000 Expert

PowerPoint 2000
Access 2000

Word 2000
Excel 2000
Training CDs

Register

Microsoft
Training & Services
MOUS

Microsoft Excel 2000 Exam Objectives

Working with Cells

Use Undo and Redo
Clear cell content
Enter text, dates, and numbers
Edit cell content
Go to a specific cell
Insert and delete selected cells
Cut, copy, paste, paste special and move selected cells
Use the Office Clipboard
Use Find and Replace
Clear cell formats
Work with series (AutoFill)
Create hyperlinks

Working with Files

Use Save
Use Save As (different name, location, and format)
Locate and open an existing workbook
Create a folder
Use templates to create a new workbook
Save a worksheet/workbook as a Web Page
Send a workbook via email
Use the Office Assistant

Formatting Worksheets

Apply font styles (typeface, size, color, and styles)
Apply number formats (currency, percent, dates, and commas)
Modify size of rows and columns
Modify alignment of cell content
Adjust the decimal place
Use the Format Painter
Apply autoformat
Apply cell borders and shading
Merging cells
Rotate text and change indents
Define, apply, and remove a style

Page Setup and Printing

Preview and print worksheets and workbooks
Use Web Page Preview
Print a selection
Change page orientation and scaling
Set page margins and centering
Insert and remove a page break
Set print, and clear a print area
Set up headers and footers
Set print titles and options (gridlines, print quality, row &
column headings)

Working with Worksheets and Workbooks

Insert and delete rows and columns
Hide and unhide rows and columns
Freeze and unfreeze rows and columns
Change the zoom setting
Move between worksheets in a workbook
Check spelling
Rename a worksheet
Insert and Delete worksheets
Move and copy worksheets
Link worksheets & consolidate data using 3D References

Working with Formulas and Functions

Enter a range within a formula by dragging
Enter formulas in a cell and use the formula bar
Revise formulas
Use references (absolute and relative)
Use AutoSum
Use Paste Function to insert a function
Use basic functions (AVERAGE, SUM, COUNT, MIN, and MAX)
Enter functions using the Formula Palette
Use date functions (NOW and DATE)
Use financial functions (FV and PMT)
Use logical functions (IF)

Using Charts and Objects

Preview and print charts
Use the Chart Wizard to create a chart
Modify charts
Insert, move, and delete an object (picture)