學(xué)生成績表,,,,,,,,,是否101班前10名,"是否102

班前10名","是否103

班前10名",是否101班前10名,"是否102

班前10名","是否103

班前10名","MOD,ROW函數(shù)的應(yīng)用"

班級,姓名,分?jǐn)?shù),名次,等級,各等級人數(shù),,處理后的分?jǐn)?shù),"101班學(xué)

生總分",,,,,,,

103,易君,62,10,丙,甲等,6,6.2,,0,0,1,0,0,1,6

102,曾毅,66,9,丙,,,6.6,463,0,1,0,0,1,0,5

101,程志,23,15,丁,,,2.3,,0,0,0,0,0,0,4

102,梁智,32,11,丁,,,3.2,,0,0,0,0,0,0,3

102,彭顯,31,12,丁,乙等,2,3.1,,0,0,0,0,0,0,2

102,劉成,21,16,丁,,,2.1,"102班學(xué)

生總分",0,0,0,0,0,0,1

103,胡飛,25,14,丁,,,2.5,,0,0,0,0,0,0,6

103,李強,28,13,丁,,,2.8,,0,0,0,0,0,0,5

101,周航,108,5,甲,丙等,2,10,343,1,0,0,1,0,0,4

101,范書,116,2,甲,,,10,,1,0,0,1,0,0,3

101,林森,119,1,甲,,,10,,1,0,0,1,0,0,2

102,柳鵬,109,4,甲,,,10,"103班學(xué)

生總分",0,1,0,0,1,0,1

103,高明,111,3,甲,丁等,6,10,,0,0,1,0,0,1,6

101,趙云,97,6,甲,,,9.7,,1,0,0,1,0,0,5

102,李星,84,7,乙,,,8.4,309,0,1,0,0,1,0,4

103,劉承,83,8,乙,,,8.3,,0,0,1,0,0,1,3

總分,,1115,"“$”是絕對引用符號,在行號或者列號前加上此符號后，將此單元格復(fù)制到其它單元格中時,自變量的范圍不會改變。",,,,上面的分?jǐn)?shù)是這樣處理的：如果得分不少于100，那么記為10分，否則將得分除以10。,最高分,是用1表示，否則用0表示,,,注意上述函數(shù)的設(shè)置方法和左側(cè)的設(shè)置方法不同。,,,

平均分,,69.69,,,,,,119,各班前10名個數(shù),,,,,,

優(yōu)秀人數(shù),,6,優(yōu)秀率,,37.5%,,,最低分,101班,102班,103班,,,,

及格人數(shù),,8,及格率,,50.0%,,,,4,3,3,,,,

低分(少于40)人數(shù),,6,低分率,,37.5%,,,21,"利用上述函數(shù)也可以統(tǒng)計

各班各個等級人數(shù)，或者

統(tǒng)計符合多個條件的人數(shù)",,,,,,

標(biāo)準(zhǔn)差,,36.83,變異系數(shù),,0.53,,,,,,,,,,

,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,

"H列中的函數(shù)也可以設(shè)置為""＝IF(C3>=100,""10"",C3/10)”，這樣如果某單元格的結(jié)果為10，那么“10”就是文本，無法參與計算。（這樣的設(shè)置和原設(shè)置的區(qū)別在于10加上了引號)。",,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,

"函數(shù)“IF(AND(B2>=6,C2>=6),IF(OR(B2>=8,C2>=8),""優(yōu)秀"",""及格""),""不及格"")”的意義是：

如果B2,C2中的數(shù)值