| |
main
home page / cover
page / Microsoft Office Specialist certification main page
Exam Title: Microsoft Excel 2000: Core Level Microsoft Office Specialist Skills
|
Coding No.
|
Objective/Sub-Objective
Topic
|
Content Page(s)
|
Exercise Page(s)
|
Chapter(s)
|
|
XL2000.1
|
Working with cells
|
|
|
|
|
XL2000.1.1
|
Use Undo and Redo
|
401-402
|
|
9
|
|
XL2000.1.2
|
Clear cell content
|
386-387
|
387
|
9
|
|
XL2000.1.3
|
Enter text, dates, and numbers
|
338-341, 344-345
|
344-345
|
8
|
|
XL2000.1.4
|
Edit cell content
|
342, 349, 351
|
349-350
|
8
|
|
XL2000.1.5
|
Go to a specific cell
|
338-339
|
344-345
|
8
|
|
XL2000.1.6
|
Insert and delete selected cells
|
345-347, 384-387
|
384, 385-386, 387
|
8, 9
|
|
XL2000.1.7
|
Cut, copy, paste, paste special and move selected
cells, use the Office Clipboard
|
416-418, 488-490
|
416-418
|
10
|
|
XL2000.1.8
|
Use Find and Replace
|
402-404
|
|
9
|
|
XL2000.1.9
|
Clear cell formats
|
386-387
|
387
|
9
|
|
XL2000.1.10
|
Work with series (AutoFill)
|
339, 341, 352, 354
|
352-353, 354-353
|
8
|
|
XL2000.1.11
|
Create Hyperlinks
|
439-441
|
|
10
|
|
XL2000.2
|
Working with files
|
|
|
|
|
XL2000.2.1
|
Use Save
|
342, 345
|
344-345
|
8
|
|
XL2000.2.2
|
Use Save As (different name, location, format)
|
342, 343, 438, 440, 448-450
|
440, 448-450
|
8, 10
|
|
XL2000.2.3
|
Locate and open an existing workbook
|
343
|
349
|
8
|
|
XL2000.2.4
|
Create a folder
|
439-440
|
|
10
|
|
XL2000.2.5
|
Use templates to create a new workbook
|
442-451
|
|
10
|
|
XL2000.2.6
|
Save a worksheet/workbook as a Web Page
|
343, 438, 440
|
440-441
|
8, 10
|
|
XL2000.2.7
|
Send a workbook via email
|
442-442
|
|
10
|
|
XL2000.2.8
|
Use the Office Assistant
|
374-375
|
375
|
8
|
|
XL2000.3
|
Formatting worksheets
|
|
|
|
|
XL2000.3.1
|
Apply font styles (typeface, size, color and
styles)
|
365-366
|
365-366
|
8
|
|
XL2000.3.2
|
Apply number formats (currency, percent, dates,
comma)
|
357-362
|
358-359, 361-362
|
8
|
|
XL2000.3.3
|
Modify size of rows and columns
|
351-357
|
352-353, 354-356, 357
|
8
|
|
XL2000.3.4
|
Modify alignment of cell content
|
362-364
|
364
|
8
|
|
XL2000.3.5
|
Adjust the decimal place
|
358-362
|
358-359, 361-362
|
8
|
|
XL2000.3.6
|
Use the Format Painter
|
431-432
|
432
|
10
|
|
XL2000.3.7
|
Apply autoformat
|
372-374
|
|
8
|
|
XL2000.3.8
|
Apply cell borders and shading
|
366-372
|
367, 368-369, 370, 371-372
|
8
|
|
XL2000.3.9
|
Merging cells
|
362-364
|
364
|
8
|
|
XL2000.3.10
|
Rotate text and change indents
|
362-364
|
|
8
|
|
XL2000.3.11
|
Define, apply, and remove a style
|
432-438
|
|
10
|
|
XL2000.4
|
Page setup and printing
|
|
|
|
|
XL2000.4.1
|
Preview and print worksheet and workbooks
|
343-344, 347-350, 418-420
|
344-345, 349-351, 419-420
|
8, 10
|
|
XL2000.4.2
|
Use Web Page Preview
|
438, 440
|
|
10
|
|
XL2000.4.3
|
Print a selection
|
344, 351
|
|
8
|
|
XL2000.4.4
|
Change page orientation and scaling
|
388-391
|
390-391
|
9
|
|
XL2000.4.5
|
Set page margins and centering
|
392-394
|
393-394
|
9
|
|
XL2000.4.6
|
Insert and remove a page break
|
394-396
|
|
9
|
|
XL2000.4.7
|
Set print, and clear a print area
|
399-400
|
400
|
9
|
|
XL2000.4.8
|
Set up headers and footers
|
389-392
|
390-392
|
9
|
|
XL2000.4.9
|
Set print titles and options (gridlines, print
quality, row & column headings)
|
396-400
|
|
9
|
|
XL2000.5
|
Working with worksheets and workbooks
|
|
|
|
|
XL2000.5.1
|
Insert and delete rows and columns
|
383-387
|
384-386, 387
|
9
|
|
XL2000.5.2
|
Hide and unhide rows and columns
|
399-400
|
|
9
|
|
XL2000.5.3
|
Freeze and unfreeze rows and columns
|
421-424
|
423-424
|
10
|
|
XL2000.5.4
|
Change the zoom setting
|
348, 350
|
349-350
|
8
|
|
XL2000.5.5
|
Move between worksheets in a workbook
|
419-420
|
419-420
|
10
|
|
XL2000.5.6
|
Check spelling
|
401-402
|
|
9
|
|
XL2000.5.7
|
Rename a worksheet
|
420-421
|
420-421
|
10
|
|
XL2000.5.8
|
Insert and Delete worksheets
|
418-421
|
419-421
|
10
|
|
XL2000.5.9
|
Move and copy worksheets
|
420-421
|
|
10
|
|
XL2000.5.10
|
Link worksheets & consolidate data using
3D references
|
488-491
|
489-490, 491
|
11
|
|
XL2000.6
|
Working with formulas & functions
|
|
|
|
|
XL2000.6.1
|
Enter a range within a formula by dragging
|
466-467, 491
|
|
11
|
|
XL2000.6.2
|
Enter formulas in a cell and using the formula
bar
|
462-463
|
462-463
|
11
|
|
XL2000.6.3
|
Revise formulas
|
482
|
482
|
11
|
|
XL2000.6.4
|
Use references (absolute and relative)
|
464, 485-487
|
464-465, 486-487
|
11
|
|
XL2000.6.5
|
Use AutoSum
|
462-463
|
462-463
|
11
|
|
XL2000.6.6
|
Use Paste Function to insert a function
|
468-481
|
|
11
|
|
XL2000.6.7
|
Use basic functions (AVERAGE, SUM, COUNT,
MIN, MAX)
|
469-474
|
470-471, 472-474
|
11
|
|
XL2000.6.8
|
Enter functions using the formula palette
|
469
|
470-471
|
11
|
|
XL2000.6.9
|
Use date functions (NOW and DATE)
|
480-481
|
480-481
|
11
|
|
XL2000.6.10
|
Use financial functions (FV and PMT)
|
474-480
|
475-480
|
11
|
|
XL2000.6.11
|
Use logical functions (IF)
|
481-483
|
482, 483
|
11
|
|
XL2000.7
|
Using charts and objects
|
|
|
|
|
XL2000.7.1
|
Preview and print charts
|
509-510
|
510
|
12
|
|
XL2000.7.2
|
Use chart wizard to create a chart
|
505-509, 518
|
509, 518
|
12
|
|
XL2000.7.3
|
Modify charts
|
511-528
|
511-512, 514-515, 516-517, 518, 520, 521-522,
523, 525-526, 527-528
|
12
|
|
XL2000.7.4
|
Insert, move, and delete an object (picture)
|
533-538, 546-547
|
536-538, 546-547
|
13
|
|
XL2000.7.5
|
Create and modify lines and objects
|
547-460 (maps)
|
|
13
|
|
