NCRE题库

登录注册
首页题库练习题目详情
MS Office 高级应用单选题中等

在Excel中，若要计算A1:A5区域中大于10的数字个数，并判断是否超过3个，下列公式的最佳写法是？

A=IF(COUNTIF(A1:A5,">10")>3, "是","否")
B=IF(OR(COUNTIF(A1:A5,">10")>3, "是"), "是","否")
C=IF(AND(COUNTIF(A1:A5,">10")>3, "是"), "是","否")
D=IF(COUNTIF(A1:A5,">10")==3, "等于","不等于")
上一题下一题