Certification

Microsoft Office Specialist Exam Skill Standards: Excel 2000 Core

Working with Cells

• Use the Undo and Redo feature
• Clear cell content
• Enter text, dates, and numbers
• Edit cell content
• Locate a specific cell
• Insert and delete selected cells
• Cut, copy, paste, use paste special, and move selected cells
• Use the Office Clipboard
• Use the Find and Replace feature
• Clear cell formats
• Work with series by using the AutoFill feature
• Create hyperlinks

Working with Files

• Use Save
• Use Save As, and save files with different names, locations, and formats
• Locate and open an existing workbook
• Create a folder
• Use templates to create a new workbook
• Save worksheets and workbooks as Web Pages
• Send a workbook by using e-mail
• Use the Microsoft Office Assistant

Formatting Worksheets

• Apply formatting, such as fonts, sizes, colors, and styles
• Apply number formats, such as currency, percent, and dates
• Modify rows and column size
• Modify the alignment of cell content
• Adjust decimal positions
• Use the Format Painter feature
• Apply Autoformat
• Apply cell borders and shading
• Merge cells
• Rotate text and change indents
• Define, apply, and remove a style

Page Setup and Printing

• Preview and print worksheets and workbooks
• Use the Web Page Preview feature
• 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, such as gridlines, print quality, and headings for rows and columns

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 and consolidate data by using 3-D references

Working with Formulas and Functions

• Enter a range in a formula in a drag-and-drop operation
• Enter formulas in a cell and use the Formula Bar
• Revise formulas
• Use references, such as absolute and relative
• Use the AutoSum feature
• Use the Paste function to insert a function
• Use basic functions, such as AVERAGE, SUM, COUNT, MIN, and MAX
• Enter functions using the Formula Palette
• Use date functions, such as NOW and DATE
• Use financial functions, such as FV and PMT
• Use logical functions, such as 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 or graphic
• Create and modify lines and objects

Back to Microsoft Office Specialist Exams