题目内容
(请给出正确答案)
[单选题]
设A1单元格中有公式=Sum(B2:D5),在C3单元格插入一列后再删除一行,则A1单元格的公式变成()
A.=Sum(B2:E4)
B.=Sum(B2:E5
C.=Sum(B2:D3)
D.=Sum(B2:E3)
查看答案
如果结果不匹配,请 联系老师 获取答案
A.=Sum(B2:E4)
B.=Sum(B2:E5
C.=Sum(B2:D3)
D.=Sum(B2:E3)
A.SUM(B2:B6)
B.SUM(B2:B7)
C.SUM(D2:D7)
D.SUM(E2:E7)
A.=A1/SUM($A1:$D1)
B.=A1/SUM(A1:$D$1)
C.=A1/SUM(A$1E$1)
D.=A1/SUM(A1:D1)
A.=sum(B2:E2)
B.=sum(B3.F3)
C.=sum(C3.F3)
D.=sum(B3:E3)
A.=SUM(A1+A2+A3+A4)
B.=A1+A2+A3+A4
C.=SUM(A1:A4)
D.=SUM(A1,A2,A3,A4)
A.=B2+B3+C2+C3+D2+E2
B.=B2+B3+D2+D3+E2
C.=B2+B3+D2+E2
D.=B2+B3+C2+D2+E2
A.鼠标从A1拖动到B2选取
B.名称框输入“A1:B2”后回车
C.选中A1单元格,按Shit同时点击B2
D.选中A1后,按Ctr同时点击A2,B1,B2