Ⅰ 濡备綍镓扑贡excel琛ㄦ牸涓鏁版嵁镄勯‘搴忥纻
濡傛灉鎭ㄦ兂镓扑贡 Excel 琛ㄦ牸涓鏁版嵁镄勯‘搴忥纴鍙浠ユ寜镦т互涓嬫ラよ繘琛屾搷浣滐细
鍦 Excel 涓阃変腑鎭ㄨ佹墦涔辩殑鏁版嵁镓鍦ㄧ殑琛屾垨鍒椼
鍦 Excel 凿滃崟镙忎腑镓惧埌钬沧暟鎹钬濋夐”鍗★纴铹跺悗鍦ㄤ笅𨰾夎彍鍗曚腑阃夋嫨钬沧帓搴忊濄
鍦ㄢ沧帓搴忊濆硅瘽妗嗕腑锛岄夋嫨鎭ㄦ兂瑕佹寜镦у摢涓鍒楄繘琛屾帓搴忥纴铹跺悗鍦ㄢ沧帓搴忔柟寮忊濋夐”涓阃夋嫨钬滈殢链衡濄
镣瑰嚮钬灭‘瀹气濇寜阍锛孍xcel 灏变细灏嗘偍阃変腑镄勬暟鎹闅忔満镓扑贡銆
濡傛灉鎭ㄦ兂鍦ㄨ〃镙间腑闅忔満镓扑贡鏁翠釜琛屾垨鍒楋纴鍙浠ヤ娇鐢 Excel 鍐呯疆鍑芥暟钬淩AND()钬濓纴鍏蜂綋镎崭綔濡备笅锛
鍦 Excel 琛ㄦ牸涓鎻掑叆涓涓鏂板垪鎴栨柊琛岋纴铹跺悗鍦ㄧ涓涓鍗曞厓镙艰緭鍏モ=RAND()钬濄
鎸変綇鍗曞厓镙煎彸涓嬭掔殑灏忛粦镣癸纴灏嗗叕寮忓～鍏呭埌鎭ㄨ佹墦涔辩殑琛屾垨鍒椾腑镄勬墍链夊崟鍏冩牸銆
灏呜繖涓鍒楁垨琛屾寜镦цュ垪鎴栬屼腑镄勯殢链烘暟杩涜屾帓搴忓嵆鍙銆
杩欑嶆柟娉曞皢闅忔満鏁版彃鍏ュ埌鎭ㄧ殑琛ㄦ牸涓锛岀劧钖庢牴鎹杩欎簺闅忔満鏁板规暟鎹杩涜屾帓搴忥纴浠庤屾墦涔辨暟鎹镄勯‘搴忋