Search                            Français                            

 

 

 

 

 

Profile

Corporate Solutions

Accounting

Training

Certification

Request

Feedback

Career Area

Contact Us

                                            

                   

Excel 2000

 

Microsoft Excel 2000 Exam Objectives

Skill Sets

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, 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, comma)
  • 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 & 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 & 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 & functions

  • Enter a range within a formula by dragging
  • Enter formulas in a cell and using 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, 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 chart wizard to create a chart
  • Modify charts
  • Insert, move, and delete an object (picture)
  • Create and modify lines and objects

 

Word2000 ] [ Excel2000 ] Word2000 Expert ] Excel2000 Expert ] PowerPoint2000 ] Access2000 ] Outlook2000 ] Project2000 ] Project2000 Expert ]

 

Home ] Search ] Request ] Feedback ] Site Map ] Contact us ]

 

Send mail to webmaster@office-technologies.com with questions or comments about this web site.
Copyright © 1996 Office Technologies Inc.
Last modified: May 12, 2006