A.=AVERAGE(#REF!)
B.=AVERAGE(C1:F5)
C.=AVERAGE(B1:E5)
D.=AVERAGE(B1:F5)
A.Fail
B.Pass
C.Good
D.IF(A1>=60,”Pass”,"Fail”)
A.FAIL
B.PASS
C.GOOD
D.IF(AL>=60,“PASS”,“FAIL”)
A. =SUM(A1:$A$10)
B. =SUM(A2:$A$10)
C. =SUM(A1:$A$11)
D. =SUM(A2:$A$11)
在Excel中输入字符串时,若该字符串的长度超过单元格的显示宽度,则超过部分最有可能()。
A.被截断删除
B.继续超格显示
C.给出错误提示
D.作为另一个字符串存人右侧相邻单元
A.yes
B.no