ecel练习题（Ecel练习题）

excel练习题(Excel练习题)

Excelformsoftwaresimulationquestions

First,themultiple-choicequestion

1.afteryoucreateanewworkbook,thedefaultnameofthefirst

worksheetis:

(A)Excel1(B),Sheetl(C),Bookl(D),table1

Theextensionofthechartfilein2.Excelis:

(A).Xlc(B),.Xis(C),.Xlt(D),.Xla

3.whenanumericstring100081(zipcode)isenteredinacell,

itshouldbeentered:

(A)100081(B),“100081”(0/100081(D),100081'

4.enterinacell:=Average(10,-3),~Pi(),andthevalue

displayedbythatcell:

(A)greaterthanzero(B)lessthanzero(C)equalszero(D)

uncertainty

5.intheAlcell,usingacustomformat[blue]##[red]-##

0;0;ifintheAlinput0,

IsdisplayedinAl:

(A)blue0(B)red0(C)blue0(D)blank

6.intheworksheet,theheaderofthetableiscenteredinthe

table:

(A)entertheheadingofthecellinthemiddleofthetable

widthofthetitleline

(B)enterthetitleofthetableinanycelloftheheadingline,

andthenclickthecentertoolbutton

(C)enterthetitleofthetableinanycelloftheheaderrow,

andthenclickthemergeandcentertoolsbutton

(D)enteratitleinthecellwithinthewidthoftheheader

row,selecttheheaderline,andthenclickonallcellswithin

thewidthofthetable

Mergeandcentertoolsbutton

7.thefollowingcannotbesortedbythedatatable:

(A)clickanycellinthedataarea,andthenclickthe

“ascending"or"descending"buttoninthetoolbar

(B)selectthedataareatosort,andthenclicktheascending

ordescendingbuttoninthetoolbar

(C)selectthedataareatosort,andthenusethesortcommand

ontheeditmenu

(D)selectthedataareatosort,andthenusethesortcommand

onthedatamenu

Thevalueof8.SUM(5,6,7)is:

(A)18(B)210(C)4(D)8

9.whentheB5cellhasaformulaSUM(B2:B4)andcopiesitto

D5,theformulabecomes:

(A)SUM(B2:B4)(B),SUM(B2:D5)(C),5UM(D5:B2)()(D),SUM

(D2:D4)

10.theworksheetnameofthecharttableisspecifiedas:

(A)graph(B),xlc(C),sheet(D),chart

11.whenaworkbookhasageneralworksheetandchartworksheet,

itisdividedintofilestoragewhenitiskept.

(A)1(B)3(C)2(D)4

12.dragwindowandbordercornercanchangethewindow:

(A)color(B),thickness(C),size(D)font

13.whenusingthemousetodraganddropmovingdata,ifthere

iswhethertoreplacethetargetcellcontent”,thepromptbox

appears:

(A)datacannotbemoved(B),thetargetareahasdata(C),the

targetareaisblank(D),anddatamovementcannotbecarried

outwithmousedraganddrop

14.whenanoldworksheetiscoveredwiththenewworksheetfile

name,theoldworksheetfileissavedasabackupfile:

(A).Xlc(B),.Bak(C),.Xia(D),.Xls

15.inthepagesetupdialogbox,thegreaterthenumberofprint

qualityinthepagetab,thegreaterthequalityoftheprint,

thefastertheprintspeed.

(A)low,fast(B),high,fast(C),high,slow(D),lowandslow

16.whenthesystemissorting,suchasincreasingtheorder,

usuallyintheorderoforder.

(A)numericvalues,letters,dates,Chinese(B)letters,values,

dates,andChinese

(C)dates,letters,values,Chinese(D)values,dates,letters,

andChinese

Seventeen

Whenacellinthecontentsofthe"#NAME?",itsaid:

(A)usingthenamethatisnotrecognizedbyExcel(B);thename

intheformulaisproblematic

(C)theinvalidcell(D)referencedintheformulais

meaningless

18.theknownworksheetB3cellandB4cellvaluesare"China”,

“Beijing”,todisplayintheC4cell"ChinaBeijing”,the

correctformulafor:

(A)=B3+B4(B=B3),B4(C)=B3B4(D)=B3;B4

19.whenyouprintaworksheetinExcel,theprintorderinthe

worksheettabinthepagesetupdialogboxhas:

(A)firstrow(B),firstcolumn(C),fromtoptobottom(D),

A,andB

20.inthepagesetupdialogboxpagetabandselect'vertical”

saidfromtheprintline.

(A)left,right(B),upper(lower)(C),right(left),left(D),

andupper

21.whenthestartpagenumberis"automatic“inthe"page"

dialogboxinthepagetab,thestartpagenumberis

(A)no(B)1(C)0(D)isdefinedbyitself

Two.Fillintheblanks

1.MicrosoftExcelisthefilethatcalculatesandstoresdata.

2.beforeyouenteraformula,youmustenterasymbol.

Thecommonlyusedoperatorsin3.Excelaredividedinto,and

three.

4.memoryinputandselectlistonlyappliestodatainput.

5.,the“A1+A4+B4”,withabsoluteaddressas.

6.doubleclickonacelltoworkonthatcell.

7.doubleclickonaworksheetidentifiertomanipulatethe

worksheet.

8.inprintsettings,thegreaterthevalueofDPI,thebetter

theprintquality.

Answer:C,B,C,A,A,D,A,D,C,A,C,B,C,B,C,D,,A,C,

B,D,A

1.Workbook2.,equalsign3.arithmeticoperator,character

connection,relationaloperator4.charactertype

5.$A$1+$A$4+$B$46.,edit7.,rename8.

Excelformsoftwaresimulationtestquestionstwo

First,themultiple-choicequestion

1.enterinthecell,sothatthecellshows0.3.

(A)6/20(B)="6/20"(C),"6/20"(D)=6/20

2.toselecttheregionsAl:C5andD3:E5,the:

(A)presstheleftmousebuttontodragfromAltoC5,andthen

presstheleftmousebuttontodragfromD3toE5

(B)presstheleftmousebuttontodragfromAltoC5,thenhold

downtheCtrlkey,andpresstheleftmousebuttontodragfrom

D3toE5

(C)presstheleftmousebuttontodragfromAltoC5,thenhold

downtheShiftkey,andpresstheleftmousebuttontodragfrom

D3toE5

(D)presstheleftmousebuttontodragfromAltoC5,thenhold

downtheTabkey,andpresstheleftmousebuttontodragfrom

D3toE5

3.inExcel,toselectmultipleadjacentworksheets,youneed

toholddownthekeys.

(A)Ctrl(B),Tab(C),Alt(D),Shift

4.eachworksheethasatmost256columns,byA,B,CAA,

BBThelastoneis..:

(A)XY(B),ZZ(C),YZ(D),IV

5.enter”(123)“inthecell,thenshowthevalueas:

(A)-123(B)123(C),“123〃(D)(123);

6.whenavalueisenteredinacell,itisautomatically

convertedintoamethodrepresentationwhentheinputlength

exceedsthecellwidth.

(A)fourtofivehomes(B)scientific(C)automatictruncation

(D)aboveall

7.whenyouenteranumericstring,youshouldaddasymbolto

thefrontofthenumbertodistinguishitfromthenumeric

value.

(A)〃(B)/(C):(D).

8.,youshouldadddatatothedatainthecellsinother

worksheetsintheworkbook.

(A)...(B),“(C)...(D)&

9.referencesdatafromcellsinotherworkbooks,

Youmustaddasymboltotheworkbookyouwanttoquote.

(A)〃⑻{}(C):(D)[]

10.iftheannotationiscopied,thecopiedcontentwillbethe

originalannotationcontentinthetargetcell.

(A)hide(B),increase(C),replace(D)ispossibleabove

11.calculatethetotalvalueofaproject.IfthecellA8is

theunitprice,andthequantityintheC8isthenumber,the

formulais:

(A)tenA8xC8(B)=A8*C8(C)=A8*C8(D)A8*C8

12.theB2:F2cel1inaworksheetistheresultofanexamination

of5coursesforastudent.Tocalculatetheaveragescore,the

formulashouldbeenteredinthebasecell:

(A)=INT(B2:F2)(B)=ABS(B2:F2)(C)=COUNT(B2:F2)(D)=

AVERAGE(B2:F2)

Two.Fillintheblanks

1.aworkbookcancontainatmostaworksheet.

2.thenameoftheworksheetisdisplayedatthebottomofthe

workbook.

3.therearetwokindsofdatathatcanbeprocessedinExcel97:

and.

4.,therearetwomethodsofdatafiltering.

5.acellisknowntohaveaformatof0andavalueof23.785.

6.acelldatadisplayform#########,themethodsthat

canbeusedforthedatadisplay.

7.theconditionalformattingcommandcansetupatmosta

condition.

8.thereisnoinitialcellvalueandiscalledaconstant.

9.changesthedisplayratioofthesheetonthescreentothe

effectofprinting.

10.changedthezoomratioonthepagetabinthepagesetup

dialogboxtoprinteffects.

11.setandprinttwodirectionsinExcel97.

Answer:D,B,D,D,A,B,D,C,,D,C,B,D

1.255,2.worksheetlabels,3.constants,formula4.,automatic

selection,advancedfilter5.,23.79,6.,adjustcellwidth

7.3,8.equals9.,doesnotaffectthe10.influence,11.

vertical,horizontal

Excelformsoftwaresimulationtestquestionsthree

First,themultiple-choicequestion

1.inthecurrentcellAl,thedata20isdropped.Ifyouwant

toenterdata20inBltoEl,theeasiestwayisto:

(A)selectthecellAl,pressthecopybutton,andthenpaste

fromBltoElonebyone”

(B)inputdatafromBltoElonebyone.20

(C)selectBltoallcellsofEl,andthenonebyone,theinput

data20

(D)selectthecellAl,movethemousetothepaddinghandle,

pressittotheright,untilEl,thenreleasethemouse

2.thedatathatusersenterintoworksheetcellscanbedivided

intotwobroadcategories.

(A)textandannotations(B),numbersandtext(C),Englishand

Chinese(D)text,andgraphics

3.toinsertaworksheetinyourworkbook,thecorrectoperation

is:

(A)clickthe"Edit/insertsheetcommand(B)format,click

onthequotcommand;?

(C)”,clicktheinsertsheetcommand(D)clickonthe'file

/worksheetcommand

4.thefollowingitemisnotanoptionintheExcelmenubar.

(A)property(B)insert(C)file4D)window”

5.wheninputnumbersarecorrectlyidentifiedbythesystem,

alignmentisused.

(A)Center(B)to(C)ontheleft(D)real

6.distinguishcellsfromdifferentworksheets,infrontofthe

address:

(A)increasetheworkbookname(B),increasethenameofthe

cell(C),andincreasetheworksheetname(D)byaddingSheet

7.toselectdatafromarowofcellsinaworksheetis:

(A)pressCtrL+Akey(B)accordingtoCtrlten-(C)lineto

clicktheselectedrowofthe(D)clickz/insert/1inecommand

8.ifyouenter5,10,and15intheAl,A2,andA3cells,then

theresultofSUM(Al:A3)is:

(A)20(B)15(C)5(D)30

9.theabsoluteaddressofthecelladdresswhenitiscopied

toanothercell:

(A)change(B)cannotcopy(C)invariant(D)partialchange

10.intheBlcell,thereisaformulafor:=A$5,aftercopying

ittoDI,theformulabecomes:

(A)=D$5(B)=D$1(C),constant(D)=C$5

11.,whenyouclickanobjectinthechartareaorchart,the

datamenudisappearsintheworkbookwindow,andthemenu

appears.

(A)displayinthechart(B)attribute(C)format(D)

12.whentheworksheetisrenamed,thenameoftheworksheet

cannotcontaincharacters.

(A),(B)*(C)&(@D)

Thevalueof13.INT(12.23)is:

(A)12(B)13(C)12.2(D)1,12.23

Two.Fillintheblanks

Theextensionofthe1.ExcelWorkbookis.

Themaindocumentthat2.MicrosoftExcelusestostoreand

processdatais.

3.clicktherectangularblockoftheworksheet,andyoucan

selecttheentireworksheet.

Thedatainthe4.cellisalignedintheverticaldirection

andinthreeways.

5.pressandholdthekeyswhenyoucopytheworksheetwiththe

mouse.

6.Excel97specifiesthatthenameoftheworksheetmustnot

exceedmorethanonecharacter.

In7.Excel97,thesortcommandcansimultaneouslysortthedata

listatthesametimeinascendingordescendingorderof

fields.

8.theinternaldigitalformatprovidedinExcel97isdeleted

(ableornot).

Answer:

D,B,C,A,B,C,C,D,C,D,,A,B,A

1.,.XLS2.worksheet3.,upperleft,4.up,down,middle

5.,CTRL,6.31,7.3,8.cannot

Excelformsoftwaresimulationtestquestionsfour

First,themultiple-choicequestion

1.copyaworksheetinthesameworkbook.Justselectthe

worksheettabyouwanttocopy,holddownthekey,andthendrag

thesheetlabeltothetargetalongthelabelline

Positioncan.

(A)Ctrl(B),Tab(C),Alt(D),Shift

2.toselectcellsfromdifferentlocationsinthesame

worksheet,press:

(A)Shift(B),Ctrl(C),Alt(D),Tab

3.whenenteringlookupcontentinExcel,whatisthemeaning

ofthewildcard”?〃？:

(A)representsanarbitrarycharacter(B)thatrepresents

multiplearbitrarycharacters(C)indicatingaspecific

character(D)indicatingitself

4.,tomaketheExcelautomaticallycorrecttheoftenlostword,

shouldusefunction.

(A)spellcheck(B),Thesaurus(C),automaticspelling(D),

AutoCorrect

5.append