| EXCEL 2000 CORE USER SKILL SETS FOR Microsoft Office Specialist CERTIFICATION This table below lists the skill sets and activities performed by individuals as Core Users. |
|
Skill Sets: Activities |
Excel 2000 |
Excel 2000 Intermediate |
|
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 |
|
|
|
Skill Sets: Activities |
Excel 2000 |
Excel 2000 Intermediate |
|
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 |
|
|
| Back to top | ||
| Back to Microsoft Office Specialist for Office 2000 | ||
|