![](https://static.youtibao.com/asksite/comm/h5/images/m_q_title.png)
[单选题]
Excel公式中需要包括左上角为A1,右下角为H23区域内的所有单元格,其引用运算为()。
A.A1-H23
B.A1,H23
C.A1!H23
D.A1:H23
查看答案
![](https://static.youtibao.com/asksite/comm/h5/images/solist_ts.png)
A.A1-H23
B.A1,H23
C.A1!H23
D.A1:H23
A.=SUM(A1:A3)
B.=SUM(B1:B3)
C.=SUM(A1:B3)
D.=SUM(D1:D3)
A.=AVERAGE(#REF!)
B.=AVERAGE(C1:F5)
C.=AVERAGE(B1:E5)
D.=AVERAGE(B1:F5)
A.=RIGHT(A1,7)
B.=MID(A1,FIND("语",A1)+1,LEN(A1))
C.=LEFT(A1,2)
D.=SUBSTITUTE(A1,"英语")
A.=DATADIF(A1,TODAY(),"y")
B.=DATADIF(A1,TODAY(),"y")"周岁"
C.=DATADIF(A1,NOW(),"y")
D.=YEAR(TODAY())-YEAR(A1)
A.“=C5+D5”
B.“=A1+B1”
C.“=A5+B5”
D.“=C1+D1”
A.=B2*$C4
B.=D8*$C10
C.=D8*$C4
D.=D8*$E10