Benchmark Series Office 2000

Instructor Resources
Student Resources
Microsoft Office Specialist Certification
Product Information
contact Us
Home
 

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

 

Click here to see a text-only printable version of this page.

top button next page button home page button


© by Paradigm Publishing Inc.