鍒濈礆(j铆)闆荤畻鍖� 杓斿皫(d菐o)璎涚京锛氶浕瀛愯〃鏍艰粺浠�(5)

鏇存柊鏅�(sh铆)闁擄細2011-11-03 09:22:21 渚嗘簮锛殀0

鐎忚

鏀惰棌

銆€銆€3.杓稿叆鍏紡銆侲xcel涓殑鍏紡鏄敱閬�(y霉n)绠楃銆佸父閲�銆佸柈鍏冩牸鍦板潃銆佸嚱鏁�(sh霉)鍜屾嫭铏�(h脿o)绛夌祫鎴�銆傝几鍏ュ叕寮忔檪(sh铆)蹇呴爤浠モ€�=鈥濋枊闋€�$lesson$

銆€?銆佹顐囪璋愶汲鐜€猏(y霉n)绠楃鏈夌畻琛�(sh霉)閬�(y霉n)绠楃銆侀棞(gu膩n)绯婚亱(y霉n)绠楃绛夌瓑銆�

銆€銆€绠楄(sh霉)閬�(y霉n)绠楃锛�()(鎷櫉(h脿o))銆�+(鍔�)銆�-(娓�)銆�*(涔�)銆�/(闄�)銆乛(鍐�)銆傞亱(y霉n)绠楃殑鍎�(y艒u)鍏堢礆(j铆)鍒ヤ緷娆＄偤鎷櫉(h脿o)銆佸啰銆佷箻闄�銆佸姞娓涳紝鍚岀礆(j铆)閬�(y霉n)绠楁檪(sh铆)鐨勯爢搴�?y脿n)闁烘窎绗欒洿涔欐潵鏂�?j矛)绠�銆�

銆€銆€闂�(gu膩n)绯婚亱(y霉n)绠楃锛�>(澶т簬)銆�> =(澶т簬绛変簬)銆�<(灏忎簬)銆�< =(灏忎簬绛変簬)銆�=(绛変簬)銆�< >(涓嶇瓑浜�)銆傞棞(gu膩n)绯婚亱(y霉n)绠楃涔嬮枔娌掓湁鍎�(y艒u)鍏堢礆(j铆)鍒�銆�

銆€銆€鐣�(d膩ng)鍑虹従(xi脿n)绠楄(sh霉)鍜岄棞(gu膩n)绯荤殑娣峰拰閬�(y霉n)绠楁檪(sh铆)锛岀畻琛�(sh霉)閬�(y霉n)绠楀劒(y艒u)鍏堜簬闂�(gu膩n)绯婚亱(y霉n)绠�銆�

銆€銆€鈶靛叕寮忚几鍏�銆傚湪鍠厓鏍间腑鎴栧湪绶ㄨ集娆勪腑杓稿叆鍏紡鍚庯紝鍏紡椤ず鍦ㄧ法杓瑒鍏�(n猫i)锛岄亱(y霉n)绠楃祼(ji茅)鏋滈’绀哄湪宸ヤ綔琛ㄧ殑鐣�(d膩ng)鍓嶆椿鍕�(d貌ng)鍠厓涓�锛屼絾鍠厓鏍间腑閭勫寘鍚叕寮�銆傝嫢鎯冲湪鍠厓鏍间腑椤ず鍏紡鏈韩锛屽彲浠モ€滃伐鍏穦閬搁爡(xi脿ng)|瑕栧湒|鍏紡鈥�銆�

銆€銆€鈶跺叕寮忎慨鏀�銆備慨鏀瑰叕寮忓彲鍦ㄧ法杓瑒涓€�(j矛n)琛�銆�

銆€銆€銆愪緥椤�4-58銆戝湪Excel鍠厓鏍间腑杓稿叆鍏紡鏅�(sh铆)瑕侀嵉鍏ュ墠灏�(d菐o)绗�( )銆�

銆€銆€A.鈥� B.+ C.= D.:

銆€銆€姝ｇ⒑绛旀: C

銆€銆€瑙ｆ瀽: 鍦‥xcel鍠厓鏍间腑杓稿叆鍏紡鏅�(sh铆)瑕侀嵉鍏ュ墠灏�(d菐o)绗�=銆�

銆€銆€銆愪緥椤�4-59銆戠暥(d膩ng)F1鍠厓鏍间腑鐨勫叕寮忕偤=A3+B4锛岀暥(d膩ng)B鍒楄鍒櫎鏅�(sh铆)锛孎(xi脿n)1鍠厓鐨勫叕寮忓皣瑾�(di脿o)鏁寸偤( )銆�

銆€銆€A.= A3+C4 B. =A3+B4 C.#REF! D.=A3+A4

銆€銆€姝ｇ⒑绛旀锛欳

銆€銆€瑙ｆ瀽: 鏌愬柈鍏冩牸涓殑鍏紡鐐�=A3+B4锛岀暥(d膩ng)B鍒楄鍒櫎鏅�(sh铆)锛屽柈鍏冩牸鐨勫叕寮忓皣瑾�(di脿o)鏁寸偤#REF!

銆€銆€4.鍑芥暩(sh霉)銆侲xcel鎻愪緵浜�11椤炲嚱鏁�(sh霉)锛屾瘡涓€椤炴湁鑻ュ共鍊�(g猫)涓嶅悓鐨勫嚱鏁�(sh霉)銆傚嚱鏁�(sh霉)鍙互鍠崹(d煤)浣跨敤锛屼篃鍙互鍑虹従(xi脿n)鍦ㄥ叕寮忎腑锛屽悎鐞嗗湴浣跨敤鍑芥暩(sh霉)灏囧ぇ澶ф彁楂樿〃鏍艰▓(j矛)绠楃殑鏁堢巼銆�

銆€?銆佽棔鐦�?sh霉)鐨勫舰寮�銆傚嚱鏁�(sh霉)鍚�(鍙冩暩(sh霉))銆傚嚱鏁�(sh霉)鍚嶈〃绀烘煇闋�(xi脿ng)鎿嶄綔;鍙冩暩(sh霉)鍓囩郸鍑鸿▓(j矛)绠楄寖鍦�銆傚嚱鏁�(sh霉)鍚�([鍙冩暩(sh霉)1]锛孾鍙冩暩(sh霉)2]鈥︹€�)銆傚嚱鏁�(sh霉)鍚嶅悗绶婅窡鎷櫉(h脿o)锛屾嫭铏�(h脿o)鍏�(n猫i)鍙互鏈変竴鍊�(g猫)鎴栧鍊�(g猫)鍙冩暩(sh霉)锛屽悇鍊�(g猫)鍙冩暩(sh霉)闁撶敤閫楄櫉(h脿o)鍒嗛殧锛屼篃鍙互娌掓湁鍙冩暩(sh霉)銆備緥濡係UM (A2:A3,C4:D5)锛岃〃绀烘眰2鍊�(g猫)鍗€(q奴)鍩熶腑鍏�6鍊�(g猫)鏁�(sh霉)鎿�(j霉)鐨勫拰銆�

銆€?銆佺灔锛崇叅鐦�?sh霉)銆�

銆€?銆佸伨锠涚鐦�?sh霉) SUM銆傛牸寮忥細SUM(number1,number2,鈥�)銆傚叾涓璶umber1,number2绛夊弮鏁�(sh霉)鍙互鏄暩(sh霉)鍊�銆佸柈鍏冨湴鍧€鎴栧崁(q奴)鍩熴€係UM鍑芥暩(sh霉)鏈€澶氬彲浠ユ湁30鍊�(g猫)鍙冩暩(sh霉)銆�

銆€銆€渚嬪锛孲UM(3锛�2)鏄眰鏁�(sh霉)鍊�3鍜�2鐨勫拰銆�

銆€銆€SUM(A3锛孊2)鏄眰A3鍜孊2鍠厓涓暩(sh霉)鍊肩殑鍜�銆�

銆€銆€SUM(A1,A6)鏄眰A1鍒癆6鍠厓涓暩(sh霉)鍊间箣鍜�锛屼篃灏辨槸灏�(du矛)6鍊�(g猫)鍠厓姹傚拰銆�

銆€銆€鈶℃眰骞冲潎鍑芥暩(sh霉)AVERAGE銆傛眰绲﹀畾鍙冩暩(sh霉)鐨勫钩鍧囧€笺€傛牸寮忥細AVERAGE(number1,number2,鈥�)銆傚叾涓璶umber1,number2绛夊弮鏁�(sh霉)鍙互鏄暩(sh霉)鍊�銆佸柈鍏冨湴鍧€鎴栧崁(q奴)鍩�銆�

銆€銆€鈶㈡眰鏈€澶у€煎嚱鏁�(sh霉)MAX銆傛眰绲﹀畾鍙冩暩(sh霉)鐨勬渶澶у€硷紝鏍煎紡锛歁AX(number1,number2,鈥�)銆�

銆€?銆佽姰绗為挌鈮堝矝鐦�?sh霉)MIN銆傛眰绲﹀畾鍙冩暩(sh霉)鐨勬渶灏忓€�锛屾牸寮忥細MIN(number1,number2,鈥�)銆�

銆€?銆佽蓟l浠跺嚱鏁�(sh霉)銆傛牸寮忥細IF(logical_test,value_if_true,value_if_false)銆�

銆€?銆佸憶鐦�?sh霉)鐨勮几鍏�?锛熸ⅱ閰濄劅^鍠搳鈥滃父鐢ㄢ€濆伐鍏锋瑒鐨勨€滅矘璨煎嚱鏁�(sh霉)鈥濇寜閳曚締瀵�(sh铆)鐝�(xi脿n);鍙互閫氶亷鈥滄彃鍏� / 鍑芥暩(sh霉)鈥濊彍鍠懡浠や締瀵�(sh铆)鐝�(xi脿n);涔熷彲浠ョ洿鎺ュ湪鍠厓鏍间腑杓稿叆銆傛敞鎰忚几鍏ユ檪(sh铆)蹇呴爤浠モ€�=鈥濋枊闋�銆�

銆€銆€鐠�(hu谩n)鐞冪恫(w菐ng)鏍℃渻(hu矛)瑷�(j矛)瀵�(sh铆)鍕�(w霉)鎿嶄綔鐝叚鎶樺劒(y艒u)鎯�