![](https://static.youtibao.com/asksite/comm/h5/images/m_q_title.png)
[判断题]
在Excel中,公式“=AVERAGE(A1,A5)”表示单元格显示的结果是Al、A2、A3、A4、A5的平均值()
![](https://static.youtibao.com/asksite/comm/h5/images/m_q_a.png)
否
![](https://static.youtibao.com/asksite/comm/h5/images/solist_ts.png)
否
A.=AVERAGE(#REF!)
B.=AVERAGE(C1:F5)
C.=AVERAGE(B1:E5)
D.=AVERAGE(B1:F5)
A.=AVERAGE (B2 : E2 )
B.=AVERAGE ( B2 , E2 )
C.=SUM( B2 , E2 )
D.=SUM( B2 : E2 )
A.=AVERAGE(A1:A2:A3)
B.=SUM(A1:A3)/3
C.=AVERAGE(A1:A3)
D.=(A1+A2+A3)/3
A.=SUM(B3:J7)
B.=MAX(C4:M9)
C.=MIN(D5:K8)
D.=AVERAGE(E7:P10)
A.=MAX(A1:E1)的结果是4
B.=SUM(A1,E1)的结果是12
C.=MIN(A1,B1)的结果是11
D.=AVERAGE(A1:C1)的结果与=(A1+C1)/3的结果相同
A.10,4.5
B.10,10
C.18,4.5
D.18,10
在教学的学业测试中,老师们常用ExCel来统计学生各科的平均成绩。图2中,在B5处输入" =AVERAGE(B2: B4)",如果直接复制粘贴到D5处,则下列数值显咏正确的是()
A.93
B.62
C.30
D.0