当前位置:考试网  > 试卷库  > 计算机类  > 软考  > 初级软考  > 信息处理技术员  > 在Excel中,若要计算出B3:E6区域内的数据的最小值并保存在B7单元格中,应在B7单元格输入()。
试题预览

在Excel中,若要计算出B3:E6区域内的数据的最小值并保存在B7单元格中,应在B7单元格输入()。

A、=MIN(B3:E6)
B、=MAX(B3:E6)
C、=COUNT(B3:E6)
D、=SUM(B3:E6)
查看答案
收藏
纠错
正确答案:

A

答案解析:

暂无解析

你可能感兴趣的试题

TheImportanceofGoodCommunications

Effectivecommunicationisessentialforallorganizations.Itlinkstheactivitiesofthevariouspartsoftheorganizationandensuresthateveryoneisworkingtowardsacommongoal.Itisalsoextremelyimportantformotivatingemployees.Staffneedtoknowhowtheyaregettingon,whattheyaredoingrightandinwhichareastheycouldimprove.Workingalonecanbeextremelydifficultanditismucheasierifsomeonetakesaninterestandprovidessupport.Employeesneedtounderstandwhytheirjobisimportantandhowitcontributestotheoverallsuccessofthefirm.Personalcommunicationshouldalsoincludetargetsetting.Peopleusuallyrespondwelltogoals,providedtheseareagreedbetweenthemanagerandsubordinateandnotimposed.

However,firmsoftenhavecommunicationproblemsthatcanunderminetheirperformance.Inmanycases,theseproblemsoccurbecausemessagesarepassedoninaninappropriateway.Thereare,ofcourse,severalwaysofconveyinginformationtoothersintheorganizationwhichincludespeakingtothemdirectly,e-mailing,telephoningorsendingamemo.Themostappropriatemethoddependsonwhatexactlyitisyouarecommunicating.Forexample,anythingthatisparticularlysensitiveorconfidential,suchasanemployee'sappraisal,shouldbedoneface-to-face.

Oneofthemainproblemsforseniorexecutivesisthattheydonothavethetimeorresourcesneededtocommunicateeffectively.Inlargecompanies,forexample,itisimpossibleforseniormanagerstomeetanddiscussprogresswitheachemployeeindividually.Obviouslythistaskcanbedelegatedbutatthecostofcreatingagapbetweenseniormanagementandstaff.Asaresult,managersareoftenforcedtouseothermethodsofcommunication,likememosornotes,eveniftheyknowthesearenotnecessarilythemostsuitablemeansofpassingonmessages.

Theuseoftechnology,suchase-mail,mobilephonesandnetworksystems,isspeedingupcommunicationimmensely.However,thisdoesnotmeanthatmoreinvestmentintechnologyautomaticallyprovesbeneficial:systemscanbecomeoutdatedoremployeesmaylackappropriatetraining.Therearemanycommunicationstoolsnowavailablebutafirmcannotaffordallofthem.Evenifitcould,itdoesnotactuallyneedthemall.Thepotentialgainsmustbeweighedupagainstthecosts,andfirmsshouldrealizethatmorecommunicationdoesnotnecessarilymeanbettercommunication."

Asthenumberofpeopleinvolvedinanorganizationincrease,theuseofwrittencommunicationrisesevenfaster.Insteadofaquickconversationtosortsomethingoutnumerousmessagescanbepassedbackwardsandforwards.Thiscanleadtoatremendousamountofpaperworkandisoftenlesseffectivethanface-to-facecommunication.Whenyouareactuallytalkingtosomeoneyoucandiscussthingsuntilyouarehappythattheyhaveunderstoodandfeedbackisimmediate.Withwrittenmessages,however,youareneverquitesurehowitwillbereceivedwhatyouthinkyouhavesaidandwhattheotherpersonthinksyouhavesaidcanbeverydifferent.

Theamountofwritteninformationgeneratedinlargeorganizationstodaycanleadtocommunicationoverload.Somuchinformationisgatheredthatitgetsinthewayofmakingdecisions.Takealookattheaveragemanager'sdeskandyouwillseetheproblem--itisoftencoveredwithletters,reportsandmemos.Thisoverloadcanleadtoinefficiencies.Forexample,managersmaynotbeabletofindtheinformationtheywantwhentheyneedit.Communicationisalsobecomingmoredifficultwiththechangesoccurringinemploymentpatterns.Withmorepeopleworkingpart-timeandworkingathome,managingcommunicationisbecomingincreasinglycomplex.

1.InthefirstparagraphthewriterrecommendsthatcommunicationwithstaffshouldincludeA.somefeedbackontheirjobperformance.

B.anexplanationofhowcompanytargetshavebeenset.

C.informationonpromotionprospectswithinthecompany.

D.anindicationofwhichdutiestheycanexpectassistancewith.areastheycouldimprove

2.Accordingtothewriter,thebestwayofachievingeffectivecommunicationistoA.adaptthemessagetosuitaparticularaudience.

B.makethecontentofmessagesbriefanddirect.

C.selectthemostsuitablemeansofconveyingaparticularmessage.

D.ensurethatinformationistargetedattheappropriategroupofpeople.

3.Whatdoesthewritersayaboutthecommunicationoptionsavailabletoseniormanagers?A.Sendingmemostostaffisoneofthemostefficientmethods.

B.Itisimportanttofindthetimetodiscusscertainmatterswithstaff.

C.Theyshouldincreasetherangeofoptionsthattheyuse.

D.Gettingjuniormanagerstotalktostaffcancreatedifferentproblems.

4.Whatadviceisgivenaboutthecommunicationtoolsmadeavailablebytechnology?A.Aimtolimitstaffuseofcertaincommunicationtools.

B.Evaluatethemintermsoftheexpenditureinvolved.

C.Selectthemonthebasisofthefacilitiestheyoffer.

D.Encouragemorestafftoattendtrainingcoursesintheiruse.

5.Accordingtothewriter,aproblemwithwrittencommunicationisthatA.themessagecanbeinterpreteddifferentlytowhatwasintended.

B.itcanbeeasyforpeopletoignorethecontentsofawrittenmessage.

C.mostpeoplearemorecomfortablewithface-to-facecommunication.

D.itispossibleforcorrespondencetogetlostwithinalargeorganization.

6.Accordingtothearticle,whatistheeffectofreceivinglargeamountsofwritteninformation?A.Itiscounter-productive."

B.Itcausesconflictinacompany.

C.Itleadstochangesinworkpatterns.

D.Itmakesthemainpointsmoredifficulttoidentify.

Itisonlyinviewofourlongfriendlybusinessrelationsthatwe____youthisaccommodation.

Thereis______littleinformationabouthimthatwehave______muchdifficultyfindinghim.

Passage3

Questions11to15arebasedonthefollowingpassage:

“...WearenotabouttoentertheInformationAgebutinsteadareratherwellintoit.”Presentpredictionsarethatby1990,aboutthirtymillionjobsintheUnitedStates,oraboutthirtypercentofthejobmarket,willbecomputer-related.In1980,onlytwenty-onepercentofallUnitedStateshighschoolsownedoneormorecomputersforstudentuse.(79)Inthefallof1985,anewsurveyrevealedthathalfofUnitedStatessecondaryschoolshavefifteenormorecomputersforstudentuse.Andnoweducationalexperts,administrators,andeventhegeneralpublicaredemandingthatallstudentsbecome“computerliterate(慢点…的).”“Bytheyear2000knowledgeofcomputerswillbenecessaryinovereightypercentofalloccupations.Soonthosepeoplenoteducatedincomputerusewillbecomparedtothosewhoareprintilliteratetoday.”

Whatis“computerliteracy”?Thetermitselfseemstoimplysoonextentof“knowing”aboutcomputers,butknowingwhat.Thecurrentopinionseemstobethatthisshouldincludeageneralknowledgeofwhatcomputersare,plusalittleoftheirhistoryandsomethingofhowtheyoperate.

Therefore,itisvitalthateducatorseverywheretakeacarefullooknotonlyatwhatisbeingdone,butalsoatwhatshouldbedoneinthefieldofcomputereducation.Todaymostadultsarecapableofutilisingamotorvehiclewithouttheslightestknowledgeofhowtheinternal-combustionengineworks.Weeffectivelyusealltypesofelectricalequipmentwithoutbeingabletotelltheirhistoriesortoexplainhowtheywork.(80)Businesspeopleforyearshavemadegooduseoftypewritersandaddingmachines,yetfewhaveeverknownhowtorepairthem.Why,then,attempttoteachcomputersbyteachinghoworwhytheywork?

Rather,wefirstmustconcentrateonteachingtheeffectiveuseofthecomputerasthetoolis.

“Knowinghowtouseacomputeriswhat’sgoingtobeimportant,wedon’ttalkabout‘automobileliteracy.‘Wejustgetinourcarsanddrivethem.”

11.In1990,thenumberofjobshavingnothingtodowithcomputersintheUnitedStateswillbereducedto________.

A)79millionB)30millionC)70millionD)100million(C)

12.Theexpression“Printilliterate”(Para.1,Line16)refersto________.

A)onewhohasneverlearntprintingB)onewhoisnotcomputerliterate

C)onewhohasneverlearnttoreadD)onewhoisnotabletouseatypewriter(C)

13.Thefirstparagraphismainlyabout________.

A)recentpredictionsofcomputer-relatedjobsB)thewideuseofcomputersinschools

C)theurgencyofcomputereducationD)publicinterestincomputers(C)

14.Accordingtotheauthor,theeffectivewaytospreadtheuseofcomputersistoteach____.

A)whatcomputersareB)howtousecomputers

C)wherecomputerscanbeusedD)howcomputerswork(B)

15.WhichofthefollowingstatementsisFALSE?

A)Whattoteachaboutcomputersshouldbereconsidered.

B)Thosewhoarenoteducatedincomputerusewillfinditdifficulttogetajob.

C)HumansocietyhasalreadyenteredtheInformationAge.

D)Thosewhowanttousecomputersshouldknowhowcomputersoperate.

Thetimehascome_____wemakeextensiveuseofnuclearenergy.

热门试题 更多>
试题分类: 其他工学类
练习次数:0次
试题分类: 其他工学类
练习次数:0次
试题分类: 法律常识
练习次数:0次
试题分类: 法律常识
练习次数:1次
试题分类: 法律常识
练习次数:0次
试题分类: 法学类
练习次数:0次
扫一扫,手机做题