• 2022-06-15 问题

    Excel 2010下的学生成绩统计单,单元格B2:B31中内容为全班30名同学的计算机成地若要在B32单元格中统计90分以上(包括90分)的同学的人数,则在B32中输入函数,其正确的写法是( ) A: =SUMF(B2:B31,">; 90","人数") B: =COUNTF(B2:B31,”>;=90") C: =IF(B2:B31,">; 90",”人数") D: =COUNTIF(B2:B31,">; =90","人数")

    Excel 2010下的学生成绩统计单,单元格B2:B31中内容为全班30名同学的计算机成地若要在B32单元格中统计90分以上(包括90分)的同学的人数,则在B32中输入函数,其正确的写法是( ) A: =SUMF(B2:B31,">; 90","人数") B: =COUNTF(B2:B31,”>;=90") C: =IF(B2:B31,">; 90",”人数") D: =COUNTIF(B2:B31,">; =90","人数")

  • 2022-06-15 问题

    Excel 2016下的学生成绩统计单,单元格B2:B31中内容为全班30名同学的计算机成地若要在B32单元格中统计90分以上(包括90分)的同学的人数,则在B32中输入函数,其正确的写法是( ) A: =SUMF(B2:B31,">; 90","人数") B: =COUNTF(B2:B31,”>;=90") C: =IF(B2:B31,">; 90",”人数") D: =COUNTIF(B2:B31,">; =90","人数")

    Excel 2016下的学生成绩统计单,单元格B2:B31中内容为全班30名同学的计算机成地若要在B32单元格中统计90分以上(包括90分)的同学的人数,则在B32中输入函数,其正确的写法是( ) A: =SUMF(B2:B31,">; 90","人数") B: =COUNTF(B2:B31,”>;=90") C: =IF(B2:B31,">; 90",”人数") D: =COUNTIF(B2:B31,">; =90","人数")

  • 1