网友您好, 请在下方输入框内输入要搜索的题目:
题目内容
(请给出正确答案)
平均数(average)
参考答案
更多 “平均数(average)” 相关考题
考题
下列关于Excel的函数说法正确的是( )。A.函数的形式是([参数1],[参数2],……)B.Excel提供了13类函数,每一类有若干个不同的函数C.函数中至少具备一个参数D.AVERAGE是求平均数函数
考题
已知A1单元格中的公式为=AVERAGE(Bl:F6),将B列删除之后,A1单元格中的公式将调整为()。A、=AVERAGE(#REF!)B、=AVERAGE(C1:F6)C、=AVERAGE(B1:E6)D、=AVERAGE(B1:F6)
考题
Studies have shown that the stature of an average Japanese has surpassed that of an average Chinese.A:weight
B:height
C:life span
D:size
考题
以下关于AVERAGE函数使用正确的有()。A AVERAGE(B2,B5,4)B AVERAGE(B3,B5)C AVERAGE(a2∶a5,4)D AVERAGE(B2∶B5,a3∶a5)
考题
在EXCEL中,下列公式表示正确的是()A、"=AVERAGE(C2:F2)"B、"=AVERAGE(C2F2)"C、"=AVERAGE(C2+F2)"D、"=AVERAGE(C2+D2+E2+F2)"
考题
以下常用EXCEL函数不正确的是()A、算数平均数用AVERAGE函数计算B、几何平均数用geomean函数计算C、开方根用power函数D、相关系数用CORREL函数计算E、标准差用devsq函数计算
考题
计算所有籍贯为河北或邯郸的学生的平均成绩,并将结果赋予变量score中,应使用命令()。A、AVERAGE 成绩 TO score FOR籍贯=“河北” AND 籍贯=“邯郸”B、AVERAGE 成绩 TO score FOR籍贯=“河北” OR 籍贯=“邯郸”C、AVERAGE 成绩 TO score FOR籍贯=“河北” AND “邯郸”D、AVERAGE 成绩 TO score FOR籍贯=“河北”OR “邯郸”
考题
在Excel2003中,C7单元格中有函数=AVERAGE($C$3:$C$6),把它复制到C8单元格后,再双击C8,则该单元格中显示()。A、=AVERAGE(C3:C6)B、=AVERAGE($C$3:$C$6)C、=AVERAGE($C$4:$C$7)D、=AVERAGE(C4:C7)
考题
若单元格A5内公式为“=AVERAGE(B$2:B$5)”,则复制到B200单元格后公式变为()。A、=AVERAGE(B$2:B$5)B、=AVERAGE(C$2:C$5)C、=AVERAGE(B$197:B$200)D、=AVERAGE(C$197:C$200)
考题
单选题以下常用EXCEL函数不正确的是()A
算数平均数用AVERAGE函数计算B
几何平均数用geomean函数计算C
开方根用power函数D
相关系数用CORREL函数计算E
标准差用devsq函数计算
考题
单选题The average of a, b, c, d, and e is 28. If the average of a, c, and e is 24, what is the average of b and d?A
31B
32C
33D
34E
36
考题
单选题If the average of 8 and x is 10 and the average of 7 and y is 11, what is the average of x and y?A
9.0B
10.5C
12.0D
13.5E
15.00
考题
单选题已知Al单元格中的公式为=AVERAGE(B1:F6),将B列删除之后,A1单元格中的公式将调整为()。A
=AVERAGE(#REF!)B
=AVERAGE(C1:F6)C
=AVERAGE(B1:E6)D
=AVERAGE(B1:F6)
考题
问答题An aircraft flew from A to B at an average speed of 230 mph. It returned from B to A at an average speed of 300 mph. What was its average speed for the two journeys?
考题
单选题在Excel2010中,F1单元格的公式为“=Average($C$3:$C$6)”,把它复制到F2单元格中后,双击它显示:()A
=Average(C3:C6)B
=Average($C$3:$C$6)C
=Average($C$4:$C$7)D
=Average($C$3:C6)
考题
单选题若单元格A5内公式为“=AVERAGE(B$2:B$5)”,则复制到B200单元格后公式变为()。A
=AVERAGE(B$2:B$5)B
=AVERAGE(C$2:C$5)C
=AVERAGE(B$197:B$200)D
=AVERAGE(C$197:C$200)
考题
单选题For married mothers, the time spend on child care increased to an average of 12.9 hours a week in 2009.A
ForB
spendC
increasedD
an average
考题
问答题At the eating contest the winner ate an average of 15 hot dogs at the first 20 sittings. After a further 20 sittings the average increased to 20 hot dogs. What was the average for the last 20 sittings?
考题
问答题At the beer-drinking contest the winner drank an average of 10 bottles of beer at the first 20 rounds. After a further 20 rounds the average increased to 15 bottles. What is the average for the last 20 rounds?
考题
单选题若要对A3至B6区域中的数据求平均数.并把所得结果置于A1中,则应在A1中输入公式A
=AVERAGE(A1:B6)B
=AVERAGE(A3:B6)C
=AVERAGE(A2:B7)D
=AVERAGE(A3:B1)
考题
判断题AVERAGE用于计算范围参数的算数平均数,COUNT用于计算范围参数的个数。()A
对B
错
热门标签
最新试卷