![](https://static.youtibao.com/asksite/comm/h5/images/m_q_title.png)
[单选题]
在Excel中,已知A1单元格中的公式为“=AVERAGE(B1:F5)”,将B列删除之后,A1单元格中的公式将调整为________。
A.=AVERAGE(#REF!)
B.=AVERAGE(C1:F5)
C.=AVERAGE(B1:E5)
D.=AVERAGE(B1:F5)
查看答案
![](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.=SUM(A1:A3)
B.=SUM(B1:B3)
C.=SUM(A1:B3)
D.=SUM(D1:D3)
A.=DATADIF(A1,TODAY(),"y")
B.=DATADIF(A1,TODAY(),"y")"周岁"
C.=DATADIF(A1,NOW(),"y")
D.=YEAR(TODAY())-YEAR(A1)
A.蓝色的-98.00
B.红色的-98.00
C.蓝色的-98
D.红色的-98