《商務(wù)數(shù)據(jù)分析與應(yīng)用》Excel版試卷-A卷

得分,,,,,,

"說明及任務(wù)：

1、刪除下表中的重復(fù)數(shù)據(jù)，要求替換掉原表格數(shù)據(jù)（4分）

2、運(yùn)用快速填充的方法，將表格中缺失數(shù)據(jù)補(bǔ)充完整，要求補(bǔ)充的數(shù)據(jù)字體紅色、加粗（6分）

3、將表格中錯誤標(biāo)識符的數(shù)據(jù)糾正為正確的數(shù)據(jù)，糾正的數(shù)據(jù)字體紅色、加粗（5分）",,,,,,

行政班級,學(xué)生學(xué)號,學(xué)生姓名,平時考勤,平時作業(yè),期末考試成績,總成績

13營銷與策劃一班,131115101002,趙月月,100,92,94,94

13營銷與策劃一班,131115101003,周小力,95,88,84,88

13營銷與策劃一班,131115101004,梁蕾,,90,,93

13營銷與策劃一班,131115101005,張蕾,98,88,92,91

13營銷與策劃一班,131115101006,代沙,99,87,,90

13營銷與策劃一班,131115101007,張純潔,98,$,84,86

13營銷與策劃一班,131115101008,陳麗,,87,82,87

13營銷與策劃一班,131115101009,楊洋,100,95,94,96

13營銷與策劃一班,131115101010,成婷婷,98,94,,95

13營銷與策劃一班,131115101006,代沙,99,87,89,90

13營銷與策劃一班,131115101011,陳詩,96,92,,93

13營銷與策劃一班,131115101012,沈雨,,94,90,93

13營銷與策劃一班,131115101013,向婧若,96,95,93,95

13營銷與策劃一班,131115101014,文露露,96,$,92,94

13營銷與策劃一班,131115101015,夏燕,,88,81,87

13營銷與策劃一班,131115101016,黃春露,94,84,85,86

13營銷與策劃一班,131115101017,潘益,95,82,,85

13營銷與策劃一班,131115101018,林小華,,83,82,85

13營銷與策劃一班,131115101015,夏燕,92,88,81,87

13營銷與策劃一班,131115101019,曾秋艷,93,82,,84

13營銷與策劃一班,131115101020,夏強(qiáng),92,81,80,83

13營銷與策劃一班,131115101021,李文博,94,80,76,82

13營銷與策劃一班,131115101022,楊力,94,$,76,81

13營銷與策劃一班,131115101023,姚旭峰,88,74,76,77

13營銷與策劃一班,131115101024,代生杰,99,95,,96

13營銷與策劃一班,131115101025,陽果,90,76,74,78

13營銷與策劃一班,131115101026,熊炳江,,70,62,71

13營銷與策劃一班,131115101027,劉拓君,84,68,62,69

13營銷與策劃一班,131115101024,代生杰,99,95,,96

13營銷與策劃一班,131115101028,闕文臣,80,$,62,70

13營銷與策劃一班,131115101029,李諫,82,71,69,73

13營銷與策劃一班,131115101030,夏超華,92,73,75,77

13營銷與策劃一班,131115101031,袁銀川,,60,62,61

13營銷與策劃一班,131115101032,潘思宇,92,78,,80