|
Coding No.
|
Skill
|
Chapter
|
Page
|
|
XL2000.1
|
Working with cells
|
|
|
|
XL2000.1.1
|
Use Undo and Redo
|
2
|
C75-C76
|
|
XL2000.1.2
|
Clear cell content
|
2
|
C60-C61
|
|
XL2000.1.3
|
Enter text, dates, and numbers
|
1
|
C6-C9, C14
|
|
XL2000.1.4
|
Edit cell content
|
1
|
C10, C19-C21
|
|
XL2000.1.5
|
Go to a specific cell
|
1
|
C6-C7
|
|
XL2000.1.6
|
Insert and delete selected cells
|
1,2
|
C15-C16,C57-C61
|
|
XL2000.1.7
|
Cut, copy, paste, paste special and move selected
cells, use the Office Clipboard
|
4,5
|
C114-C116, C178-C180
|
|
XL2000.1.8
|
Use Find and Replace
|
2
|
C76-C78
|
|
XL2000.1.9
|
Clear cell formats
|
2
|
C60-C61
|
|
XL2000.1.10
|
Work with series (AutoFill)
|
1
|
C7, C9, C22, C24
|
|
XL2000.1.11
|
Create hyperlinks
|
3
|
C106-C108
|
|
XL2000.2
|
Working with files
|
|
|
|
XL2000.2.1
|
Use Save
|
1
|
C10, C14
|
|
XL2000.2.2
|
Use Save As (different name, location, format)
|
1,3,4
|
C10, C11, C105, C107, C139-C141
|
|
XL2000.2.3
|
Locate and open an existing workbook
|
1
|
C11
|
|
XL2000.2.4
|
Create a folder
|
3
|
C90-C91
|
|
XL2000.2.5
|
Use templates to create a new workbook
|
4
|
C134-C142
|
|
XL2000.2.6
|
Save a worksheet/workbook as a Web Page
|
3
|
C105-C106, C107
|
|
XL2000.2.7
|
Send a workbook via email
|
3
|
C104-C105
|
|
XL2000.2.8
|
Use the Office Assistant
|
1
|
C44-C46
|
|
XL2000.3
|
Formatting worksheets
|
|
|
|
XL2000.3.1
|
Apply font styles (typeface, size, color and
styles)
|
1
|
C17, C19-C21, C35-C36
|
|
XL2000.3.2
|
Apply number formats (currency, percent, dates,
comma)
|
1
|
C28-C32
|
|
XL2000.3.3
|
Modify size of rows and columns
|
1
|
C21-C27
|
|
XL2000.3.4
|
Modify alignment of cell content
|
1
|
C32
|
|
XL2000.3.5
|
Adjust the decimal place
|
1
|
C28-C31
|
|
XL2000.3.6
|
Use the Format Painter
|
4
|
C128-C129
|
|
XL2000.3.7
|
Apply autoformat
|
1
|
C42-C44
|
|
XL2000.3.8
|
Apply cell borders and shading
|
1
|
C36-C42
|
|
XL2000.3.9
|
Merging cells
|
1
|
C32-C34
|
|
XL2000.3.10
|
Rotate text and change indents
|
1
|
C32-C34
|
|
XL2000.3.11
|
Define, apply, and remove a style
|
4
|
C129-C134
|
|
XL2000.4
|
Page setup and printing
|
|
|
|
XL2000.4.1
|
Preview and print worksheets & workbooks
|
1
|
C11-C12, C17-C20, C116-C118
|
|
XL2000.4.2
|
Use Web Page Preview
|
4
|
C106, C107
|
|
XL2000.4.3
|
Print a selection
|
3
|
C112, C121
|
|
XL2000.4.4
|
Change page orientation and scaling
|
2
|
C62-C65
|
|
XL2000.4.5
|
Set page margins and centering
|
2
|
C66-C67
|
|
XL2000.4.6
|
Insert and remove a page break
|
2
|
C68-C70
|
|
XL2000.4.7
|
Set print, and clear a print area
|
2
|
C73-C74
|
|
XL2000.4.8
|
Set up headers and footers
|
2
|
C65-C66
|
|
XL2000.4.9
|
Set print titles and options (gridlines, print
quality, row & column headings)
|
2
|
C70-C74
|
|
XL2000.5
|
Working with worksheets & workbooks
|
|
|
|
XL2000.5.1
|
Insert and delete rows and columns
|
2
|
C57-C61
|
|
XL2000.5.2
|
Hide and unhide rows and columns
|
2
|
C73-C74
|
|
XL2000.5.3
|
Freeze and unfreeze rows and columns
|
4
|
C119-C122
|
|
XL2000.5.4
|
Change the zoom setting
|
1
|
C18,C 20
|
|
XL2000.5.5
|
Move between worksheets in a workbook
|
4
|
C117-C118
|
|
XL2000.5.6
|
Check spelling
|
2
|
C75-C76
|
|
XL2000.5.7
|
Rename a worksheet
|
4
|
C118-C119
|
|
XL2000.5.8
|
Insert and Delete worksheets
|
4
|
C116-C119
|
|
XL2000.5.9
|
Move and copy worksheets
|
4
|
C118-C119
|
|
XL2000.5.10
|
Link worksheets & consolidate data using
3D References
|
5
|
C178-C181
|
|
XL2000.6
|
Working with formulas & functions
|
|
|
|
XL2000.6.1
|
Enter a range within a formula by dragging
|
5
|
C156-C157, C181
|
|
XL2000.6.2
|
Enter formulas in a cell and using the formula
bar
|
5
|
C152-C153
|
|
XL2000.6.3
|
Revise formulas
|
5
|
C172
|
|
XL2000.6.4
|
Use references (absolute and relative)
|
5
|
C154, C175-C177
|
|
XL2000.6.5
|
Use AutoSum
|
5
|
C152-C153
|
|
XL2000.6.6
|
Use Paste Function to insert a function
|
5
|
C158-C171
|
|
XL2000.6.7
|
Use basic functions (AVERAGE, SUM, COUNT,
MIN, MAX)
|
5
|
C159-C164
|
|
XL2000.6.8
|
Enter functions using the formula palette
|
5
|
C159
|
|
XL2000.6.9
|
Use date functions (NOW and DATE)
|
5
|
C170-C171
|
|
XL2000.6.10
|
Use financial functions (FV and PMT)
|
5
|
C164-C170
|
|
XL2000.6.11
|
Use logical functions (IF)
|
5
|
C171-C173
|
|
XL2000.7
|
Using charts and objects
|
|
|
|
XL2000.7.1
|
Preview and print charts
|
6
|
C199-C200
|
|
XL2000.7.2
|
Use chart wizard to create a chart
|
6
|
C195-C199, C208
|
|
XL2000.7.3
|
Modify charts
|
6
|
C201-C218
|
|
XL2000.7.4
|
Insert, move, and delete an object (picture)
|
7
|
C223-C227, C231-C232
|
|
XL2000.7.5
|
Create and modify lines and objects
|
7
|
C227, C228-C229, C233-C245 (maps)
|
