=SUM(C2:C10) //求和
=AVERAGE(C2:C10) //平均值
=COUNT(C2:C10) //计数
=MAX(C2:C10) //最大值
=MIN(C2:C10) //最小值
=IF(C2>=60,"合格","不合格") //条件判断
效果图：
=SUM(C2:C10) //求和
=AVERAGE(C2:C10) //平均值
=COUNT(C2:C10) //计数
=MAX(C2:C10) //最大值
=MIN(C2:C10) //最小值
=IF(C2>=60,"合格","不合格") //条件判断
效果图：