REAL QUESTIONS SUBMIT MATERIAL ADVERTISE
Braindumps

Microsoft

Cisco

Citrix

CIW

CompTia

CWNA

Apple

Adobe

HP

Legato

Exin

Filemaker

Brocade

Ericsson

TIA

Veritas

ISEB

SCP

IISFA

ISM

OMG

Apc

Mile2

Foundry

Huawei

McData

Symantec

TeraData

RedHat

Solar Winds

Blue Coat

Riverbed

 

 
 
Click on name of dumper to view the dump
 
Kristi Smith
 
 

 

Braindumps of MOS-E2K
Microsoft Excel 2000 Core

Exam Questions, Answers, Braindumps (MOS-E2K)

Hi to all, My thanks to this site….it helped me a lot in my previous exams. Here is my contribution.

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

Answer:
Step 1: Select the Chart Type button

Step 2: Select Pie chart.


QUESTION 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.

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.
Step 9: Click the Custom Footer button.
Step 10: Click in the Center section text box.

Step 11: Click OK.

Step 12: Click OK.


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

Answer:
Step 1: Click cell B9.
Step 2: Press the Shift key and click cell E9.
Step 3: Press the Delete key.


QUESTION 4
Delete the content in the cell range A9:F9. Then, add 1 row before Europe. Add England and Ireland in cells A9 and A10. Finally, copy the formula in cell F8 to cells F9 and F10.

Answer:
Step 1: Click cell A9.
Step 2: Press the Shift key and click cell F9.
Step 3: Press the Delete key.
Step 4: Click cell A10.
Step 5: Select the Insert menu.
Step 6: Select the Rows command.
Step 7: Click cell A9.
Step 8: Type England and hit the Enter key.
Step 9: Type Ireland and hit the Enter key.
Step 10: Click the cell F8.
Step 11: Use autofill to copy the cell to F9 and F10 (see below).

QUESTION 5
In cell A3, type Date: and enter 01/07/99 in cell F3 as a date. When you are finished, enter the following revenue projections in cells D6 through E6 respectively.
D6: 278927
E6: 344981

Answer:
Step 1: Click cell A3.
Step 2: Type Date: and press enter.
Step 3: Click cell F3.
Step 4: Type 01/07/99 and press enter.
Step 5: Click cell D6.
Step 6: Type 278927 and press the Tab key.
Step 7: Type 344981 and press Enter.


QUESTION 6
Set a print area to display the investment information for years 2 through 10, including initial investment amount and the label in Cell A1.

Answer:
Step 1: Click cell C7.
Step 2: Press the Shift key and click cell G1.
We select the investment information for years 2 through 10
Step 3: Press the Ctrl key, click cell B3, and click cell A1.
We include the initial investment amount and the label in cell A1.
Step 4: Select the File menu.
Step 5: Select the Print Area command.
Step 6: Select the Set print area subcommand.

MOS-E2K


 

 

Braindumps Real exam questions and verified answers - 100% passing guarantee - cheap prices.

 

Free brain dumps Braindumps, notes, books for free

 

Braindumps and Exams - Instant download real exam questions - Passing guarantee.

Follow us on FaceBook
Braindumps on Facebook
 
 
 
 
 

CheckPoint

Linux

Novell

DB/2

Network Appliance

EC-Council

Nortel

McAfee

Juniper

ISACA

PMI

Sybase

EMC

HDI

SNIA

ISC

Sair

IBM

Lotus

Exam Express

3COM

BICSI

DeLL

Enterasys

Extreme Networks

Guidance Software

Computer Associates

Network General

SAS Institute

Alcatel Lucent

SeeBeyond

TruSecure

Polycom

Hyperion

Hitachi

Nokia

Fortinet

Vmware

Fujitsu

Tibco

Intel

PostgreSQLCE

BusinessObjects

RESSoftware

BlackBerry

AccessData

ICDL

Isilon

SAP

The Open Group

ACSM

Altiris

Avaya

Cognos

F5

Genesys

SDI

ACI

ASQ

Google

H3C

HIPAA

HRCI

SOA

IIBA

Zend