5.在 Excel,要求表中數(shù)學(xué)大于80的人數(shù),則公式應(yīng)表示為( )A.=count(B2:B9,’’>=80”) B. =countif(B2:B9,”>80” ) C. =sum ( B2:B9,” >=80” ) D. =surmif(B2:B9,’’>80”)
5.在 Excel,要求表中數(shù)學(xué)大于80的人數(shù),則公式應(yīng)表示為( )A.=count(B2:B9,’’>=80”) B. =countif(B2:B9,”>80” ) C. =sum ( B2:B9,” >=80” ) D. =surmif(B2:B9,’’>80”)