2019骞磋伔绋辫▓绠楁鑰冭│銆奅xcel2003銆嬭€冮粸绲�(t菕ng)瑷堝垎鏁�(sh霉)娈�

鏇存柊鏅傞枔锛�2019-03-08 13:40:06 渚嗘簮锛氱挵(hu谩n)鐞冪恫(w菐ng)鏍�

鐎忚

鏀惰棌

鎽樿 鐠�(hu谩n)鐞冪恫(w菐ng)鏍″垎浜簡鈥�2019骞磋伔绋辫▓绠楁鑰冭│銆奅xcel2003銆嬭€冮粸绲�(t菕ng)瑷堝垎鏁�(sh霉)娈碘€濅互涓嬩粙绱逛簡鑱风ū瑷堢畻姗熻€冭│鑰冮粸渚涘ぇ瀹跺弮鑰冿紝鏇村璩囨枡鏁珛闂滄敞鐠�(hu谩n)鐞冪恫(w菐ng)鏍¤伔绋辫▓绠楁鑰冭│闋婚亾锛岀恫(w菐ng)鏍℃渻鍙婃檪鏇存柊鑱风ū瑷堢畻姗熻€冭│鐩搁棞璩囪▕鈥︹€�

绲�(t菕ng)瑷堝垎鏁�(sh霉)娈�

鏈夋檪鍊欓渶瑕佹寜鍒嗘暩(sh霉)娈电当(t菕ng)瑷堜汉鏁�(sh霉)锛屾瘮濡�90鍒嗙殑浜烘暩(sh霉)锛�80鍒嗙殑浜烘暩(sh霉)绛夌瓑锛屼笅闈㈡垜鍊戜締鐪嬩竴鍊嬬反缈�;

1銆佸暉鍕旹xcel

1)榛炴搳“闁嬪-鎵€鏈夌▼搴�-Microsoft-Microsoft Office Excel 2003”;

2)鍑虹従(xi脿n)涓€鍊嬫豢鏄牸瀛愮殑绌虹櫧绐楀彛锛岄€欏氨鏄竴寮甸浕瀛愯〃鏍间簡锛岀涓€鍊嬫牸瀛愮湅钁楅倞妗嗚绮椾竴浜�锛岃檿浜庨伕涓媭鎱�(t脿i);

2銆佺当(t菕ng)瑷堝垎鏁�(sh霉)娈�

1)杓稿叆涓€鍊�8鍊嬫垚绺剧殑鎴愮妇琛紝鍖呭惈搴忚櫉鍜屾垚绺�锛屽苟杓稿叆 90-100銆�80-89銆�70-79銆�60-69銆�0-50 骞惧€嬪垎娈�;

2)閬镐腑“0-50”鍙抽倞鐨勫柈鍏冩牸锛岄粸绶ㄨ集娆勯噷鐨刦x锛屾簴鍌欒几鍏ュ叕寮�锛屽緸浣庡埌楂樺垎娈�锛屽厛绠楁渶浣庡垎鐨勪竴娈�;

3)鍦ㄥ嚭渚嗙殑鍑芥暩(sh霉)鍒楄〃閲�锛屽湪涓枔閬告搰“鍏ㄩ儴”锛岀劧鍚庡湪涓嬮潰鐨勫垪琛ㄩ噷閬告搰 COUNTIF 鍑芥暩(sh霉)锛岄粸纰哄畾鎸夐垥;

4)鎺ヤ笅渚嗘槸 COUNTIF 鍑芥暩(sh霉)闈㈡澘锛岀敤榧犳鎷栧嫊閬镐腑鎵€鏈夋垚绺�锛岄€欏€嬫槸鑼冨湇;

5)鐒跺悗鍦ㄧ浜岃锛屾浠堕噷榛炰竴涓嬶紝鍒囨彌鍒拌嫳鏂囪几鍏ユ硶锛岃几鍏ュ皬浜庤櫉鍜�60锛岀劧鍚庨粸“纰哄畾”锛� <60 閫欐ǎ灏卞彲浠ョ当(t菕ng)瑷堝嚭60鍒嗕互涓嬬殑浜烘暩(sh霉)浜�;

6)鍐嶉伕涓�“60-69”娈垫梺閭婄殑鍠厓鏍�锛岄粸绶ㄨ集娆勯噷鐨刦x锛屾簴鍌欒几鍏ュ叕寮�;

7)鍦ㄥ嚭渚嗙殑鍑芥暩(sh霉)闈㈡澘閲�锛岄倓閬告搰 COUNTIF 鍑芥暩(sh霉)锛岀劧鍚庨粸“纰哄畾”鎸夐垥锛�

鎷栧嫊閬镐腑鎵€鏈夋垚绺�锛屽湪绗簩琛屾浠惰几鍏ュ皬浜�70锛岀劧鍚庨粸“纰哄畾”锛� <70

8)鍥炲埌琛ㄦ牸绐楀彛鍚�锛屽湪绶ㄨ集娆勭殑鍏紡鍚庨潰榛炰竴涓�锛岀劧鍚庤几鍏ユ笡铏�锛岄粸涓€涓嬪墰鎵嶇当(t菕ng)瑷堝嚭渚嗙殑0-59鍒嗘暩(sh霉)娈电殑浜烘暩(sh霉)锛岀劧鍚庨粸鍙抽倞鐨勭稜鑹插嬀纰哄畾锛屽洜鐐�70鍒嗕互涓嬬殑闄や簡60鍒嗘鐨�锛岄倓鍖呮嫭50鍒嗕互涓嬬殑锛屾笡鍘�50鍒嗙殑鍓╀笅灏辨槸60鍒嗕互涓婄殑;

9)鍚屾ǎ鍦ㄩ伕涓�70-79鍙抽倞鐨勫柈鍏冩牸锛岄伕鎿� COUNTIF 鍑芥暩(sh霉)锛屽湪姊濅欢閲岃几鍏ュ皬浜�80榛�“纰哄畾”浠ュ悗锛屽洖渚嗗湪绶ㄨ集娆勯噷锛屽啀榛炰竴涓嬮紶妯�锛屾笡鍘诲墰鎵嶇畻鍑虹殑50鍒嗘鍜�60鍒嗘鐨�;

10)鍚屾ǎ鐨勬柟娉曪紝姹傚嚭80鍒嗘鐨勪汉鏁�(sh霉)锛岀敤娓涘幓鍏╅牠鍓╀笅涓枔鐨勬柟娉�锛屾眰鍑烘墍闇€鐨勫垎鏁�(sh霉)娈典締;灏嶄簬 90-100 鐨勫垎鏁�(sh霉)娈碉紝鍙互鍦ㄦ浠堕噷杓稿叆 >=90 (澶т簬绛変簬90)浠�“鍒嗘暩(sh霉)娈�”鐐烘枃浠跺悕锛屼繚瀛樻枃浠跺埌鑷繁鐨勬枃浠跺ぞ;

绶ㄨ集鎺ㄨ枽

鍒嗕韩鍒帮細绶ㄨ集锛氱挵(hu谩n)鐞冪恫(w菐ng)鏍�

涓婁竴绡囷細2019骞磋伔绋辫▓绠楁銆奧indowsXP銆嬭€冮粸锛氬京鍒舵钀芥牸寮�

涓嬩竴绡囷細2019骞磋伔绋辫▓绠楁鑰冭│銆奅xcel2003銆嬭€冮粸绶ㄨ集鍚岀祫宸ヤ綔琛�

璩囨枡涓嬭級绮鹃伕瑾茬▼ 鑰佸斧鐩存挱鐪熼绶寸繏

鏇村璩囨枡

鏇村瑾茬▼

鏇村鐩存挱

鏇村鐪熼