엑셀교육 2편

<IMG class=c alt="이미지를 클릭하면 원본을 보실 수 있습니다." src="https://t1.daumcdn.net/cafefile/pds94/7_cafe_2008_09_16_18_15_48cf794d078bb" border=0>   엑셀2003교육사항   <TABLE style="WIDTH: 531pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=708 border=0 x:str> <TBODY> <TR style="HEIGHT: 31.5pt; mso-height-source: userset" height=42> <TD class=xl28 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 393pt; BORDER-BOTTOM: #ece9d8; HEIGHT: 31.5pt; BACKGROUND-COLOR: transparent" width=524 colSpan=5 height=42>ITQ 성적표[이름과 주민번호로 나누어 넣기]</TD> <TD class=xl29 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 60pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" width=80></TD> <TD class=xl29 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 45pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" width=60></TD> <TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 33pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" width=44></TD></TR> <TR style="HEIGHT: 14.25pt" height=19> <TD class=xl30 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 60pt; BORDER-BOTTOM: #ece9d8; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent" width=80 height=19></TD> <TD class=xl30 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 131pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" width=175></TD> <TD class=xl30 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 60pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" width=80></TD> <TD class=xl30 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 61pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" width=81></TD> <TD class=xl30 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 81pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" width=108></TD> <TD class=xl29 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD> <TD class=xl29 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD> <TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD></TR> <TR style="HEIGHT: 31.5pt; mso-height-source: userset" height=42> <TD class=xl31 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: black 1pt solid; BORDER-LEFT: black 1pt solid; WIDTH: 60pt; BORDER-BOTTOM: black 1pt solid; HEIGHT: 31.5pt; BACKGROUND-COLOR: #99cc00" width=80 height=42> 이름</TD> <TD class=xl32 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: black 1pt solid; BORDER-LEFT: #ece9d8; WIDTH: 131pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: #99cc00" width=175> 주민등록번호</TD> <TD class=xl32 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: black 1pt solid; BORDER-LEFT: #ece9d8; WIDTH: 60pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: #99cc00" width=80> 점수</TD> <TD class=xl32 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: black 1pt solid; BORDER-LEFT: #ece9d8; WIDTH: 61pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: #99cc00" width=81> 순위</TD> <TD class=xl33 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: black 1pt solid; BORDER-LEFT: #ece9d8; WIDTH: 81pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: #99cc00" width=108> 출생년도</TD> <TD class=xl34 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: windowtext 1pt solid; BORDER-LEFT: windowtext 1pt solid; WIDTH: 60pt; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: #99cc00" width=80> 성</TD> <TD class=xl52 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: windowtext 1pt solid; BORDER-LEFT: #ece9d8; WIDTH: 45pt; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: #99cc00" width=60> 이름</TD> <TD class=xl57 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 33pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #99cc00" width=44> 성별</TD></TR> <TR style="HEIGHT: 31.5pt; mso-height-source: userset" height=42> <TD class=xl35 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: black 1pt solid; WIDTH: 60pt; BORDER-BOTTOM: black 1pt solid; HEIGHT: 31.5pt; BACKGROUND-COLOR: #ffff99" width=80 height=42> 김기수</TD> <TD class=xl36 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 131pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: transparent" width=175> 970501-1046821</TD> <TD class=xl37 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 60pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: #99ccff" width=80 x:num> 95</TD> <TD class=xl36 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 61pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: transparent" width=81 x:num x:fmla="=RANK(C4,$C$4:$C$8)"> 1</TD> <TD class=xl38 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 81pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: transparent" width=108 x:str="97" x:fmla="=LEFT(B4,2)"> 97년도</TD> <TD class=xl51 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:fmla="=LEFT(A4,1)"> 김</TD> <TD class=xl53 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:fmla="=MID(A4,2,2)"> 기수</TD> <TD class=xl58 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:fmla="=MID(B4,8,1)"> 1</TD></TR> <TR style="HEIGHT: 31.5pt; mso-height-source: userset" height=42> <TD class=xl35 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: black 1pt solid; WIDTH: 60pt; BORDER-BOTTOM: black 1pt solid; HEIGHT: 31.5pt; BACKGROUND-COLOR: #ffff99" width=80 height=42> 이미선</TD> <TD class=xl36 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 131pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: transparent" width=175> 981105-2014561</TD> <TD class=xl37 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 60pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: #99ccff" width=80 x:num> 85</TD> <TD class=xl36 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 61pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: transparent" width=81 x:num x:fmla="=RANK(C5,$C$4:$C$8)"> 3</TD> <TD class=xl38 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 81pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: transparent" width=108 x:str="98" x:fmla="=LEFT(B5,2)"> 98년도</TD> <TD class=xl51 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:fmla="=LEFT(A5,1)"> 이</TD> <TD class=xl54 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:fmla="=MID(A5,2,2)"> 미선</TD> <TD class=xl58 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:fmla="=MID(B5,8,1)"> 2</TD></TR> <TR style="HEIGHT: 31.5pt; mso-height-source: userset" height=42> <TD class=xl35 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: black 1pt solid; WIDTH: 60pt; BORDER-BOTTOM: black 1pt solid; HEIGHT: 31.5pt; BACKGROUND-COLOR: #ffff99" width=80 height=42> 장현주</TD> <TD class=xl36 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 131pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: transparent" width=175> 990615-2014657</TD> <TD class=xl37 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 60pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: #99ccff" width=80 x:num> 70</TD> <TD class=xl36 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 61pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: transparent" width=81 x:num x:fmla="=RANK(C6,$C$4:$C$8)"> 5</TD> <TD class=xl38 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 81pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: transparent" width=108 x:str="99" x:fmla="=LEFT(B6,2)"> 99년도</TD> <TD class=xl51 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:fmla="=LEFT(A6,1)"> 장</TD> <TD class=xl54 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:fmla="=MID(A6,2,2)"> 현주</TD> <TD class=xl58 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:fmla="=MID(B6,8,1)"> 2</TD></TR> <TR style="HEIGHT: 31.5pt; mso-height-source: userset" height=42> <TD class=xl35 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: black 1pt solid; WIDTH: 60pt; BORDER-BOTTOM: black 1pt solid; HEIGHT: 31.5pt; BACKGROUND-COLOR: #ffff99" width=80 height=42> 박경민</TD> <TD class=xl36 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 131pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: transparent" width=175> 970530-1542451</TD> <TD class=xl37 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 60pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: #99ccff" width=80 x:num> 90</TD> <TD class=xl36 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 61pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: transparent" width=81 x:num x:fmla="=RANK(C7,$C$4:$C$8)"> 2</TD> <TD class=xl38 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 81pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: transparent" width=108 x:str="97" x:fmla="=LEFT(B7,2)"> 97년도</TD> <TD class=xl51 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:fmla="=LEFT(A7,1)"> 박</TD> <TD class=xl54 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:fmla="=MID(A7,2,2)"> 경민</TD> <TD class=xl58 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:fmla="=MID(B7,8,1)"> 1</TD></TR> <TR style="HEIGHT: 31.5pt; mso-height-source: userset" height=42> <TD class=xl35 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: black 1pt solid; WIDTH: 60pt; BORDER-BOTTOM: black 1pt solid; HEIGHT: 31.5pt; BACKGROUND-COLOR: #ffff99" width=80 height=42> 최아름</TD> <TD class=xl36 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 131pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: transparent" width=175> 980315-2145782</TD> <TD class=xl37 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 60pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: #99ccff" width=80 x:num> 75</TD> <TD class=xl39 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 61pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" width=81 x:num x:fmla="=RANK(C8,$C$4:$C$8)"> 4</TD> <TD class=xl40 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 81pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" width=108 x:str="98" x:fmla="=LEFT(B8,2)"> 98년도</TD> <TD class=xl51 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:fmla="=LEFT(A8,1)"> 최</TD> <TD class=xl55 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: transparent" x:fmla="=MID(A8,2,2)"> 아름</TD> <TD class=xl58 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:fmla="=MID(B8,8,1)"> 2</TD></TR> <TR style="HEIGHT: 14.25pt" height=19> <TD class=xl29 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent" height=19>  </TD> <TD class=xl29 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">  </TD> <TD class=xl29 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">  </TD> <TD class=xl41 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext 1pt solid; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: transparent"> 1번란</TD> <TD class=xl41 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext 1pt solid; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: transparent"> 2번란</TD> <TD class=xl41 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext 1pt solid; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: transparent"> 3번란</TD> <TD class=xl56 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: windowtext; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: transparent"> 4번란</TD> <TD class=xl62 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent"> 5번란</TD></TR> <TR style="HEIGHT: 14.25pt" height=19> <TD class=xl28 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 60pt; BORDER-BOTTOM: #ece9d8; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent" width=80 height=19>순위</TD> <TD class=xl29 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD> <TD class=xl29 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD> <TD class=xl29 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD> <TD class=xl29 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD> <TD class=xl29 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD> <TD class=xl29 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD> <TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD></TR> <TR style="HEIGHT: 14.25pt" height=19> <TD class=xl42 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: windowtext 1pt solid; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: #ece9d8; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent" colSpan=8 height=19>1번란작성:해당셀에 커서위치-함수마법사클릭-rank클릭-number란에 순위표시할 셀위치클릭-ref란에 검사할 셀 범위</TD></TR> <TR style="HEIGHT: 14.25pt" height=19> <TD class=xl59 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: windowtext 1pt solid; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent" colSpan=8 height=19>를 드레그[설정]한후 절대참조셀을 표시하는 F4를 클릭[$D$5:$D$9]로 나타남.order:0/내림차순  1/오름차순 나타냄</TD></TR> <TR style="HEIGHT: 14.25pt" height=19> <TD class=xl46 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent" height=19>출생년도</TD> <TD class=xl29 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD> <TD class=xl29 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD> <TD class=xl29 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD> <TD class=xl29 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD> <TD class=xl29 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD> <TD class=xl29 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD> <TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD></TR> <TR style="HEIGHT: 13.5pt" height=18> <TD class=xl42 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: windowtext 1pt solid; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: #ece9d8; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" colSpan=8 height=18>2번란 작성요령:해당셀에 커서위치-함수마법사클릭-left클릭[왼쪽에서부터]-text에 해당셀클릭-tab클릭[아래로이동]</TD></TR> <TR style="HEIGHT: 14.25pt" height=19> <TD class=xl44 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent" colSpan=8 height=19>num-chars칸에 2[좌에서부터 2자리를 나타내라는 표시]를 입력후 확인 클릭/년도는 셀서식에서 @"년도"로 표시</TD></TR> <TR style="HEIGHT: 14.25pt" height=19> <TD class=xl46 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent" height=19>성씨</TD> <TD class=xl29 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD> <TD class=xl29 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD> <TD class=xl29 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD> <TD class=xl29 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD> <TD class=xl29 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD> <TD class=xl29 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD> <TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD></TR> <TR style="HEIGHT: 13.5pt" height=18> <TD class=xl47 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: windowtext 1pt solid; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: #ece9d8; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" colSpan=8 height=18>3번란작성요령:해당셀에 커서위치-함수마법사클릭-left클릭[왼쪽에서부터]-text에 해당셀클릭-tab클릭[아래로이동]</TD></TR> <TR style="HEIGHT: 14.25pt" height=19> <TD class=xl49 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent" colSpan=8 height=19>num-chars칸에 2[좌에서부터 2자리를 나타내라는 표시]를 입력후 확인 클릭[성씨가 표시됨]</TD></TR> <TR style="HEIGHT: 14.25pt" height=19> <TD class=xl46 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent" height=19>이름</TD> <TD class=xl29 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD> <TD class=xl29 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD> <TD class=xl29 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD> <TD class=xl29 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD> <TD class=xl29 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD> <TD class=xl29 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD> <TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD></TR> <TR style="HEIGHT: 13.5pt" height=18> <TD class=xl47 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: windowtext 1pt solid; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: #ece9d8; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" colSpan=8 height=18>4번란작성요령:해당셀에 커서위치-함수마법사클릭-mid클릭[지정된위치부터에서부터 지정된 숫자만큼 가져옴]-</TD></TR> <TR style="HEIGHT: 14.25pt" height=19> <TD class=xl49 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent" colSpan=8 height=19>text 칸에 해당셀 클릭       start-num 칸에 2[두자리수부터]      num-chars 2[두자리를 표시] 확인[이름2자표시됨]</TD></TR> <TR style="HEIGHT: 14.25pt" height=19> <TD class=xl46 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent" height=19>성별란</TD> <TD class=xl29 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD> <TD class=xl29 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD> <TD class=xl29 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD> <TD class=xl29 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD> <TD class=xl29 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD> <TD class=xl29 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD> <TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD></TR> <TR style="HEIGHT: 13.5pt" height=18> <TD class=xl47 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: windowtext 1pt solid; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: #ece9d8; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" colSpan=8 height=18>4번란작성요령:해당셀에 커서위치-함수마법사클릭-mid클릭[지정된위치부터에서부터 지정된 숫자만큼 가져옴]-</TD></TR> <TR style="HEIGHT: 14.25pt" height=19> <TD class=xl49 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent" colSpan=8 height=19>text 칸에 해당셀 클릭       start-num 칸에 8[8번째자리수부터]      num-chars 1[한자리를 표시] 확인[성별이숫자로표시됨]</TD></TR> <TR style="HEIGHT: 13.5pt" height=18> <TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" height=18></TD> <TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD> <TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD> <TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD> <TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD> <TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD> <TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD> <TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD></TR></TBODY></TABLE>  각란 작성후 자동채우기를 해야 한다. <DIV class=autosourcing-stub></DIV>