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

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

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

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

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

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

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

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

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

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

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