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
 
Michelle
 
 

Braindumps of excel2kexpert
Excel 2000 Expert


Exam Questions, Answers, Braindumps (excel2kexpert)

Submitting braindumps with some changes. The original is also available in www.braindumps.org.

QUESTION 1
Use the Subtotal form to add each change in the Selling Price and Cost columns grouped by Manufacturer. Replace the current groups and add a summary below the data.
Answer:
Step 1: Click Data>Subtotal.
Step 2: In the At each change in box, select Manufacturer.
Step 3: In the Add subtotal to list, check the Selling Price and Cost check boxes.
Step 4: Leave Replace current subtotals and Summary below data checked. Click OK.


QUESTION 2
Create a new database query that will import the "Prices by Manufacturer" query from the "Car tracker" database in the C:\TestKing\MyDocuments folder. Return the data to the current worksheet.
Answer:
Step 1: Choose Data->Get External Data->New Database Query.
Step 2: On the Datbases tab, select MS Access Database. Click OK.
Step 3: Select the CarTracker.mdb database. Click OK.
Step 4: In the Available tables and column list, select Prices by Manufacturer. Click the > button.
Step 5:.Click Next three times.
Step 6: Select Return Data to Microsoft Excel. Click Finish. Select Existing worksheet and click OK.


QUESTION 3
Create a new workbook based on the Books template
Answer:
Step 1: Click File>New.
Step 2: Click the General tab. Select Books.xlt.
Step 3: Click OK.


QUESTION 4
Save the current workbook as a template in your Templates folder.
Answer:
Step 1: Click File>Save As.
Step 2: In the Save as type box, select Template.
Step 3: Click Save.


QUESTION 5
Apply the Accounting format with two decimal places to G6:L20.
Answer:
Step 1: Select cells G6:L20.
Step 2: Click Format>Cells. Click the Number tab.
Step 3: Select Accounting in the Category list.
Step 4: If necessary, type 2 in the Decimal places box.
Step 5: Click OK.


QUESTION 6
In cell B20, enter a VLOOKUP function that will reference the loan amount and interest rate in range
A3:J12.
Answer:
Step 1: Select cell B20. Click Insert>Function.
Step 2: Select Lookup & Reference in the Function category list.
Step 3: Scroll down to select VLOOKUP in the Function name list. Click OK.
Step 4: In the Lookup_value box, type A4.
Step 5: In the Table_array box, type A3.J12.
Step 6: In the Cool index num box, type 3 and click OK.


QUESTION 7
Hide the Formatting toolbar. Display the Forms toolbar.
Answer:
Step 1: Click Views>Toolbars.
Step 2: Select Formatting.
Step 3: Click View>Toolbars.
Step 4: Select Forms.


QUESTION 8
Record a clear in the current workbook named NoFormat that will clear the formats of the selected text. Use an already blank cell to record the clear.
Answer:
Step 1: Click Tools>Clear>Record New Clear.
Step 2: In the Clear name box, type NoFormat.
Step 3: In the Store clear in box, select This Woorkbook. Click OK.
Step 4: Click Edit>Clear>Formats.
Step 5: Click the Stop Recording button on the Clear toolbar.


QUESTION 9
Select cells B10:E10 and run the Reformat sales.
Answer:
Step 1: Select cells B10:E10.
Step 2: Click Tool>Sales>Macros.
Step 3: Select Reformat in the Sales name list and click Run.


QUESTION 10
Use the Trace Precedents button on the Auditing toolbar to find the cells that contribute to the formula in cell C7 on the Qualification worksheet.
Answer:
Step 1: Click the Qualification worksheet tab.
Step 2: Select cell C7. Click Tools>Auditing>Show Auditing Toolbar.
Step 3: Click the Trace Precedents button on the Auditing toolbar.


QUESTION 11
Use the Trace Dependents button on the Auditing toolbar to find the cells that depend on the value in cell
A12.
Answer:
Step 1: Select cell A12.
Step 2: Click Tools>Auditing>Show Auditing Toolbar.
Step 3: Click the Trace Dependents button on the Auditing toolbar.


QUESTION 12
Use Auto Outline to automatically outline the worksheet.
Answer:
Step 1: Click Data>Group and Outline>Auto Outline.

excel2kexpert


 

 

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