统计C列中数值在【60，70）之间数字单元格的个数，可用的公式有（）？
A: COUNTIF(C:C,">=60")-COUNTIF(C:C,">=70")
B: COUNTIF((C:C,">=60")-(C:C,">=70"))
C: COUNTIFS(C:C,">=60",C:C,">=70")
D: COUNTIFS(C:C,">=60",C:C,"<70")
A: COUNTIF(C:C,">=60")-COUNTIF(C:C,">=70")
B: COUNTIF((C:C,">=60")-(C:C,">=70"))
C: COUNTIFS(C:C,">=60",C:C,">=70")
D: COUNTIFS(C:C,">=60",C:C,"<70")
举一反三
- 在Excel工作表中,要计算A1:C8区域中值大于等于60的单元格个数,应使用的公式是( )。 A: =COUNT(A1:C8,">=60") B: =COUNTIF(A1:C8,>=60) C: =COUNTIF(A1:C8,">=60") D: =COUNT(A1:C8,>=60)
- 高含水阶段的含水率 A: >90% B: >80% C: >70% D: >60%
- 在Excel工作表中，要计算A1:C8区域中值大于等于60的单元格个数，应使用的公式是_____。 A: =COUNT(A1:C8, ">=60") B: =COUNTIF(A1:C8, >=60) C: =COUNT(A1:C8, >=60) D: =COUNTIF(A1:C8, ">=60")
- 在学生成绩表中，查询成绩为60-70分（不包括70分）的学生记录，正确的条件设置为（） A: >59 or <70 B: Between 60 and 70 C: >=60 and <70 D: in(60-69)
- 工业上，干燥器的热效率一般为______。 A: 30~60% B: <30% C: >70% D: 70~90%