首页
试卷库
试题库
当前位置：
X题卡
>
所有题目
>
题目详情
在Excel中，函数AVERAGE(A1，A7)的功能是______。
查看本题答案
包含此试题的试卷
中小学校长招聘考试《单项选择》真题及答案
点击查看
你可能感兴趣的试题
在Excel2010公式功能区的子功能区中提供了数 学财务工程等专用函数
函数计算
函数集
函数库
函数表
Exce1中AVERAGEA是
求和函数
条件函数
平均值函数
计算函数
在Excel中若Sheet1工作表的A1单元格需计算Sheet2工作表中A2到A7单元格的和则应在
=SUM(Sheet2! A2:A7)
=SUM(Sheet2! A2:Sheet2! A7)
=SUM((Sheet2)A2:A7)
=SUM((Sheet2)A2:(Sheet2)A7)
在Excel中．若Sheet1工作表的A1单元格需计算Sheet2工作表中A2到A7单元格的和则应在
=SUM(Sheet2!A2:A7)
=SUM(Sheet2!A2:Sheet2!A7)
=SUM((Sheet2)A2:A7)
=SUM((Sheet2)A2:(Sheet2)A7)
在Excel中函数AVERAGEA1A7的功能是
求A1:A7单元格区域的平均值
求A1与A7两个单元格的平均值
求A1与A7两个单元格的方差
函数使用错误
在Excel2003中A7和N9围成的单元格区域的表示为______
A7#N9
A7+N9
A7:N9
A7
下列软件中的公式和函数功能比其他软件更强大
Excel
Word
Basic
FoxBase
在Excel2003中A1到E6单元格的值如下图所示若在A7单元格中输入计算众数的函数=MODEA
92
77
72
60
Excel中AVERAGEA是
求和函数
条件函数
平均值函数
计算函数
Excel中使用函数只能使用插入函数功能不可以直接输入函数
在Excel2003中A1到E6单元格的值如下图所示若在A7单元格中输入函数=COUTAA1E6按
FALSE
TRUE
4
26
Excel工作表的单元格A1中已经填写了星期一想要在A2A7中分别填写星期二星期三„星期日则
只能在这些单元格中分别用键盘输入
先选择区域A1：A7，再选择菜单中的“编辑”→“填充”→“向右填充”
先单击单元格A1，再拖动A1的填充柄经过区域A2：A7
以上B和C中的方法都对
在Excel2003中A1到E5单元格中的值如下图所示若在A6单元格中输入函数=MAXA1:E5-
86
88
89
90
在Excel2003中A7和N9围成的单元格区域的表示为______
A7#N9
A7+N9
A7:N9
A7
在EXCEL工作簿中函数MIN107120的返回值是
10
12
7
在Excel2000工作表中单元A1至A6中分别存放的数据为3129515单元A7中存放这六个数值的
AVERAGE（A1：A10）
SUM（A1：A6）
COUNT（A1：A10）
MAX（A1：A10）
在Excel中函数COUNT071012的返回值是
3
7
4
12
下列Excel公式计算正确的有
如果A1=90、A2=人数、A3=…""、A4=54、A5=36，则公式"=Count（A1：A5）"返回5
如果A1=6.28、A2=3.74，其余单元格为空，则公式"=Counta（A1：A7）"的计算结果等于2
如果A1=90、A2=人数、A3=""、A4=54、A5=36，则公式"=Count（A1：A5）"返回3
如果A1=6.28、A2=3.74，其余单元格为空，则公式"=Counta（A1：A7）"的计算结果等于3
若在Excel的A1单元格中输入函数=LEN信息处理技术员按回车键后A1单元格中的值为______
7
5
3
1
在Excel中函数MIN107120的返回值是
10
7
12
热门试题
更多
a.ThegovernmentisdesperatetosellthemosttroubledofSouthKorea’sbigcompaniestoforeigners.ThisministersbelieveisthebestwaytoacceleratethecorporaterestructuringbeguninthewakeoftheAsianfinancialcrisisin1997andtoclearthewayformoresustainableeconomicgrowth.b.GM’sdeal.withDaewooMotormarkstheendofanevenlongerandmorepainfulprocess.FordalmostboughtthecarmakertwoyearsagobutpulledoutafterdecidingthatDaewoowouldbetoohardtoturnround.c.MicronhadofferedtopayaboutMYM3.4billionforHynix’scorememorybusinessandtotakeaminoritystakeinthenon--memoryarm.AnalystspredictthatthegovernmentwillputpressureoncreditorstorescueadealwithMicronorseekanewbuyerasliquidationistooriskytocontemplateinanelectionyear.d.Thisweekaftermonthsofon--offtalkswithforeignsuitorsthegovernment’splansmovedabigstepforwardandthenanequallybigstepback.e.ButGMhasmuchworktodotorebuildDaewoo’sdamagedbrandimageanddomesticmarketsharewhichhoversaround10%afterreachingahighof37%in1998.GMhastofillholesinproductlinesbyintroducingsport--utilityandmulti--purposevehiclessaysNickReillyformerchiefexecutiveofVauxhallGM’sBritishsubsidiaryandchief--executive--designateofGM--Daewoonowthathehassealedthedeal.f.GMhasstruckagooddeal.Togetherwithvariousundisclosedpartnersitwillholda67%stakeinanewcompanytentativelynamedGM--Daewoo.TheAmericancarmakerwillpayMYM251mforitsownstakeof42%butitwillalsoassumeMYM573mofDaewooMotor’sdebts.TheacquisitionisakeypartofGM’sglobalexpansion.ThecompanyhasbeentryingtostrengthenitsfootholdinAsiaforsometime.g.OnApril30thGeneralMotorsGMsignedacontracttobuythebankruptDaewooMotor.ButonthesamedaytheboardofHynixacash--strappedmemory--chipgiantshockedthemarketsbyrejectingaproposedtakeoverbyMicronTechnologyanAmericancompetitor.h.HismanagementteamcanexpecttroublefromSouthKorea’saggressiveunionsalongtheway.Inasignofthingstocomethesigningceremonywasmovedtoasecretlocationafteragroupofunionactivistsoccupiedthehotelwhereitwasduetotakeplace.i.BuyingapresenceinSouthKoreawasseenasparticularlyurgentsinceimportsaccountforonly3%ofthe1.5mearssoldinthecountryeachyear.GMhopestouseDaewoo’sproductionlinestomakebudgetcarsthatwillbesoldundertheDaewoobrandinmostmarkets.j.GMhadbeentalkingwithDaewooforoverayear.Ithasagreedtobuytwoofthecompany’sfourdomesticcarplantsafactoryinVietnamapartsunitintheNetherlandsandnineoverseassalesarmsallinEuropeexceptoneinPuertoRicoofallplaces.Betweenthemthetwodomesticfactoriescanchurnoutacombined530000carsand30000commercialvehiclesayear.______;
当CapsLock灯亮时表示输入的字母是______
数字信号是指用来表示______的信号
下列不属于在Excel中创建数据清单原则的是
简述计算机系统软件的服务性程序执行的过程和详细功能
在计算机网络的体系结构中位于OSI参考模型最底层的是
圣诞节要到了小红在报纸上看到圣诞节期间有雪于是非常兴奋盼望着能过一个有雪的圣诞节结果圣诞结束了天依然晴好当她又拿起那张报纸看时发现是去年圣诞期间的报纸就信息的特征来说小红忽略了信息的______
磁盘处于写保护状态那么磁盘中的数据______
计算机辅助设计简称是
某实验室的多台计算机需要连入Internet仅有电话线而无网卡需要购置______
a.ThegovernmentisdesperatetosellthemosttroubledofSouthKorea’sbigcompaniestoforeigners.ThisministersbelieveisthebestwaytoacceleratethecorporaterestructuringbeguninthewakeoftheAsianfinancialcrisisin1997andtoclearthewayformoresustainableeconomicgrowth.b.GM’sdeal.withDaewooMotormarkstheendofanevenlongerandmorepainfulprocess.FordalmostboughtthecarmakertwoyearsagobutpulledoutafterdecidingthatDaewoowouldbetoohardtoturnround.c.MicronhadofferedtopayaboutMYM3.4billionforHynix’scorememorybusinessandtotakeaminoritystakeinthenon--memoryarm.AnalystspredictthatthegovernmentwillputpressureoncreditorstorescueadealwithMicronorseekanewbuyerasliquidationistooriskytocontemplateinanelectionyear.d.Thisweekaftermonthsofon--offtalkswithforeignsuitorsthegovernment’splansmovedabigstepforwardandthenanequallybigstepback.e.ButGMhasmuchworktodotorebuildDaewoo’sdamagedbrandimageanddomesticmarketsharewhichhoversaround10%afterreachingahighof37%in1998.GMhastofillholesinproductlinesbyintroducingsport--utilityandmulti--purposevehiclessaysNickReillyformerchiefexecutiveofVauxhallGM’sBritishsubsidiaryandchief--executive--designateofGM--Daewoonowthathehassealedthedeal.f.GMhasstruckagooddeal.Togetherwithvariousundisclosedpartnersitwillholda67%stakeinanewcompanytentativelynamedGM--Daewoo.TheAmericancarmakerwillpayMYM251mforitsownstakeof42%butitwillalsoassumeMYM573mofDaewooMotor’sdebts.TheacquisitionisakeypartofGM’sglobalexpansion.ThecompanyhasbeentryingtostrengthenitsfootholdinAsiaforsometime.g.OnApril30thGeneralMotorsGMsignedacontracttobuythebankruptDaewooMotor.ButonthesamedaytheboardofHynixacash--strappedmemory--chipgiantshockedthemarketsbyrejectingaproposedtakeoverbyMicronTechnologyanAmericancompetitor.h.HismanagementteamcanexpecttroublefromSouthKorea’saggressiveunionsalongtheway.Inasignofthingstocomethesigningceremonywasmovedtoasecretlocationafteragroupofunionactivistsoccupiedthehotelwhereitwasduetotakeplace.i.BuyingapresenceinSouthKoreawasseenasparticularlyurgentsinceimportsaccountforonly3%ofthe1.5mearssoldinthecountryeachyear.GMhopestouseDaewoo’sproductionlinestomakebudgetcarsthatwillbesoldundertheDaewoobrandinmostmarkets.j.GMhadbeentalkingwithDaewooforoverayear.Ithasagreedtobuytwoofthecompany’sfourdomesticcarplantsafactoryinVietnamapartsunitintheNetherlandsandnineoverseassalesarmsallinEuropeexceptoneinPuertoRicoofallplaces.Betweenthemthetwodomesticfactoriescanchurnoutacombined530000carsand30000commercialvehiclesayear.______;
在信息时代计算机的应用非常广泛主要有如下几大领域科学计算信息处理过程控制计算机辅助工程家庭生活和______
______是CPU在单位时间内能一次处理的二进制数的位数
十进制34转成二进制数是
下列关于鼠标操作中各种指针的说法错误的是______
随着我国知识产权法制环境的建立和完善人们的知识产权观念进一步强化了下列说法正确的是______
下列设备中既属于输入设备又属于输出设备的是
是最典型的模拟信号
以下属于冯·诺依曼体系结构计算机的基本思想的是______
下面的函数expand在将字符串s复制到字符串t时将其中的换行符和制表符转换为可见的转义字符表示即用‘/n’表示换行符用 表示制表符 expandchars[]chart[] intij fori=j=0;s[i]!= switchs[i] case :t[①]=② t[j++]=’n’ break; case :t[j++]=③ t[j++]=’t’ break; default:t[④]=s[i] break; t[j]=⑤
商品与顾客两个实体集体之间的联系一般是______
高速缓冲存储器是为了解决______
a.ThegovernmentisdesperatetosellthemosttroubledofSouthKorea’sbigcompaniestoforeigners.ThisministersbelieveisthebestwaytoacceleratethecorporaterestructuringbeguninthewakeoftheAsianfinancialcrisisin1997andtoclearthewayformoresustainableeconomicgrowth.b.GM’sdeal.withDaewooMotormarkstheendofanevenlongerandmorepainfulprocess.FordalmostboughtthecarmakertwoyearsagobutpulledoutafterdecidingthatDaewoowouldbetoohardtoturnround.c.MicronhadofferedtopayaboutMYM3.4billionforHynix’scorememorybusinessandtotakeaminoritystakeinthenon--memoryarm.AnalystspredictthatthegovernmentwillputpressureoncreditorstorescueadealwithMicronorseekanewbuyerasliquidationistooriskytocontemplateinanelectionyear.d.Thisweekaftermonthsofon--offtalkswithforeignsuitorsthegovernment’splansmovedabigstepforwardandthenanequallybigstepback.e.ButGMhasmuchworktodotorebuildDaewoo’sdamagedbrandimageanddomesticmarketsharewhichhoversaround10%afterreachingahighof37%in1998.GMhastofillholesinproductlinesbyintroducingsport--utilityandmulti--purposevehiclessaysNickReillyformerchiefexecutiveofVauxhallGM’sBritishsubsidiaryandchief--executive--designateofGM--Daewoonowthathehassealedthedeal.f.GMhasstruckagooddeal.Togetherwithvariousundisclosedpartnersitwillholda67%stakeinanewcompanytentativelynamedGM--Daewoo.TheAmericancarmakerwillpayMYM251mforitsownstakeof42%butitwillalsoassumeMYM573mofDaewooMotor’sdebts.TheacquisitionisakeypartofGM’sglobalexpansion.ThecompanyhasbeentryingtostrengthenitsfootholdinAsiaforsometime.g.OnApril30thGeneralMotorsGMsignedacontracttobuythebankruptDaewooMotor.ButonthesamedaytheboardofHynixacash--strappedmemory--chipgiantshockedthemarketsbyrejectingaproposedtakeoverbyMicronTechnologyanAmericancompetitor.h.HismanagementteamcanexpecttroublefromSouthKorea’saggressiveunionsalongtheway.Inasignofthingstocomethesigningceremonywasmovedtoasecretlocationafteragroupofunionactivistsoccupiedthehotelwhereitwasduetotakeplace.i.BuyingapresenceinSouthKoreawasseenasparticularlyurgentsinceimportsaccountforonly3%ofthe1.5mearssoldinthecountryeachyear.GMhopestouseDaewoo’sproductionlinestomakebudgetcarsthatwillbesoldundertheDaewoobrandinmostmarkets.j.GMhadbeentalkingwithDaewooforoverayear.Ithasagreedtobuytwoofthecompany’sfourdomesticcarplantsafactoryinVietnamapartsunitintheNetherlandsandnineoverseassalesarmsallinEuropeexceptoneinPuertoRicoofallplaces.Betweenthemthetwodomesticfactoriescanchurnoutacombined530000carsand30000commercialvehiclesayear.______
结构化程序设计的基本原则不包括
主要用来保存当前系统的硬件配置和操作人员对某些参数的设定
十进制数215用二进制数表示是
数据模型按不同的应用层次分为三种类型它们是______数据模型逻辑数据模型和物理数据模型
在最坏情况下冒泡排序的时间复杂度为______
在Windows菜单中暗淡的命令项目表示该命令______
添加新的幻灯片时可以直接使用快捷键完成添加操作
热门题库
更多
中小学校长招聘考试
体育教师招聘考试
信息技术教师招聘考试
音乐教师招聘考试
邮政银行招聘考试
邮政营业员考试
邮政小额贷款信贷员考试
邮政通信信息业务员考试
集邮业务员考试
快递业务员考试
邮政储汇业务员考试
邮政代理金融业务网点考试
邮件分拣员考试
机要业务员考试
邮件转运员考试
邮政业务档案员
湘公网安备 43130202000226号