当前位置:考试网  > 试卷库  > 职业资格  > 其它  > 职称计算机  > Excel 2003  > 使用“定位”选择A1:E1的单元格中为空值的单元格。
试题预览

使用“定位”选择A1:E1的单元格中为空值的单元格。

查看答案
收藏
纠错
正确答案:

点编辑,点定位,出现一个对话框,在引用位置下面输入 “A1:E1”,点定位 条件出现一个对话框,在空值前面点一下,点确定。完成

答案解析:

暂无解析

你可能感兴趣的试题

以当前单元格中数字为起始值,步长为5,终值为25,向下填充等差数列(使用菜单操作)。

某工作表的Al、Bl单元格分别输入了,星期一、星期三,并且已将这两个单元格选定了,现拖动Bl单元格右下角的填充柄向右拖动,请问在Cl、Dl、El单元格显示的数据会是

在当前单元格,设置并输入下面单元格的内容。

工作表中C列已设置成日期型,其格式为YYYY-MM-DD,某人的生日是1965年11月15日,现要将其输入到C5单元格,并且要求显示成1965-ll-15的形式,下列那种输入是错误的

关闭当前的BOOK1工作簿。

热门试题 更多>
试题分类: 基础理论与知识
练习次数:0次
试题分类: 外贸跟单操作实务
练习次数:0次
HowaFrenchmanisrevivingMcDonald’sinEurope A.WhenDenisHennequintookoverastheEuropeanbossofMcDonald’sinJanuary2004,theworld’sbiggestrestaurantchainwasshowingsignsofrecoveryinAmericaandAustralia,butsalesinEuropeweresluggishordeclining.OneexceptionwasFrance,whereMrHennequinhaddoneasterlingjobasheadofthegroup’sFrenchsubsidiarytosellmoreBigMacstohiscompatriots.Histaskwastoreplicatethissuccessinall41oftheEuropeancountrieswhereanti-globalisers’favouriteenemyoperates. B.SofarMrHennequinisdoingwell.LastyearEuropeansalesincreasedby5.8%andthenumberofcustomersby3.4%,thebestannualresultsinnearly15years.Europeaccountedfor36%ofthegroup’sprofitsandfor28%ofitssales.DecemberwasanespeciallygoodmonthascustomerstooktoseasonalmenuofferingsinFranceandBritain,andtoapromotioninGermanybasedonthegameofMonopoly. C.MrHennequin’srecipeforrevivalistobemoreopenabouthiscompany’soperations,tobe“locallyrelevant”,andtoimprovetheexperienceofvisitinghis6,400restaurants.McDonald’sisblamedformakingpeoplefat,exploitingworkers,treatinganimalscruelly,pollutingtheenvironmentandsimplyforbeingAmerican.MrHennequinsayshewantstoengageinadialoguewiththepublictoaddresstheseconcerns. D.Heintroduced“opendoor”visitordaysineachcountrywhichbecamehugelypopular.InPolandalonesome50,000visitorscametoMcDonald’sthroughthevisitors’programmelastyear.TheNutritionInformationInitiative,launchedlastyear,putdetailedlabelsonMcDonald’spackagingwithdataoncalories,protein,fat,carbohydratesandsaltcontent.Thedetailsarealsoprintedontray-liners. E.MrHennequinalsowantspeopletoknowthat“McJobs”,thelow-paidmenialjobsatMcDonald’srestaurants,aremuchbetterthanpeoplethink.Butsomeofhiseffortshavebackfired:lastyearhesparkedacontroversywiththeintroductionofa“McPassport”thatallowsMcDonald’semployeestoworkanywhereintheEuropeanUnion.PoliticiansaccusedthefirmofaploytomakecheaplabourfromeasternEuropemoreeasilyavailabletoMcDonald’smanagersacrossthecontinent. F.Tostayintouchwithlocalneedsandpreferences,McDonald’semployslocalbossesasmuchaspossible.ARussianisrunningMcDonald’sinRussia,thoughaSerbisinchargeofGermany.Thegroupbuysmainlyfromlocalsuppliers.Four-fifthsofitssuppliesinFrancecomefromlocalfarmers,forexample.(SomeoftheFrenchfarmerswhocampaignedagainstthecompanyinthelate1990ssubsequentlydiscoveredthatitwas,infact,buyingtheirproduce.)AndithirescelebritiessuchasHeidiKlum,aGermanmodel,aslocalbrandambassadors. G.InhispreviousjobMrHennequinestablisheda“designstudio”inFrancetospruceuphiscompany’sdrabrestaurantsandadapttheinteriortolocaltastes.ThestudioisnowmastermindingimprovementseverywhereinEurope.Healsosetupa“foodstudio”,wherecooksdevisenewrecipesinresponsetolocaltrends. H.GivenFrance’sreputationasthemostanti-AmericancountryinEurope,itseemsoddthatMcDonald’srevivalinEuropeisbeingledbyaFrenchman,usingideascookedupintheFrenchmarket.ButFranceisinfactthecompany’smostprofitablemarketafterAmerica.ThemarketwhereMcDonald’sisweakestinEuropeisnotFrance,butBritain. I.“FixingBritainshouldbehispriority,”saysDavidPalmer,arestaurantanalystatUBS.Almosttwo-thirdsofthe1,214McDonald’srestaurantsinBritainarecompany-owned,comparedwith40%inEuropeand15%inAmerica.Thecompanysuffersfromthevolatilityofsalesatitsownrestaurants,butcanrelyonsteadyincomefromfranchisees.Soitshouldsellasmanyunderperformingoutletsaspossible,saysMrPalmer. J.M.MarkWiltamuth,ananalystatMorganStanley,estimatesthatEuropeancompany-ownedrestaurants’marginswillincreaseslightlyto16.4%in2007.Thisisstilllessthaninthelate1990sandbelowAmerica’s18-19%today.ButitismuchbetterthanbeforeMrHennequin’sreign.HeisalreadybeingtippedasthefirstEuropeancandidateforthegroup’stopjobinIllinois.NobodywouldcallthataMcJob. NotestoReadingPassage1 1.sterling高质量的 e.g.Hehasmanysterlingqualities.他身上有许多优秀的品质。 2.menial不体面的,乏味的(工作、职业) 3.spruceup打扮整齐、漂亮、装饰 4.mastermind指挥、谋划(一个计划或活动) e.g.Thepoliceknowwhomastermindedtherobbery.警察知道是谁策划了那次抢劫。 5.underperform表现不佳表现出低于标准的工作水平、企业出现亏本 Questions1-6 DothefollowingstatementsreflecttheclaimsofthewriterinReadingPassage1? WriteyouranswerinBoxes1-6onyouranswersheet. TRUEifthestatementreflectstheclaimsofthewriter FALSEifthestatementcontradictstheclaimsofthewriter NOTGIVENifitisimpossibletosaywhatthewriterthinksaboutthis 1.McDonaldwasshowingthesignofrecoveryinallEuropeancountriesexceptFranceafterDenisHennequintookofficeasthebossofEuro-markets. 2.Startingfromlastyear,detailedlabelsareputonMcDonald’spackaginganddetailedinformationisalsoprintedontray-liners. 3.Franceissaidtobethemostanti-AmericancountryinEurope,buttheideasofthe“opendoor”visitingdaysand“McPassport”areinventedintheFrenchmarket. 4.BritainpossessestheweakestMcDonaldmarketamongEuropeancountriesandapproximately1214McDonald’srestaurantsarecompany-owned. 5.AccordingtoDavidPalmer,arestaurantanalystatUBS,DavidHennequinshouldtreattheproblemaboutMcDonaldinBritainasthemostimportantthing. 6.DavidPalmersuggestedthatthemanagementofMcDonalodinItalyshouldsellasmanyitsoutletswhichlosemoneyinbusinessaspossibleforrevival. Questions7-10 ChoosetheappropriatelettersA-Dandwritetheminboxes7-10onyouranswesheet. 7.Theword“sterling”inline3ofParagraphAmeans__________. A.difficult B.menial C.terrible D.excellent 8.WhichofthefollowingstatementsontheaccusationofMacDonaldisNOTTRUE? A.Ittendstomakepeoplefat. B.Itsoperationsareveryvague. C.Ittendstoexploitworkers. D.Ittendstotreatanimalscruelly. 9.WhichofthefollowingmeasurestakenbyDenisHennequinproducedundesiredresult? A.“FoodStudio”scheme. B.“OpenDoor”visitordays. C.The“McPassport”scheme. D.TheNutritionInformationInitiative. 10.WhatdidDenisHennequindosoastorespondtolocaltrends? A.setupa“FoodStudio”. B.establisheda“DesignStudio”. C.hiredcelebritiesaslocalbrandambassadors. D.employedlocalbossesasmuchaspossible. Questions11-14 Completeeachofthefollowingstatements(Questions11-14)withwordsornumbertakenfromReadingPassage1. WriteNOMORETHANTHREEWORDSforeachanswer. Writeyouranswersinboxes11-14onyouranswersheet. 11.AfterJanuary2004,McDonaldwasmakingimprovementfollowingaperiodofslumpinAmericaandAustralia,butsalesinEuropewere…………………………. 12.BusinessofMcDonaldinFranceandBritainwasparticularlygoodinDecembersincecustomerstookto…………………………….. 13.Comparedwithothercountries,FranceisMcDonald’s……………………….nexttoAmerica. 14.…………………….ofMcDonald’srestaurantsinAmericaarecompanied–ownedandthefigureismuchlowerthanthatinBritain.
试题分类: 阅读
练习次数:0次
试题分类: 初级(口语)
练习次数:0次
试题分类: 初级(口语)
练习次数:1次
试题分类: 写作
练习次数:0次
扫一扫,手机做题