21.
鎵撳紑
"
鑰冪敓鏂囦欢澶圭殑
Excel
鏂囦欢澶逛腑鐨?/p>
excel5.xls"
杩涜浠ヤ笅鎿嶄綔骞朵繚瀛樸�?/p>
锛?/p>
1
锛夊皢
Sheet1
宸ヤ綔琛ㄧ殑
A1:D1
鍗曞厓鏍煎悎骞朵负涓�涓崟鍏冩牸锛屽唴瀹规按骞冲眳涓紱
锛?/p>
2
锛夎绠楅攢鍞鐨勬�昏鍜屸�滄墍鍗犳瘮渚嬧�濆垪鐨勫唴瀹?/p>
(
鐧惧垎姣斿瀷锛屼繚鐣欏皬鏁扮偣鍚庝袱浣?/p>
)
锛?/p>
锛?/p>
3
锛夋寜閿�鍞鐨勯�掑噺娆″簭璁＄畻鈥滈攢鍞鎺掑悕鈥濆垪鐨勫唴瀹?/p>
(
鍒╃敤
RANK
鍑芥暟
)
锛?/p>
锛?/p>
4
锛夊皢
A2:D13
鍖哄煙鏍煎紡璁剧疆涓哄鐢ㄨ〃鏍兼牸寮忊�滄祬鑹叉牱寮?/p>
9
鈥?/p>
銆?/p>
锛?/p>
5
锛夐�夊彇鈥滃垎鍏徃浠ｅ彿鈥濆拰鈥滄墍鍗犳瘮渚嬧�濆垪鏁版嵁鍖哄煙锛屽缓绔嬧�滃垎绂诲瀷涓夌淮楗煎浘鈥?/p>
(
绯诲垪浜х敓
鍦ㄢ�滃垪鈥?/p>
)
锛屾暟鎹郴鍒楁牸寮忔暟鎹爣蹇椾负鏄剧ず鐧惧垎姣旓紝灏嗘爣棰樿缃负鈥滈攢鍞粺璁″浘鈥?/p>
锛屽浘渚嬩綅缃?/p>
闈犲乏锛涘皢鍥炬彃鍏ュ埌琛ㄧ殑
A15:D26
鍗曞厓鏍煎尯鍩熷唴锛屽皢宸ヤ綔琛ㄩ噸鍛藉悕涓衡�滈攢鍞粺璁¤〃鈥?/p>
锛屼繚瀛樸�?/p>
22.
鎵撳紑
"
鑰冪敓鏂囦欢澶圭殑
Excel
鏂囦欢澶逛腑鐨?/p>
excel6.xls"
杩涜浠ヤ笅鎿嶄綔骞朵繚瀛樸�?/p>
(1)
灏?/p>
Sheet1
宸ヤ綔琛ㄧ殑
A1:E1
鍗曞厓鏍煎悎骞朵负涓�涓崟鍏冩牸锛屽唴瀹规按骞冲眳涓紱璁＄畻鈥滈攢鍞鈥濆垪鍐?/p>
瀹癸紝鎸夐攢鍞鐨勯�掑噺椤哄簭璁＄畻鍑?/p>
鈥滈攢鍞鎺掑悕鈥濆垪鐨勫唴瀹?/p>
(
鍒╃敤
RANK
鍑芥暟
)
锛?/p>
鍒╃敤鏉′欢鏍煎紡灏?/p>
D3:D7
鍗曞厓鏍煎尯鍩熷唴鏁板�煎皬浜?/p>
40000
鐨勫瓧浣撻鑹茶缃负绾㈣壊锛屽皢
A2:E7
鍖哄煙鏍煎紡璁剧疆涓哄鐢?/p>
琛ㄦ牸鏍煎紡鈥滀腑绛夋繁娴?/p>
6
鈥?/p>
銆?/p>
(2)
閫夊彇鈥滃浘涔﹀悕绉扳�濆垪鍜屸�滈攢鍞鈥濆垪鍐呭寤虹珛鈥滄煴褰㈠渾閿ュ浘鈥?/p>
(
绯诲垪浜х敓鍦ㄢ�滃垪鈥?/p>
)
锛屽浘鏍?/p>
棰樿缃负鈥滈攢鍞粺璁″浘鈥?/p>
锛屽浘渚嬬疆搴曢儴锛涘皢鍥炬彃鍏ュ埌琛ㄧ殑
A9:E21
鍗曞厓鏍煎尯鍩熷唴锛屽皢宸ヤ綔琛ㄩ噸
鍛藉悕涓衡�滈攢鍞粺璁¤〃鈥?/p>
锛屼繚瀛樸�?/p>
23.
鎵撳紑
"
鑰冪敓鏂囦欢澶圭殑
Excel
鏂囦欢澶逛腑鐨?/p>
excel7.xls"
杩涜浠ヤ笅鎿嶄綔骞朵繚瀛樸�?/p>
锛?/p>
1
锛夊皢宸ヤ綔琛?/p>
sheet1
鏇村悕涓衡�滄暀甯堜俊鎭〃鈥?/p>
銆?/p>
锛?/p>
2
锛夊湪鏁版嵁娓呭崟鍚庤拷鍔犱竴鏉¤褰曪細闄舵垚鐑?/p>
鐞嗗闄?/p>
1965
-
8
-
16
纭曞＋
鍓暀鎺堛�?/p>
锛?/p>
3
锛夊湪鏁版嵁娓呭崟涓紝绛涢�夊嚭
1960
骞?/p>
1
鏈?/p>
1
鏃ヤ互鍚庡嚭鐢熺殑锛岃亴绉颁负鈥滄暀鎺堚�?/p>
锛屽鍘嗘槸鈥滃崥澹�?/p>
鐨勬暀甯堝悕鍗曘�傝姹傚皢绛涢�夋潯浠跺缓绔嬪湪鏁版嵁娓呭崟涓嬫柟锛岀瓫閫夌粨鏋滄樉绀哄湪鍖哄煙
A17:E20
涓�?/p>
锛?/p>
4
锛夊皢鏁版嵁娓呭崟澶嶅埗鍒?/p>
Sheet2
涓�?/p>
锛?/p>
5
锛夌敤鈥滃垎绫绘眹鎬烩�濇柟娉曠粺璁″悇绫诲鍘嗙殑浜烘暟銆?/p>
24.
锛?/p>
1
锛?/p>
鏂板缓涓�涓?/p>
Excel
鏂板伐浣滆杽锛?/p>
淇濆瓨鍦ㄦ闈紝
鏂囦欢鍚嶄负
鈥滄垚缁?/p>
.xls
鈥?/p>
銆?/p>
鍒涘缓濡傚浘鎵�绀鸿〃鏍笺�?/p>
