計(jì)算機(jī)考試操作題excel函數(shù)

1、計(jì)算機(jī)班考試操作題（做完試卷后請(qǐng)以自己的名字保存文件）學(xué)號(hào)性別班級(jí)姓名專(zhuān)業(yè)語(yǔ)文數(shù)學(xué)地理物理英語(yǔ)化學(xué)體育總分平均分名次等級(jí)分備注1S2015000010909男7葉書(shū)航計(jì)算機(jī)7682526510479優(yōu)45876.333337良0S2015000020909女4曾依瀟會(huì)計(jì)87885310013596合格55993.16676優(yōu)0S2015000030909男4張舒電子商務(wù)8295548313095差53989.833311良0S20150

2、00040909男6楊瑞計(jì)算機(jī)8396557912486合格52387.166714良0S2015000050909女1姚露會(huì)計(jì)516356428355優(yōu)35058.333363差0S2015000060909女5李旭蕾電子商務(wù)6575576810572良44273.666743良0S2015000070909男5何丁計(jì)算機(jī)8082587011576差48180.166727良0S2015000080909男8袁菲菲會(huì)計(jì)51905983

3、10979合格47178.529良0S2015000090909女7胥昌電子商務(wù)586160729076優(yōu)41769.547合格0S2015000100909女2姚俊計(jì)算機(jī)5794616710066良44574.166741良0S2015000110909女4徐楊楚會(huì)計(jì)7295628111579優(yōu)5048420良0S2015000120909男5陳顯宇電子商務(wù)2751634610373合格36360.560合格0S20150001309

4、09男3車(chē)金峰計(jì)算機(jī)90946410012587優(yōu)56093.33335優(yōu)0S2015000140909女5向劍鋒會(huì)計(jì)5471656010554良40968.166751合格0S2015000150909女4楊慶怡電子商務(wù)715066637958差38764.557合格0S2015000160909男5房姍姍計(jì)算機(jī)7096679012491合格53889.666712良0S2015000170909男4尹柯會(huì)計(jì)8795689111893

5、優(yōu)552928優(yōu)0S2015000180909女6肖瀟電子商務(wù)6197698312885優(yōu)52387.166714良0S2015000190909男6黃桃計(jì)算機(jī)94707113196差4627735良0S2015000200909男8李錦濤會(huì)計(jì)452171717085合格36360.560合格0S2015000210909女5雷茂曦電子商務(wù)7895728911592優(yōu)54190.166710優(yōu)0S2015000220909女4崔英斐計(jì)算

6、機(jī)8689738012789良54490.66679優(yōu)0S2015000230909男6葉近端會(huì)計(jì)3871744383差30961.859合格0S2015000240909男5王雯靜電子商務(wù)6191758571合格38376.636良0S2015000250909女5賈鈺禹計(jì)算機(jī)86767310873優(yōu)41683.222良0計(jì)算機(jī)班考試操作題（做完試卷后請(qǐng)以自己的名字保存文件）S2015000540909女5石脫韁電子商務(wù)8678921

7、2984良46978.166732良0S2015000550909男4王豐計(jì)算機(jī)6078798481差38263.666758合格0S2015000560909男7韓東會(huì)計(jì)7270807212290差50684.333319良0S2015000570909女6張旭電子商務(wù)547681397173優(yōu)39465.666755合格0S2015000580909女3張宇杰計(jì)算機(jī)86728213793良47078.333331良0S2015000

8、590909女5王恩巧會(huì)計(jì)4541835263差28447.333366差0S2015000600909男4楊凡電子商務(wù)91968410013290合格59398.83331優(yōu)0S2015000610909男5陳瑤計(jì)算機(jī)505885298852優(yōu)36260.333362合格0S2015000620909女4陳惠梅會(huì)計(jì)7764868412480良51585.833318良0S2015000630909女7王蓓電子商務(wù)69898767112

9、76優(yōu)50083.333321良0S2015000640909男6唐悅峰計(jì)算機(jī)526288896963合格42370.545良0S2015000650909男8姜維會(huì)計(jì)408189709272優(yōu)4447442良0S2015000660909女5敖定坤電子商務(wù)567090587063優(yōu)40767.833354合格0各科成績(jī)平均分59.636475.045575.712168.0152102.4777.1212各科的最大值919896100

10、13796各科的最小值272153296952各科成績(jī)不合格率48.48%13.64%13.64%24.24%6.06%10.61%各科成績(jī)合格率51.52%86.36%86.36%75.76%93.94%89.39%各科缺考人數(shù)4203465王姓同學(xué)總分2932姓名總分王姓同學(xué)人數(shù)7王A、各科成績(jī)平均分B、各科的最大值各科的最小值C、學(xué)號(hào)以“S2015000010909“”00001“以序列的方式產(chǎn)生D、用LOOKUP函數(shù)在備注2做出