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 |
|
