【单选题】【消耗次数：1】
在Excel中，如果单元格B5的值是单元格A1、A2、A3、A4的平均值，则在B5中使用的公式是( )。
①
=AVERAGE(A1:A4)
②
=AVERAGE(A1，A2，A3，A4)
③
=AVERAGE(A1+A2+A3+A4)
④
=(A1+A2+A3+A4)
参考答案：
复制
纠错
相关题目
【单选题】
在Excel中,如果单元格A5的值是单元格A1、A2、A3、A4的平均值,则不正确的输入公式为（ ）。
①
=AVERAGE(A1:A4)
②
=AVERAGE(A1,A2,A3,A4)
③
=(A1+A2+A3+A4)/4
④
=AVERAGE(A1+A2+A3+A4)
【单选题】
在Excel中,如果单元格A5的值是单元格A1、A2、A3、A4的平均值,则不正确的输入公式为（ ）。
①
=AVERAGE(A1:A4)
②
=AVERAGE(A1,A2,A3,A4)
③
=(A1+A2+A3+A4)/4
④
=AVERAGE(A1+A2+A3+A4)
【单选题】
已知向量组a1,a2,a3,a4线性无关,则向量组（ ）
①
a1+a2,a2+a3,a3+a4,a4+a1线性无关
②
a1-a2,a2-a3,a3-a4,a4-a1线性无关
③
a1+a2,a2+a3,a3+a4,a4-a1线性无关
④
a1+a2,a2+a3,a3-a4,a4-a1线性无关
【单选题】
字符串a1=〝BEIJING〞, a2 =〝BEF〞 , a3= 〝BEFANG〞, a4=“BEFI〞最小的是（ ）.
①
A. a1
②
B. a2
③
C. a3
④
D. a4
【单选题】
字符串a1=〝BEIJING〞, a2 =〝BEI〞 , a3= 〝BEFANG〞 a4=“BEFI〞中最大的是（ ）。
①
A. a1
②
B. a2
③
C. a3
④
D. a4
【单选题】
在Excel中，已知单元格A1到A4为数值型数据，A5内容为公式“=SUM(A1：A4)”，如果在第3行下面插入一行，则（）。
①
单元格A5内容不变
②
单元格A5内容为“=SUM(Al：A5)”
③
单元格A5为原A4中的内容，单元格A6为“=SUM(Al：A4)”
④
单元格A5为原A4中的内容，单元格A6为“=SUM(Al：A5)”
【单选题】
在Excel 2010中，利用复制柄可以将数据复制到相邻单元格中，若A3、A4单元格的数值为分别为1，4，选中A3、A4单元格向上左键拖动复制柄，则A1单元格中的数值为（ ）。
①
10
②
64
③
-2
④
-5
【单选题】
在A1单元格输入2,在A2单元格输入5,然后选中A1:A2区域,拖动填充柄到单元格A3后，A3单元格的值为8,则得到的数字序列是（ ）。
①
等比序列
②
等差序列
③
数字序列
④
小数序列
【多选题】
在Excel2010中，不能与公式“=AVERAGE(A1:A4)”等价的有_
①
=(A1+A4)/2
②
=A1+A2+A3+A4/4
③
=(A1+A2+A3+A4)/4
④
5=(A1+A2+A3+A4)\4
【单选题】
在A1单元格输入2,在A2单元格输入5,然后选中A1:A2区域,拖动填充柄到单元格A3:A8,则得到的数字序列是（ ）。
①
等比序列
②
等差序列
③
数字序列
④
小数序列
随机题目
【单选题】
A: Hi, Mary. Its Peter. Do you have time to talk? B: Hi, Peter, [填空]. I was just watching TV.
①
so what
②
no doubt
③
sure
④
some time
【单选题】
A: Do you have any check-in luggage? B: [填空]. Theyre heavy. I hope theyre not overweight. A: Theyre just under the maximum weight.
①
Yes, Ill show you
②
Yes, two pieces
③
Yes, there you are
④
Yes, not many
【单选题】
A: I didnt know you play basketball. Are you having fun? B: Im having a great time. [填空] What are you doing?
①
Great!
②
How about you?
③
I miss it so much
④
Do you know billiards?
【单选题】
A: Do you know that Tony quarreled with his brother? B: I dont know,[填空].
①
nor dont I care
②
nor do I care
③
I dont care neither
④
I dont care also
【单选题】
A: Sorry to give you so much trouble. B: [填空].
①
OK. With great pleasure
②
Oh, really? Thats OK
③
Dont worry about it
④
Im sorry to hear that
【单选题】
A: What do you have in mind? B: Im thinking about jewelry or something valuable. A: Weve got beautiful jewelry here. If youre interested, [填空].
①
I can show you
②
you can see it
③
you should buy it
④
Ill get it
【单选题】
A: Were having a few people over for dinner Saturday. [填空] B: Oh, thank you. That would be great.
①
Are you doing anything then?
②
Wed love to have you around.
③
Itll be a lot of fun.
④
Have you heard about it?
【单选题】
A: Please remember me to your parents. B: [填空].
①
They remember seeing you once
②
I am afraid they have poor memories
③
You can contact them directly
④
Thanks a lot. I will
【单选题】
A: Is there anything I can do for you? B: [填空], there is something.
①
No, nothing
②
Well, now that you ask
③
Nothing I can think of
④
If you ask me
【单选题】
A: I like this flat very much, but Id like to come and see it on Friday at 5 oclock. Will that be convenient? B: [填空].
①
Its good for you
②
Thats right
③
Its thoughtful of you
④
Thats fine with me