銆€銆€51.鍦ㄥ柈鍏冩牸涓几鍏�0鍊�

銆€銆€涓€鑸儏娉佷笅锛屽湪Excel琛ㄦ牸涓几鍏ヨ濡�"05"銆�"4.00"涔嬮鏁�(sh霉)瀛楀悗锛屽彧瑕佸厜妯�(bi膩o)涓€绉诲嚭瑭插柈鍏冩牸锛屾牸涓暩(sh霉)瀛楀氨鏈�(hu矛)鑷嫊(d貌ng)璁婃垚"5"銆�"4"锛孍xcel榛樿獚(r猫n)鐨勯€欑ó鍋氭硶璁撲汉浣跨敤闈炲父涓嶄究锛屾垜鍊戝彲浠ラ€氶亷涓嬮潰鐨勬柟娉曚締閬垮厤鍑虹従(xi脿n)閫欑ó鎯呮硜:鍏堥伕瀹氳杓稿叆璜稿"05"銆�"4.00"涔嬮鏁�(sh霉)瀛楃殑鍠厓鏍�锛岄紶妯�(bi膩o)鍙抽嵉鍠搳锛屽湪褰堝嚭鐨勫揩鎹疯彍鍠腑鍠搳"瑷�(sh猫)缃柈鍏冩牸鏍煎紡"锛屽湪鎺ヨ憲鍑虹従(xi脿n)鐨勭晫闈腑閬�"鏁�(sh霉)瀛�"妯�(bi膩o)绨介爜(y猫)锛屽湪鍒楄〃妗嗕腑閬告搰"鏂囨湰"锛屽柈鎿�"纰哄畾"銆傞€欐ǎ锛屽湪閫欎簺鍠厓鏍间腑锛屾垜鍊戝氨鍙互杓稿叆璜稿"05"銆�"4.00"涔嬮鐨勬暩(sh霉)瀛椾簡銆�

銆€銆€52.灏囨暩(sh霉)瀛楄ō(sh猫)鐐烘枃鏈牸寮�

銆€銆€涓嶈珫鏄惁灏�(du矛)鍚湁鏁�(sh霉)瀛楃殑鍠厓鏍兼噳(y墨ng)鐢ㄤ簡鏂囨湰鏍煎紡锛孍xcel閮芥渻(hu矛)灏囨暩(sh霉)瀛椾繚瀛樼偤鏁�(sh霉)瀛�?j菒n)?sh霉)鎿�(j霉)銆傝嫢瑕佷娇Excel灏囬浼奸浂浠惰櫉(h脿o)纰肩殑鏁�(sh霉)瀛楄В閲嬬偤鏂囨湰锛岄鍏堟噳(y墨ng)灏囩┖鐧藉柈鍏冩牸瑷�(sh猫)缃垚鏂囨湰鏍煎紡锛岀劧鍚庨嵉鍏ユ暩(sh霉)瀛椼€傚鏋滃凡缍�(j墨ng)杓稿叆浜嗘暩(sh霉)瀛�锛岄偅涔堜篃鍙互灏囧畠鏇存敼鎴愭枃鏈舰寮忋€傛柟娉曟槸: 1.閬告搰鍚湁瑕佽ō(sh猫)缃垚鏂囨湰鏍煎紡鐨勬暩(sh霉)瀛楀柈鍏冩牸; 2.鍠搳"鏍煎紡鈫掑柈鍏冩牸"鍛戒护锛岀劧鍚庡柈鎿�"鏁�(sh霉)瀛�"閬搁爡(xi脿ng)鍗�(); 3.鍦�"鍒嗛"鍒楄〃涓紝鍠搳"鏂囨湰"锛岀劧鍚庡啀鍠搳"纰哄畾"; 4.鍠搳姣忓€�(g猫)鍠厓鏍�锛屾寜F2閸�锛岀劧鍚庡啀鎸塃nter閸甸噸鏂拌几鍏ユ暩(sh霉)鎿�(j霉)銆�

銆€銆€53.蹇€熼€�(j矛n)琛屽柈鍏冩牸涔嬮枔鐨勫垏鎻�(寰粺Office鎶€宸уぇ璩界嵅鐛�(ji菐ng)浣滃搧)

銆€銆€鍦‥xcel涓�,鍙互鐢ㄤ互涓嬫柟娉曞(sh铆)鐝�(xi脿n)鍦ㄤ竴鍊�(g猫)鍗€(q奴)鍩熷収(n猫i)鐨勫揩閫熻几鍏ヨ€屼笉鐢ㄩ紶妯�(bi膩o)渚嗛€�(j矛n)琛屽柈鍏冩牸涔嬮枔鐨勫垏鎻涖€傛柟娉曞涓�:鐢ㄩ紶妯�(bi膩o)鍦堝畾涓€瀹氬崁(q奴)鍩熷悗锛屾寜Tab閸靛彲浣跨洰妯�(bi膩o)鍠厓鏍煎悜鍚庣Щ锛屾寜"Shift+Tab"鍙悜鍓嶇Щ銆傞€欐ǎ灏卞彲浠ュ湪閸电洡涓婇€ｇ簩(x霉)杓稿叆涓€绲勬暩(sh霉)鎿�(j霉)鑰屼笉闇€鐢ㄩ紶妯�(bi膩o)锛屽緸鑰屾彁楂樿几鍏ラ€熷害銆� 鎻愮ず:浜嬪(sh铆)涓�锛岄噰鐢ㄦ鏂规硶鏈€澶х殑濂借檿鏄�锛屽湪涓€琛岀殑鏈€鍚庝竴鍊�(g猫)鍠厓鏍�锛岀辜绾�(x霉)鎸塗ab锛屽墖鍙互杞�(zhu菐n)鍒颁笅涓€琛岄枊濮嬬殑鍠厓鏍�;鍦ㄩ伕瀹氬崁(q奴)鍩熸渶鍚庝竴琛岀殑鏈€鍚庝竴鍊�(g猫)鍠厓鏍肩辜绾�(x霉)鎸塗ab鍓囨渻(hu矛)鍥炲埌閬稿畾鍗€(q奴)鍩熺涓€琛岀涓€鍊�(g猫)鍠厓鏍�銆傚悓妯ｇ敤Enter鍙互鎸夊垪杓稿叆鏁�(sh霉)鎿�(j霉)銆�

銆€銆€54.鍦ㄥ悓涓€鍠厓鏍煎収(n猫i)閫ｇ簩(x霉)杓稿叆澶氬€�(g猫)娓�(c猫)瑭﹀€�

銆€銆€涓€鑸儏娉佷笅锛岀暥(d膩ng)鎴戝€�?c猫)瓒╁崸顎楅?n猫i)杓稿叆鍏�(n猫i)瀹瑰悗鎸夊洖杌婇嵉锛岄紶妯�(bi膩o)灏辨渻(hu矛)鑷嫊(d貌ng)绉诲埌涓嬩竴鍠厓鏍�锛屽鏋滄垜鍊戦渶瑕佸湪鏌愬€�(g猫)鍠厓鏍煎収(n猫i)閫ｇ簩(x霉)杓稿叆澶氬€�(g猫)娓�(c猫)瑭﹀€间互鏌ョ湅寮曠敤姝ゅ柈鍏冩牸鐨勫叾浠栧柈鍏冩牸鐨勫嫊(d貌ng)鎱�(t脿i)鏁堟灉鏅�(sh铆)锛屽氨闇€瑕侀€�(j矛n)琛屼互涓嬫搷浣�:鍠搳"宸ュ叿鈫掗伕闋�(xi脿ng)鈫掔法杓�"锛屽彇娑堥伕涓�"鎸塃nter閸靛悗绉诲嫊(d貌ng)"閬搁爡(xi脿ng)()锛屽緸鑰屽(sh铆)鐝�(xi脿n)鍦ㄥ悓涓€鍠厓鏍煎収(n猫i)杓镐汉澶氬€�(g猫)娓�(c猫)瑭﹀€�銆�

銆€銆€55. 杓稿叆鏁�(sh霉)瀛�銆佹枃瀛椼€佹棩鏈熸垨鏅�(sh铆)闁�

銆€銆€鍠搳闇€瑕佽几鍏ユ暩(sh霉)鎿�(j霉)鐨勫柈鍏冩牸锛岄嵉鍏ユ暩(sh霉)鎿�(j霉)骞舵寜Enter鎴朤ab閸靛嵆鍙�銆傚鏋滄槸鏅�(sh铆)闁�锛岀敤鏂滄潬鎴栨笡铏�(h脿o)鍒嗛殧鏃ユ湡鐨勫勾銆佹湀銆佹棩閮ㄥ垎锛屼緥濡�锛屽彲浠ラ嵉鍏� 9/5/96 鎴� Jun-96銆傚鏋滄寜12灏忔檪(sh铆)鍒惰几鍏ユ檪(sh铆)闁擄紝璜�(q菒ng)?ji膩n)璺乺(sh铆)闁撴暩(sh霉)瀛楀悗绌轰竴鏍�锛屽苟閸靛叆瀛楁瘝 a(涓婂崍) 鎴� p(涓嬪崍)锛屼緥濡�锛�9:00 p銆傚惁鍓�锛屽鏋滃彧杓稿叆鏅�(sh铆)闁撴暩(sh霉)瀛�锛孍xcel灏囨寜 AM(涓婂崍)铏曠悊銆�

銆€銆€56.蹇€熻几鍏ユ瓙鍏冪铏�(h脿o)

銆€銆€鍏堟寜涓婣lt閸�锛岀劧鍚庡埄鐢ㄥ彸闈㈢殑鏁�(sh霉)瀛楅嵉鐩�(淇楃ū灏忛嵉鐩�)閸靛叆0128閫�4鍊�(g猫)鏁�(sh霉)瀛楋紝鏉鹃枊Alt閸�锛屽氨鍙互杓稿叆姝愬厓绗﹁櫉(h脿o)銆�

銆€銆€57.灏囧柈鍏冩牸鍗€(q奴)鍩熷緸鍏紡杞�(zhu菐n)鎻涙垚鏁�(sh霉)鍊�

銆€銆€鏈夋檪(sh铆)锛屼綘鍙兘闇€瑕佸皣鏌愬€�(g猫)鍠厓鏍煎崁(q奴)鍩熶腑鐨勫叕寮忚綁(zhu菐n)鎻涙垚鏁�(sh霉)鍊�锛屽父瑕�(gu墨)鏂规硶鏄娇鐢�"閬告搰鎬х矘璨�"涓殑"鏁�(sh霉)鍊�"閬搁爡(xi脿ng)渚嗚綁(zhu菐n)鎻涙暩(sh霉)鎿�(j霉)銆傚叾瀵�(sh铆)锛屾湁鏇寸啊(ji菐n)渚跨殑鏂规硶:棣栧厛閬稿彇鍖呭惈鍏紡鐨勫柈鍏冩牸鍗€(q奴)鍩�锛屾寜浣忛紶妯�(bi膩o)鍙抽嵉灏囨鍗€(q奴)鍩熸部浠讳綍鏂瑰悜鎷栧嫊(d貌ng)涓€灏忔璺濋洟(涓嶆澗闁嬮紶妯�(bi膩o))锛岀劧鍚庡啀鎶婂畠鎷栧洖鍘伙紝鍦ㄥ師渚嗗柈鍏冩牸鍗€(q奴)鍩熺殑浣嶇疆鏉鹃枊榧犳(bi膩o) (姝ゆ檪(sh铆)锛屽柈鍏冩牸鍗€(q奴)鍩熼倞妗嗚畩鑺变簡)锛屽緸鍑虹従(xi脿n)鐨勫揩鎹疯彍鍠腑閬告搰"鍍呭京(f霉)鍒舵暩(sh霉)鍊�"銆�

銆€銆€58.蹇€熻几鍏ユ湁搴忔枃鏈�

銆€銆€濡傛灉浣犵稉(j墨ng)甯搁渶瑕佽几鍏ヤ竴浜涙湁瑕�(gu墨)寰嬬殑搴忓垪鏂囨湰锛屽鏁�(sh霉)瀛�(1銆�2鈥︹€�)銆佹棩鏈�(1鏃ャ€�2鏃モ€︹€�)绛�锛屽彲浠ュ埄鐢ㄤ笅闈㈢殑鏂规硶渚嗗(sh铆)鐝�(xi脿n)鍏跺揩閫熻几鍏�:鍏堝湪闇€瑕佽几鍏ュ簭鍒楁枃鏈殑绗�1銆佺2鍏╁€�(g猫)鍠厓鏍间腑杓稿叆瑭叉枃鏈殑鍓嶅叐鍊�(g猫)鍏冪礌(濡�"鐢�銆佷箼")銆傚悓鏅�(sh铆)閬镐腑涓婅堪鍏╁€�(g猫)鍠厓鏍�锛屽皣榧犳(bi膩o)绉昏嚦绗�2鍊�(g猫)鍠厓鏍肩殑鍙充笅瑙掓垚绱�(x矛)鍗佸瓧绶氱媭鏅�(sh铆)(鎴戝€戦€氬父绋卞叾鐐�"濉厖鏌�")锛屾寜浣忛紶妯�(bi膩o)宸﹂嵉鍚戝悗(鎴栧悜涓�)鎷栨媺鑷抽渶瑕佸～鍏ヨ┎搴忓垪鐨勬渶鍚庝竴鍊�(g猫)鍠厓鏍煎悗锛屾澗闁嬪乏閸�锛屽墖瑭插簭鍒楃殑鍚庣簩(x霉)鍏冪礌(濡�"涓欍€佷竵銆佹垔鈥︹€�")渚濆簭鑷嫊(d貌ng)濉叆鐩告噳(y墨ng)鐨勫柈鍏冩牸涓€�

銆€銆€59.杓稿叆鏈夎(gu墨)寰嬫暩(sh霉)瀛�

銆€銆€鏈夋檪(sh铆)闇€瑕佽几鍏ヤ竴浜涗笉鏄垚鑷劧閬炲鐨勬暩(sh霉)鍊�(濡傜瓑姣斿簭鍒�:2銆�4銆�8鈥︹€�)锛屾垜鍊戝彲浠ョ敤鍙抽嵉鎷栨媺鐨勬柟娉曚締瀹屾垚:鍏堝湪绗�1銆佺2鍏╁€�(g猫)鍠厓鏍间腑杓稿叆瑭插簭鍒楃殑鍓嶅叐鍊�(g猫)鏁�(sh霉)鍊�(2銆�4)銆傚悓鏅�(sh铆)閬镐腑涓婅堪鍏╁€�(g猫)鍠厓鏍�锛屽皣榧犳(bi膩o)绉昏嚦绗�2鍊�(g猫)鍠厓鏍肩殑鍙充笅瑙掓垚绱�(x矛)鍗佸瓧绶氱媭鏅�(sh铆)锛屾寜浣忓彸閸靛悜鍚�(鎴栧悜涓�)鎷栨媺鑷宠┎搴忓垪鐨勬渶鍚庝竴鍊�(g猫)鍠厓鏍�锛屾澗闁嬪彸閸碉紝姝ゆ檪(sh铆)鏈�(hu矛)褰堝嚭涓€鍊�(g猫)鑿滃柈()锛岄伕"绛夋瘮搴忓垪"閬搁爡(xi脿ng)锛屽墖瑭插簭鍒�(2銆�4銆�8銆�16鈥︹€�)鍙婂叾"鍠厓鏍兼牸寮�"鍒嗗垾杓稿叆鐩告噳(y墨ng)鐨勫柈鍏冩牸涓�(濡傛灉閬�"绛夊樊搴忓垪"锛屽墖杓稿叆2銆�4銆�6銆�8鈥︹€�)銆�

銆€銆€60.宸у杓稿叆甯哥敤鏁�(sh霉)鎿�(j霉)

銆€銆€鏈夋檪(sh铆)鎴戝€戦渶瑕佽几鍏ヤ竴浜涙暩(sh霉)鎿�(j霉)锛屽鍠綅鑱峰伐鍚嶅柈锛屾湁鐨勮伔宸ュ鍚嶄腑鐢熷兓鐨勫瓧杓稿叆妤电偤鍥伴洠锛屽鏋滄垜鍊戜竴娆℃€у畾缇╁ソ"鑱峰伐濮撳悕搴忓垪"锛屼互鍚庤几鍏ュ氨蹇浜嗐€傚叿楂旀柟娉曞涓�:灏囪伔宸ュ鍚嶈几鍏ラ€ｇ簩(x霉)鐨勫柈鍏冩牸涓�锛屽苟閬镐腑瀹冨€戯紝鍠搳"宸ュ叿鈫掗伕闋�(xi脿ng)"鍛戒护鎵撻枊"閬搁爡(xi脿ng)"灏�(du矛)瑭辨锛岄伕"鑷畾缇╁簭鍒�"妯�(bi膩o)绨�()锛屽厛鍚庢寜"灏�(d菐o)鍏�"銆�"纰哄畾"鎸夐垥銆備互鍚庡湪浠讳竴鍠厓鏍间腑杓稿叆鏌愪竴鑱峰伐濮撳悕(涓嶄竴瀹氶潪寰楁槸绗竴浣嶈伔宸ョ殑濮撳悕)锛岀敤"濉厖鏌�"鍗冲彲灏囪┎鑱峰伐鍚庨潰鐨勮伔宸ュ鍚嶅揩閫熷～鍏ュ悗绾�(x霉)鐨勫柈鍏冩牸涓�銆�