2021年重慶專升本計算機基礎(chǔ)試題之單項選擇題
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”)
正確答案—— B. =countif(B2:B9,”>80” )
=80”) B. =countif(B2:B9,”>80” ) C. =sum ( B2:B9,” >=80” ) D. =surmif(B2:B9,’’>80”)">
2021年重慶專升本計算機基礎(chǔ)試題之單項選擇題
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”)
正確答案—— B. =countif(B2:B9,”>80” )