Microsoft Excel 2000 core

Microsoft Excel 2000 Core

MOUS

Version 2.0

MOUS Excel 2000 Core

Leading the way in IT testing and certification tools, www.testking.com

- 2 -

Important Note

Please Read Carefully

Study Tips

This product will provide you questions and answers along with detailed explanations carefully compiled and

written by our experts. Try to understand the concepts behind the questions instead of cramming the questions.

Go through the entire document at least twice so that you make sure that you are not missing anything.

Latest Version

We are constantly reviewing our products. New material is added and old material is revised. Free updates are

available for 90 days after the purchase. You should check your member zone at TestKing an update 3-4 days

before the scheduled exam date.

Here is the procedure to get the latest version:

1. Go to www.testking.com

2. Click on Member zone/Log in

3. The latest versions of all purchased products are downloadable from here. Just click the links.

For most updates, it is enough just to print the new questions at the end of the new version, not the whole

document.

Feedback

Feedback on specific questions should be send to [email protected]. You should state: Exam number and

version, question number, and login ID.

Our experts will answer your mail promptly.

Copyright

Each pdf file contains a unique serial number associated with your particular name and contact information for

security purposes. So if we find out that a particular pdf file is being distributed by you, TestKing reserves the

right to take legal action against you according to the International Copyright Laws.

MOUS Excel 2000 Core

Leading the way in IT testing and certification tools, www.testking.com

- 3 -

QUESTION NO: 1

Change the chart to a simple two-dimensional pie chart.

MOUS Excel 2000 Core

Leading the way in IT testing and certification tools, www.testking.com

- 4 -

Answer:

Step 1: Select the Chart Type button

Step 2: Select Pie chart.

MOUS Excel 2000 Core

Leading the way in IT testing and certification tools, www.testking.com

- 5 -

QUESTION NO: 2

Add a header to the worksheet with Investment Analysis appearing at the left of the header, and the page

number appearing at the right. In the footer, include the current data in the center.

MOUS Excel 2000 Core

Leading the way in IT testing and certification tools, www.testking.com

- 6 -

Answer:

Step 1: Select the View menu.

Step 2: Select the Header and Footer command.

Step 3: Click the Custom Header button.

Step 4: Click in the Left section text box.

Step 5: Write: Investment Analysis

Step 6: Click in Center section text box.

Step 7: Click the Page number button.

Step 8: Click OK.

MOUS Excel 2000 Core

Leading the way in IT testing and certification tools, www.testking.com

- 7 -

Step 9: Click the Custom Footer button.

Step 10: Click in the Center section text box.

Step 11: Click OK.

Step 12: Click OK.

MOUS Excel 2000 Core

Leading the way in IT testing and certification tools, www.testking.com

- 8 -

QUESTION NO: 3

Clear the contents of the quarterly values for France in the range B9:E9.