如圖所示為各科教科書(shū)的單價(jià)和銷售數(shù)量,現(xiàn)在想要知道銷售數(shù)量超過(guò)40的有多少種教科書(shū),以下哪個(gè)公式能夠?qū)崿F(xiàn)?()
A.=COUNTIFS(B3:H3,">=40") B.=COUNTIFS(B3:H3,">40") C.=COUNT(B3:H3,">=40") D.=COUNT(B3:H3,">40")
如圖所示為各科教科書(shū)的單價(jià)和銷售數(shù)量,現(xiàn)在想知道一共有多少種教科書(shū)在銷售,以下哪些公式能夠?qū)崿F(xiàn)?()
A.=COUNT(B1:H3) B.=COUNT(B1:H2) C.=COUNT(B1:H1) D.=COUNT(B2:H3)
A.=IF(A1<60,"不及格",if(A1<80,"合格",if(A1<=90,"良好","優(yōu)秀"))) B.=IF(A1<60,"不及格",if(A1<=80,"合格",if(A1<90,"良好","優(yōu)秀"))) C.=IF(A1>90,"優(yōu)秀",if(A1<60,"不及格",if(A1>80,"良好","合格"))) D.=IF(A1>90,"優(yōu)秀",if(A1<60,"不及格",if(A1=>80,"良好","合格")))