EXCEL 2002
|
SKILL COMPETENCIES |
|
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 |
|
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) |
|
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
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 |