单选题
在Excel的Sheet1工作表的A1:D19单元格内创建如下图所示学生成绩表,在D19单元格中输入( )可计算及格率。
COUNTIF(C2:C16,">=60")/COUNT(C2 :C16)
=COUNTIF(C2:C16,">=60")/COUNT(C2:C16)
COUNT(C2:C16)/COUNTIF(C2 :C16,">=60")
= COUNT(C2:C16)/COUNTIF(C2:C16,">=60")
相关试题