![](https://static.youtibao.com/asksite/comm/h5/images/m_q_title.png)
[单选题]
在 EXCEL 中,求单元格 B2 、 C2 、 D2 、 E2的和应用公式()
A.=AVERAGE (B2 : E2 )
B.=AVERAGE ( B2 , E2 )
C.=SUM( B2 , E2 )
D.=SUM( B2 : E2 )
![](https://static.youtibao.com/asksite/comm/h5/images/m_q_a.png)
D、=SUM( B2 : E2 )
![](https://static.youtibao.com/asksite/comm/h5/images/solist_ts.png)
A.=AVERAGE (B2 : E2 )
B.=AVERAGE ( B2 , E2 )
C.=SUM( B2 , E2 )
D.=SUM( B2 : E2 )
D、=SUM( B2 : E2 )
A.#VALUE!,表示输入错误
B.“99-2-27”-“99-2-7”,左对齐
C.20,左对齐
D.20,右对齐
在EXCEL操作中,假设在B5单元格中存有一公式为SUM(B2:B4)将其复制到D5后,公式将变成()。
A.SUM(D2:D4)
B.SUM(D2:B4)
C.SUM(B2:D4)
D.SUM(B2:B4)
A. =SUM(A1:$A$10)
B. =SUM(A2:$A$10)
C. =SUM(A1:$A$11)
D. =SUM(A2:$A$11)
A.=$A$1+$F5+C$4
B.=$A$1+$E$5+D$3
C.=$A$1+$E5+C$3
D.=$A$1+$F4+C$4