EXCEL數(shù)據(jù)處理練習(xí)

姓名,班級,考號,語文,數(shù)學(xué),英語,物理,政折,歷折,地折,生折,總分

劉栩,801,2006,98,120,112,93,70.4,60,36.4,38.4,

季晴,801,2011,91,114,115,87,64,60,35.6,39.2,

畢曉龍,801,2012,90,117,110,93,68,57.6,38,40,

徐瓊淞,801,2022,92,113,109,96,72,58.2,36.4,38,

金迪,801,2029,84,112,113,92,65.6,58.8,36.8,39.6,

徐先杰,801,2031,82,115,108,94,65.6,57.6,34.4,38.4,

宋夢含,801,2039,90,113,107,91,59.2,54.6,33.6,38.8,

徐康,801,2044,82,119,109,90,68,58.8,34.4,37.6,

王美娜,801,2046,83,104,81,87,68.8,56.4,31.6,38,

徐涵,801,2056,83,119,97,78,64,54,33.2,38.4,

劉玉前,801,2065,86,102,91,88,64,57.6,36,38,

張雪,801,2067,83,74,90,87,62.4,52.2,34,39.6,

宋福星,801,2074,78,106,97,91,67.2,48.6,32,36.4,

管俏慧,801,2083,83,75,89,75,60,46.8,29.2,36.4,

徐碩,801,2089,81,80,101,79,63.2,50.4,32,36.4,

林泉辰,801,2092,89,109,104,92,61.6,57.6,35.2,38,

錢一兵,801,2093,67,76,27,78,56,52.2,26.4,38.8,

安秀玲,801,2095,83,102,90,82,60,46.2,31.6,35.6,

左然祥,801,2102,79,91,96,68,56,55.2,31.6,36,

劉耀欣,801,2110,79,57,94,74,41.6,51,32,30,

劉璐,801,2116,81,102,99,75,59.2,44.4,34.4,38.8,

張嘉杰,801,2119,79,95,86,74,52.8,55.2,32,34.4,

付玉雪,801,2129,73,64,76,59,64.8,46.2,31.2,34.4,

馬熙成,801,2130,72,100,89,85,54.4,51.6,32,36,

孫瑜,801,2141,75,109,87,76,53.6,42,31.6,34,

高國興,801,2142,77,83,81,71,51.2,48.6,26,26.4,

于躍,801,2149,77,74,77,67,59.2,46.2,31.6,34,

龔樹志,801,2154,71,86,72,76,70.4,54,31.6,36,

魏清濤,801,2165,74,67,67,69,58.4,54,25.2,31.6,

薛娜,801,2168,79,30,98,49,61.6,46.8,28,31.6,

王曉彤,801,2175,65,21,62,50,52.8,31.2,22.8,29.6,

傅亞楠,801,2180,71,27,67,58,50.4,27.6,23.2,32.8,

高曉鋒,801,2187,70,92,44,77,59.2,51,32,34.4,

李娜,801,2190,75,45,88,51,47.2,49.2,16.8,34.4,

陳濤,801,2197,73,75,30,52,56,50.4,34.4,30,

彭姝赫,801,2207,73,10,79,37,44,25.2,16.8,27.6,

王帥帥,801,2210,63,20,50,56,55.2,51,24,33.6,

魏韓,801,2216,68,6,35,36,40,27,12.8,21.2,

徐繼印,801,2221,52,12,20,25,38.4,27.6,14.4,24.8,

邵政偉,801,2237,57,9,11,50,48,30,11.2,29.2,

尹夢嬌,801,2239,65,9,21,22,43.2,31.8,13.2,25.2,

安豐潤,801,2243,34,14,13,21,41.6,12.6,5.2,20.4,

各科平均分,,,,,,,,,,,

各科最高分,,,,,,,,,,,

各科最低分,,,,,,,,,,,

姓名,班級,考號,語文,數(shù)學(xué),英語,物理,政折,歷折,地折,生折,總分

徐文秀,802,2003,95,113,109,96,74.4,58.8,38.4,39.6,

劉永飛,802,2014,85,113,110,96,68.8,57.6,35.2,39.2,

李夢潔,802,2017,93,111,108,97,57.6,57,34.8,39.2,

趙洪英,802,2018,91,105,101,92,60,60,36.8,39.2,

高睿博,802,2021,84,111,97,97,66.4,59.4,36.8,38,

畢亞男,802,2034,85,117,108,89,68.8,57,34.8,36.4,

趙詠敏,802,2036,84,106,101,92,52,57.6,33.2,40,

孟憲琪,802,2051,80,110,104,88,64.8,60,35.2,37.6,

孫儉富,802,2054,82,112,89,83,57.6,57,36.4,37.6,

馬志強(qiáng),802,2055,87,114,104,91,61.6,54,35.2,36,

徐涵,802,2057,88,97,107,85,50.4,52.2,34,36.4,

唐敏,802,2064,87,92,91,92,68.8,54.6,32.4,35.6,

王溥飛,802,2075,81,117,102,83,68,56.4,34.4,37.6,

丁瑛婕,802,2076,85,77,86,82,60.8,57,33.6,38,

王煥鵬,802,2082,82,109,95,83,62.4,55.2,29.6,38,

趙玲玲,802,2105,77,63,99,76,55.2,55.8,30.8,35.2,

徐曉菲,802,2106,81,111,76,86,64,51.6,34.8,36.4,

孫儉成,802,2109,79,96,54,90,57.6,51,32.8,37.2,

姜偉,802,2122,74,88,84,76,59.2,51,34,35.2,

鮑敏,802,2123,71,92,88,77,55.2,55.2,30,36.4,

王莉翔,802,2134,81,92,90,81,59.2,45.6,30.8,31.2,

張凱,802,2135,69,111,86,76,57.6,52.8,34.4,32.8,

劉碩,802,2146,79,103,82,85,63.2,55.8,35.2,37.2,

徐瑞英,802,2147,79,87,76,62,68,52.2,31.6,30.8,

張崇峰,802,2159,68,70,62,64,56,49.8,28,28.4,

彭慧修,802,2160,68,30,47,56,49.6,50.4,28.8,32.4,

徐子安,802,2171,73,68,77,69,57.6,48.6,29.2,32.4,

劉曉輝,802,2176,73,29,60,50,56.8,48.6,21.2,22,

馬林海,802,2182,82,30,81,61,52.8,51.6,26.4,27.6,

王昊,802,2183,77,49,40,61,55.2,52.2,22,30,

張雪,802,2199,53,0,76,44,60,32.4,24.8,31.2,

呂夢娜,802,2201,70,22,62,45,50.4,51,21.2,30.4,

王文斌,802,2203,65,53,29,74,61.6,50.4,29.2,25.2,

陳旭,802,2205,61,24,33,54,46.4,48.6,21.6,24.4,

劉倩,802,2222,62,8,38,26,40,36,12,14.4,

朱潔,802,2224,62,22,36,43,48.8,42,18.4,22.8,

徐先康,802,2227,38,31,41,41,41.6,27,16.4,24.4,

畢明輝,802,2228,58,11,21,54,40.8,49.2,19.6,29.6,

金孝論,802,2240,58,15,28,13,48.8,42.6,14,24.4,

楊永法,802,2244,35,12,13,17,39.2,34.2,15.6,14.8,

王琨,802,2246,13,9,12,35,33.6,27.6,11.6,22.4,

高杰,802,2250,18,9,11,21,29.6,24,11.2,15.2,

各科平均分,,,,,,,,,,,

各科最高分,,,,,,,,,,,

各科最低分,,,,,,,,,,,

姓名,班級,考號,語文,數(shù)學(xué),英語,物理,政折,歷折,地折,生折,總分

肖雨,803,2002,92,112,110,94,64,58.8,36,40,

徐蕾,803,2015,89,113,107,88,68,56.4,36.8,38.8,

王方林,803,2016,92,117,108,91,64.8,59.4,36.8,39.2,

徐曉夢,803,2020,81,101,102,88,49.6,53.4,37.6,39.2,

鄭培興,803,2026,83,113,108,92,61.6,58.8,38.4,38.8,

金翠,803,2035,89,76,102,87,68,55.8,35.2,39.2,

付曉,803,2037,83,105,104,89,69.6,58.8,36.8,37.2,

高琪,803,2050,78,93,99,88,67.2,54,34,38,

高天興,803,2053,73,98,88,80,70.4,52.8,34,38.4,

常文強(qiáng),803,2059,79,102,93,88,60,58.2,34,36.4,

趙娜,803,2061,84,107,101,82,61.6,55.8,34,39.2,

王鑫,803,2072,80,111,99,79,60.8,55.8,37.2,36.8,

王淑鴻,803,2079,79,92,105,67,64.8,57.6,32,35.6,

吉喆,803,2080,66,106,86,79,53.6,55.2,32.8,35.2,

王圣潔,803,2085,80,101,100,86,55.2,56.4,35.6,36.8,

高赟,803,2100,80,90,89,76,50.4,54,34.4,36.8,

姜頓鑫,803,2103,80,50,90,64,57.6,58.8,33.2,32,

劉珍,803,2107,72,85,85,78,64,54,31.6,34,

徐繼朋,803,2113,80,97,87,83,56,57.6,34.8,37.2,

朱全曉,803,2121,85,82,99,72,56.8,50.4,28.4,31.6,

陳夢茹,803,2126,77,92,101,82,55.2,51,33.6,31.6,

孫曉,803,2136,81,86,101,79,54.4,51.6,30.4,32.8,

金鵬程,803,2139,76,89,80,84,51.2,54,36.4,34.4,

李偉華,803,2143,79,63,97,70,44.8,52.8,23.6,30.4,

徐佳琳,803,2152,76,58,87,75,55.2,58.8,30.4,32.8,

王濤,803,2158,73,75,38,64,57.6,54.6,26.8,32.8,

畢恩興,803,2163,63,82,69,65,49.6,53.4,25.6,20.8,

山鈺昕,803,2169,64,47,77,75,51.2,40.2,23.2,31.2,

趙海燕,803,2177,75,10,79,62,53.6,46.2,23.6,27.2,

陳富強(qiáng),803,2179,75,64,54,75,56.8,51.6,26,29.6,

王廣秋,803,2185,51,99,39,79,53.6,38.4,29.6,30.8,

張?jiān)鰩r,803,2195,58,12,40,60,54.4,39.6,26.4,26,

張昊,803,2200,63,57,22,49,52,37.2,27.2,18.8,

付雪,803,2202,66,58,67,72,45.6,46.8,25.2,33.2,

徐光柱,803,2206,62,27,40,61,46.4,54,27.2,30.4,

畢善玥,803,2219,49,8,29,36,42.4,29.4,16,17.6,

趙桂杰,803,2225,47,9,16,46,32.8,28.2,9.2,22.4,

姜志豪,803,2226,55,22,19,58,40.8,26.4,8.4,25.2,

鄭奇,803,2233,53,16,27,42,40,30,8,16.4,

徐先劉,803,2241,13,0,15,27,32,22.2,8,16.4,

宋蔚棟,803,2245,11,9,14,29,36,7.2,15.6,28.4,

孫元華,803,2252,7,15,12,29,23.2,23.4,8.4,7.2,

惠誠,803,2256,34,12,12,18,31.2,8.4,4.4,8,

各科平均分,,,,,,,,,,,

各科最高分,,,,,,,,,,,

各科最低分,,,,,,,,,,,

姓名,班級,考號,語文,數(shù)學(xué),英語,物理,政折,歷折,地折,生折,總分

孫玉蕾,804,2007,90,108,111,92,64.8,60,38.4,38,

趙偉,804,2008,94,115,111,93,68.8,57,37.6,38.4,

李華,804,2010,93,113,108,92,66.4,58.2,36.8,36.4,

劉麗君,804,2024,85,118,106,94,56.8,58.8,37.2,38.8,

高玉,804,2028,83,111,103,87,65.6,55.2,38.4,34.8,

蘇厚鑫,804,2032,90,96,104,94,64,56.4,34.4,38.8,

劉潔,804,2041,83,116,97,87,65.6,52.8,36.8,35.2,

李秀陽,804,2045,86,110,103,82,62.4,54,34,33.6,

耿濤,804,2052,88,114,96,86,60.8,59.4,34.8,36.8,

逄婷婷,804,2062,84,104,84,82,51.2,49.8,33.2,38.8,

朱夢華,804,2066,78,54,100,90,60,46.2,35.2,38.4,

崔洋,804,2068,88,107,98,89,57.6,54.6,37.2,32,

畢恩宗,804,2073,85,104,89,89,64,51,36.4,38.4,

李賽賽,804,2087,85,90,103,78,65.6,50.4,33.2,35.2,

姜惠文,804,2091,76,87,80,78,53.6,43.8,31.6,30.4,

劉全輝,804,2094,78,100,65,86,55.2,54,36.4,39.2,

封碩,804,2098,71,95,97,81,50.4,46.8,34.4,31.6,

安柏穎,804,2111,69,96,96,84,48.8,54.6,31.2,33.6,

孫宇,804,2115,82,116,87,79,51.2,45.6,32.4,29.2,

柳峰,804,2120,75,98,81,81,54.4,50.4,27.6,37.6,

劉同帥,804,2128,68,103,50,81,51.2,55.2,35.2,36,

逄佳慧,804,2132,79,69,75,70,48,46.2,34,34.4,

劉瑋,804,2138,71,84,71,68,40,52.8,28.4,34.8,

劉暢,804,2144,68,92,71,76,54.4,47.4,28.8,29.6,

付?；?804,2153,69,69,54,77,40.8,46.8,35.6,32.4,

山霞,804,2156,73,51,74,46,56,40.8,24.8,27.2,

徐桂芝,804,2162,68,68,72,67,57.6,48.6,26.4,28,

鮑穎超,804,2164,67,84,56,70,54.4,42.6,29.6,27.2,

徐興勇,804,2173,78,56,69,71,48,42.6,31.6,30.8,

劉捷,804,2181,76,65,62,79,64.8,56.4,36,36,

徐先華,804,2189,70,27,30,54,60.8,49.2,29.2,32,

陳躍強(qiáng),804,2191,76,31,63,54,44.8,50.4,27.2,26.8,

張思鵬,804,2196,68,101,23,82,52.8,48.6,29.6,32.8,

畢曉,804,2209,59,15,68,57,47.2,50.4,18.8,27.2,

宋福泉,804,2211,49,43,31,54,42.4,34.8,23.6,27.2,

楊芳芳,804,2215,53,27,36,46,47.2,40.2,19.2,31.6,

曹杰,804,2220,35,3,20,51,40,22.8,11.2,19.2,

姜濤,804,2231,42,11,19,34,32.8,33,5.6,13.6,

王梓亞,804,2236,40,9,9,38,35.2,33,11.6,33.2,

徐先森,804,2247,15,1,11,24,26.4,19.8,3.2,11.2,

劉志陳,804,2253,24,0,12,31,24.8,4.8,8,15.2,

殷聚兵,804,2254,49,3,11,16,24,12,4,8.4,

各科平均分,,,,,,,,,,,

各科最高分,,,,,,,,,,,

各科最低分,,,,,,,,,,,

姓名,班級,考號,語文,數(shù)學(xué),英語,物理,政折,歷折,地折,生折,總分

徐家旋,805,2004,96,113,108,96,64.8,60,37.2,38.8,

逄慧婷,805,2013,89,118,105,89,68,58.8,37.6,36,

李博成,805,2019,94,103,110,89,56.8,55.8,36.8,35.2,

程楠,805,2023,95,110,109,94,60.8,58.2,36.4,38.4,

張晶晶,805,2027,92,117,113,92,71.2,58.8,36.8,39.2,

董岳,805,2033,91,114,110,95,60,58.8,35.6,38,

王賀,805,2040,88,112,111,91,62.4,55.2,33.6,38,

張坤超,805,2047,87,117,107,89,64,57,36.4,40,

張可欣,805,2048,83,99,98,82,55.2,51,32.8,33.2,

王義臣,805,2058,87,120,106,89,57.6,57.6,35.6,36.8,

付曉靜,805,2060,90,115,105,89,60,57,33.2,36,

李佳慧,805,2071,89,96,104,86,59.2,56.4,35.6,36.8,

劉信淑,805,2077,83,107,97,89,56.8,51,33.2,35.2,

周程遠(yuǎn),805,2081,73,115,81,87,56.8,55.2,36,38,

張旭東,805,2084,81,102,98,91,61.6,57.6,33.6,36.4,

王凱飛,805,2086,84,95,101,91,67.2,57,33.2,38.4,

高萌華,805,2099,80,74,95,82,56,51.6,32.8,38,

王文聰,805,2101,77,91,89,84,42.4,52.2,30,38.4,

徐麗麗,805,2108,82,93,98,90,58.4,53.4,36,37.2,

王超,805,2117,84,80,107,71,60.8,53.4,34,39.6,

李秀程,805,2118,74,101,89,87,55.2,49.8,29.6,34.8,

王文博,805,2127,72,111,49,84,61.6,56.4,35.2,39.6,

朱成俊,805,2131,85,106,97,89,50.4,51.6,34.4,33.2,

孫世坤,805,2140,77,71,82,67,45.6,49.2,36.4,38.4,

孫雪,805,2145,78,117,96,86,64,54.6,31.2,34.8,

王秀雋,805,2151,79,79,81,65,65.6,49.8,31.6,33.6,

徐先東,805,2157,61,76,52,45,52.8,33,26,30,

畢曉亮,805,2166,73,55,72,80,45.6,43.8,26,29.6,

張曉瓊,805,2170,74,55,70,78,60.8,48.6,30.8,35.2,

王文濤,805,2174,69,42,30,52,51.2,52.2,31.6,34,

滕美鳳,805,2178,76,58,63,65,51.2,49.2,26,30,

高玉濤,805,2184,69,60,45,61,56.8,53.4,26.4,32,

劉萍,805,2192,77,32,75,46,48,54,26.4,28,

高康興,805,2198,71,59,58,53,47.2,33.6,19.2,32.4,

徐曉慧,805,2204,65,6,40,47,58.4,51.6,23.2,25.2,

彭俊翔,805,2208,61,83,27,59,24,35.4,26.4,28.8,

王玉潔,805,2217,59,8,38,54,49.6,29.4,16.8,21.6,

高霖,805,2223,49,6,17,68,53.6,41.4,30.8,31.2,

高興銳,805,2229,63,18,15,38,50.4,37.8,12,25.6,

趙月,805,2234,51,9,21,36,48.8,40.2,8,21.2,

趙彭,805,2238,59,16,21,17,44.8,45.6,22.8,29.2,

張豪,805,2242,56,24,12,25,48,34.2,10.8,24.4,

張亭文,805,2251,38,8,11,19,28.8,10.2,14.8,15.2,

各科平均分,,,,,,,,,,,

各科最高分,,,,,,,,,,,

各科最低分,,,,,,,,,,,

姓名,班級,考號,語文,數(shù)學(xué),英語,物理,政折,歷折,地折,生折,總分

閆志興,806,2001,94,117,116,98,68.8,58.8,38.4,39.6,

張帥,806,2005,93,118,102,93,68.8,56.4,37.6,36.4,

孫亞麗,806,2009,95,109,112,92,67.2,59.4,36.8,37.2,

張坤梅,806,2025,87,117,109,93,56,56.4,36.8,38.4,

呂蕾,806,2030,80,103,103,93,64,53.4,36.4,38.8,

徐超,806,2038,88,82,104,87,66.4,58.8,35.6,38.8,

朱穎,806,2042,93,107,106,92,61.6,57,34.8,37.6,

張經(jīng)凱,806,2043,79,119,98,94,61.6,57.6,34.8,35.2,

徐福斌,806,2049,81,110,106,86,58.4,54,36.4,38,

楊杰,806,2063,87,101,113,75,64.8,53.4,32,36.4,

郭明哲,806,2069,88,104,103,96,68,55.2,35.2,37.6,

張忠國,806,2070,87,96,98,74,67.2,53.4,34.8,37.6,

張恒霞,806,2078,88,100,101,78,59.2,57.6,32.8,35.2,

宋佳慧,806,2088,86,78,95,75,58.4,53.4,30.4,35.2,

李曉晨,806,2090,86,98,89,74,59.2,53.4,33.6,35.6,

張?jiān)葡?806,2096,76,107,101,84,46.4,54,36,35.6,

趙德男,806,2097,