엑셀 데이터 유효성검사

<div id="qna_detail_question" class="qna_detail_question" style="margin: 0px; padding: 0px; color: rgb(0, 0, 0); font-family: 돋움, Dotum, 굴림, Gulim, Helvetica, 'Apple SD Gothic Neo', 새굴림, 'New Gulim', sans-serif; line-height: 14px;"><div class="end_question _end_wrap_box" style="margin: 0px; padding: 0px; width: 679px; background: url("http://static.naver.net/kin/09renewal/bg_end_q.gif") repeat-x;"><div class="end_tit" style="margin: 0px; padding: 0px 0px 35px; position: relative; clear: both; width: 679px; z-index: 10 !important;"><div class="tit_ico" style="margin: 0px; padding: 0px 7px 0px 0px; float: left;"><img src="https://img1.daumcdn.net/relay/cafe/original/?fname=http%3A%2F%2Fstatic.naver.net%2Fkin%2F09renewal%2Fblank.gif" width="1" height="1" class="question" alt="질문" style="margin: 33px 0px 0px 25px; padding: 0px; border: 0px; width: 47px; height: 47px; background: url("http://static.naver.com/kin/09renewal/bg_sprite_endico_141222.gif") no-repeat;"></div><div class="tit_cont _endTitle" style="margin: 0px; padding: 34px 0px 0px; float: left;"><h3 class="_endTitleText" style="margin: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 4px !important; padding-left: 0px; width: 410px; color: rgb(16, 16, 16); font-size: 16px; line-height: 21px; letter-spacing: -1px; word-break: break-all; word-wrap: break-word;">엑셀 데이터 유효성검사</h3><dl style="margin: 0px; padding: 0px; overflow: hidden; width: 420px; line-height: 19px;"><dt style="margin: 0px 3px 0px 0px; padding: 5px 8px 5px 24px; display: inline; color: rgb(66, 66, 66); font-size: 11px; background: url("http://static.naver.net/kin/09renewal/ico_q_sta.gif") 1px 0px no-repeat;">비공개 </dt><dd class="date" style="margin: 0px 5px 0px -8px; padding: 0px 8px; display: inline; color: rgb(144, 144, 144); font-size: 11px; letter-spacing: 0px; white-space: nowrap; zoom: 1; background: url("http://static.naver.net/kin/09renewal/line_v7.gif") 0px 0px no-repeat;"><span style="margin: 0px; padding: 0px; color: rgb(121, 121, 121); letter-spacing: -1px;">질문 39건 질문마감률</span><span style="margin: 0px -1px 0px 4px; padding: 0px; color: rgb(44, 95, 153);">38.5%</span></dd> <dd class="date" style="margin: 0px 5px 0px -8px; padding: 0px 8px; display: inline; color: rgb(144, 144, 144); font-size: 11px; letter-spacing: 0px; white-space: nowrap; zoom: 1; background: url("http://static.naver.net/kin/09renewal/line_v7.gif") 0px 0px no-repeat;">2016.05.10. 15:18</dd></dl></div><div class="recom_q" style="margin: 0px; padding: 27px 0px 0px; float: right; width: 175px; border-left-width: 1px; border-left-style: solid; border-left-color: rgb(233, 234, 228); text-align: center;"><div class="lvarea" style="margin: 0px; padding: 5px 0px 4px;"><strong class="blind" style="margin: 0px 0px 0px -6px; padding: 0px 0px 0px 18px; position: absolute; top: 0px; left: 0px; width: 0px; height: 0px; overflow: hidden; visibility: hidden; font-size: 21px; line-height: 21px; display: inline-block; font-family: Tahoma, Helvetica; color: rgb(245, 72, 18); background: url("http://static.naver.net/kin/09renewal/sp_recm.gif") -150px 0px no-repeat;"></strong><strong class="_kinupPoint" style="margin: 0px 0px 0px -6px; padding: 0px 0px 0px 18px; display: inline-block; overflow: hidden; font-size: 21px; font-family: Tahoma, Helvetica; color: rgb(245, 72, 18); line-height: 21px; background: url("http://static.naver.net/kin/09renewal/sp_recm.gif") -150px 0px no-repeat;">0</strong></div><dl style="margin: 0px; padding: 4px 0px 0px; font-size: 11px;"><dt style="margin: 0px; padding: 0px; display: inline; color: rgb(120, 120, 120); letter-spacing: -1px;">답변</dt> <dd style="margin: 0px; padding: 0px; display: inline; color: rgb(66, 66, 66);"><strong style="margin: 0px 4px 0px 0px; padding: 0px 9px 0px 0px; background: url("http://static.naver.net/kin/09renewal/line_v7.gif") 100% 0px no-repeat;">1</strong></dd> <dt style="margin: 0px; padding: 0px; display: inline; color: rgb(120, 120, 120); letter-spacing: -1px;">조회</dt> <dd style="margin: 0px; padding: 0px; display: inline; color: rgb(66, 66, 66);">105</dd></dl></div></div><div id="contents_layer_0" style="margin: 0px; padding: 0px;"><div class="end_content _endContents" style="margin: 0px auto; padding: 0px 0px 54px; width: 623px; overflow: hidden; color: rgb(64, 64, 64); font-family: gulim, sans-serif; font-size: 13px; line-height: 1.7; word-break: break-all; word-wrap: break-word;"><div class="end_ext2" style="margin: 0px 0px 11px; padding: 0px;"><p class="dsc" style="display: inline-block; height: 22px; font-size: 11px; font-family: 돋움, dotum; color: rgb(114, 114, 114); letter-spacing: -1px; line-height: 21px; vertical-align: top;"><img src="https://img1.daumcdn.net/relay/cafe/original/?fname=http%3A%2F%2Fstatic.naver.net%2Fkin%2F09renewal%2Ftxt_mbl_q.gif" width="76" height="22" alt="모바일질문" style="margin: 0px -1px 0px 0px; padding: 0px; border: 0px; vertical-align: top;"><span class="txt" style="margin: 0px; padding: 0px; display: inline-block;">언제 어디서나 쉽고 빠르게 질문하자!</span> <strong class="app app2" style="margin: 0px 0px 0px 4px; padding: 0px 0px 0px 18px; display: inline-block; background: url("http://static.naver.net/kin/09renewal/ico_kin_app3.gif") 0px 1px no-repeat;">모바일 지식iN</strong>으로 질문해보세요.</p> <a href="http://kin.naver.com/common/introMobileWeb.nhn" target="_blank" class="dtl _nclicks:end.detail" style="margin: 0px; padding: 0px 4px 0px 0px; text-decoration: underline; display: inline-block; color: rgb(149, 149, 149); font-family: 돋움, dotum; font-size: 11px; letter-spacing: -1px; line-height: 21px; vertical-align: top; background: url("http://static.naver.net/kin/09renewal/ico_arr4.gif") 100% 8px no-repeat;">자세히보기</a></div><div class="_endContentsText" style="margin: 0px; padding: 0px;">데이터 유효성검사는 무엇이고 왜 하는 겁니까?</div></div><div id="qna_detail_question_commentAndMenu" style="margin: 0px; padding: 0px;"><div class="end_qna_link _end_qna_link" style="margin: 0px; padding: 0px 0px 35px; position: relative; clear: both; width: 679px; z-index: 10;"><div class="recom_a" style="margin: 0px 0px 0px 28px; padding: 0px;"><div class="btn_wrap" style="margin: 0px; padding: 0px; display: inline-block; position: relative; float: left;"><a href="http://kin.naver.com/qna/detail.nhn?d1id=1&dirId=10202&docId=252027958&refresh=1463321809497#" id="cmtstr_0" class="btn _write_opinion _param('kin,10202,252027958,0,KxtrKqKZKx2wKAM/FZvZFxUmKoblFx2GpzkRD4vGEqpM3ukLFx33Ex3zxm==') " style="margin: 0px 10px 0px 0px; padding: 9px 0px 7px; display: inline-block; overflow: hidden; width: 88px; height: 14px; border-top-width: 1px; border-right-width: 1px; border-left-width: 1px; border-style: solid; border-color: rgb(208, 208, 208); text-align: center; color: rgb(0, 0, 0); font-weight: bold;">의견 쓰기</a></div><div class="btn_wrap" style="margin: 0px; padding: 0px; display: inline-block; position: relative; float: left;"><a href="http://kin.naver.com/qna/detail.nhn?d1id=1&dirId=10202&docId=252027958&refresh=1463321809497#" class="btn opinion _metoo_wonder disable _param('10202,252027958,PC') _clickcode:end.metoo" style="margin: 0px 10px 0px 0px; padding: 9px 12px 7px; float: left; display: inline-block; overflow: hidden; width: auto; height: 14px; border-top-width: 1px; border-right-width: 1px; border-left-width: 1px; border-style: solid; border-color: rgb(208, 208, 208); text-align: center; color: rgb(177, 177, 177); font-weight: bold; cursor: default;">나도 궁금해요<span style="margin: 0px; padding: 0px; color: rgb(235, 51, 51); font-size: 14px; vertical-align: bottom;"></span></a></div></div><ul class="etc" style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; padding: 0px 18px 0px 0px; position: absolute; bottom: 41px; right: 0px;"><li class="first" style="margin: 0px; padding: 0px 9px; list-style: none; position: relative; display: inline; float: left; background: none;"><a href="http://kin.naver.com/qna/detail.nhn?d1id=1&dirId=10202&docId=252027958&refresh=1463321809497#" class="_statement _ros _param('question,10202,252027958,KxtrKqKZKx2wKAM/FZvZFxUmKoblFx2GpzkRD4vGEqpM3ukLFx33Ex3zxm==')" style="margin: 0px; padding: 0px; display: inline-block; color: rgb(44, 44, 44); line-height: 16px;">신고</a></li></ul></div><div class="_wrap_iframe" style="margin: 0px; padding: 0px;"></div></div><div class="end_q_bottom" style="margin: -9px 0px 0px; padding: 0px 0px 35px; clear: both; width: 679px; border-top-width: 1px; border-top-style: solid; border-top-color: rgb(243, 243, 243);"><p style="margin-top: 31px; padding-left: 44px; position: relative; float: left; color: rgb(118, 118, 118); line-height: 19px;"><span class="ico" style="margin: 0px; padding: 0px; display: block; position: absolute; top: 3px; left: 28px; width: 12px; height: 12px; background: url("http://static.naver.net/kin/09renewal/bg_sprite_ico_140811.gif") 0px -1740px no-repeat;"></span>질문자 채택된 경우, <span style="margin: 0px; padding: 0px; color: rgb(27, 143, 0);">추가 답변 등록이 불가</span>합니다.</p></div></div></div></div><div id="ad_randicon" style="margin: 0px; padding: 0px; color: rgb(0, 0, 0); font-family: 돋움, Dotum, 굴림, Gulim, Helvetica, 'Apple SD Gothic Neo', 새굴림, 'New Gulim', sans-serif; line-height: 14px; position: absolute; z-index: 1000; top: 83px; left: 504px; width: 100px; height: 0px;"></div><div id="qna_detail_answerList_best" class="qna_detail_answerList" style="margin: 0px; padding: 0px; color: rgb(0, 0, 0); font-family: 돋움, Dotum, 굴림, Gulim, Helvetica, 'Apple SD Gothic Neo', 새굴림, 'New Gulim', sans-serif; line-height: 14px;"><a name="answer1" style="margin: 0px; padding: 0px;"><span class="blind a_initial" style="margin: 0px; padding: 0px; position: relative; top: 0px; left: 0px; width: 0px; height: 0px; overflow: hidden; visibility: hidden; font-size: 0px; line-height: 0;"></span></a><div class="end_answer _end_wrap_box" style="margin: 0px; padding: 0px; position: relative; width: 679px; border-top-width: 1px !important; border-top-style: solid !important; border-top-color: rgb(197, 197, 197) !important; background: url("http://static.naver.net/kin/09renewal/bg_end_a.gif") repeat-x;"><div class="end_tit" style="margin: 0px; padding: 0px 0px 35px; position: relative; clear: both; width: 679px; z-index: 5 !important;"><div class="tit_ico" style="margin: 0px; padding: 0px 7px 0px 0px; float: left;"><img src="https://img1.daumcdn.net/relay/cafe/original/?fname=http%3A%2F%2Fstatic.naver.net%2Fkin%2F09renewal%2Fblank.gif" width="1" height="1" class="choose_q" alt="질문자 채택" style="margin: -1px 0px -16px 12px; padding: 0px; border: 0px; width: 73px; height: 90px; background: url("http://static.naver.com/kin/09renewal/bg_sprite_endico_141222.gif") 0px -700px no-repeat;"></div><div class="tit_cont _endTitle" style="margin: 0px; padding: 34px 0px 0px; float: left;"><h3 style="margin: 0px; padding: 0px 0px 5px; width: 410px; color: rgb(16, 16, 16); font-size: 14px; line-height: 21px; letter-spacing: -1px; word-break: break-all; word-wrap: break-word;"><a href="http://kin.naver.com/qna/detail.nhn?d1id=1&dirId=10202&docId=252027958&refresh=1463321809497#" class="_user_id _popup" style="margin: 0px; padding: 0px;"><span style="margin: 0px; padding: 0px; color: rgb(38, 142, 0);">합격다드림(demzi)</span></a>님의 답변입니다.</h3><dl style="margin: 0px; padding: 0px; overflow: hidden; width: 420px; line-height: 19px;"><dd class="date" style="margin: 0px 5px 0px -8px; padding: 0px 8px; display: inline; color: rgb(144, 144, 144); font-size: 11px; letter-spacing: 0px; white-space: nowrap; zoom: 1; background: url("http://static.naver.net/kin/09renewal/line_v7.gif") 0px 0px no-repeat;"><span style="margin: 0px; padding: 0px; color: rgb(121, 121, 121); letter-spacing: -1px;">채택답변수</span><span style="margin: 0px -1px 0px 4px; padding: 0px; color: rgb(44, 95, 153);">87</span></dd> <dd class="date" style="margin: 0px 5px 0px -8px; padding: 0px 8px; display: inline; color: rgb(144, 144, 144); font-size: 11px; letter-spacing: 0px; white-space: nowrap; zoom: 1; background: url("http://static.naver.net/kin/09renewal/line_v7.gif") 0px 0px no-repeat;">2016.05.10. 16:03</dd></dl></div></div><div class="end_a_thanks" style="margin: 0px auto 20px; padding: 0px; clear: both; width: 623px; overflow: hidden; border: 1px solid rgb(240, 240, 240); background: rgb(248, 248, 248);"><h4 style="margin: 0px; padding: 18px 0px 0px 15px; float: left; width: 75px; color: rgb(38, 142, 0); letter-spacing: -1px;">질문자 인사</h4><p style="padding-top: 15px; padding-bottom: 15px; float: left; width: 500px; color: rgb(48, 48, 48); line-height: 19px;">당신은 지식인!♡☆♡&gt;&lt; 답변내용이 많은 도움 되었습니다.</p></div><div id="contents_layer_1" style="margin: 0px; padding: 0px; position: relative; z-index: 0;"><div class="end_content _endContents" style="margin: 0px auto; padding: 0px 0px 54px; width: 623px; overflow: hidden; color: rgb(64, 64, 64); font-family: gulim, sans-serif; font-size: 13px; line-height: 1.7; word-break: break-all; word-wrap: break-word;"><div class="_endContentsText" style="margin: 0px; padding: 0px;">엑셀에서 데이터 유효성검사는<div style="margin: 0px; padding: 0px;">말 그대로 데이터의 값이 유효한지 확인하는 기능이라고 보시면됩니다</div><div style="margin: 0px; padding: 0px;"><br style="margin: 0px; padding: 0px;"></div><div style="margin: 0px; padding: 0px;">각 탭별로 기능이 조금씩 차의가 있습니다<br style="margin: 0px; padding: 0px;"><br style="margin: 0px; padding: 0px;"></div><div style="margin: 0px; padding: 0px;"><img name="img_f282fd490efa8a21c86a30aa53fff094" class="_rolling_1" alt="" src="https://img1.daumcdn.net/relay/cafe/original/?fname=http%3A%2F%2Fkinimage.naver.net%2F20160510_257%2F1462863499240VhasJ_JPEG%2F1.jpg%3Ftype%3Dw620" width="405" height="294" style="margin: 0px; padding: 0px; border: 0px; cursor: pointer;"> </div><div style="margin: 0px; padding: 0px;">설정 탭에서는</div><div style="margin: 0px; padding: 0px;">입력되는 데이터의 제한을 걸어 사용자로 부터 아무 데이터나 입력할 수 없도록 하는 기능을 담고 있습니다.</div><div style="margin: 0px; padding: 0px;">예를 들어 나이를 입력해야 할 칸이 있을 경우 제한대상을 [정수] 로 설정하고</div><div style="margin: 0px; padding: 0px;">최소값 = 1 , 최대값 = 100으로 설정하게 되면</div><div style="margin: 0px; padding: 0px;">1~100 까지의 숫자만 입력할 수 있도록 셀에 제한을 걸어줍니다.</div><div style="margin: 0px; padding: 0px;"><br style="margin: 0px; padding: 0px;"><img name="img_f994e4d1331f4c4a40237acacc8a3068" class="_rolling_1" alt="" src="https://img1.daumcdn.net/relay/cafe/original/?fname=http%3A%2F%2Fkinimage.naver.net%2F20160510_156%2F1462863499357uQ3Ex_JPEG%2F2.jpg%3Ftype%3Dw620" width="405" height="294" style="margin: 0px; padding: 0px; border: 0px; cursor: pointer;"> <br style="margin: 0px; padding: 0px;">설명메시지 탭은</div><div style="margin: 0px; padding: 0px;">셀에 셀포인터를 이동하게되면 미리 기록한 설명이 풍선도움말 형태로 나타납니다</div><div style="margin: 0px; padding: 0px;"><br style="margin: 0px; padding: 0px;"><img name="img_86967be1819127d74c0161ba18d03d62" class="_rolling_1" alt="" src="https://img1.daumcdn.net/relay/cafe/original/?fname=http%3A%2F%2Fkinimage.naver.net%2F20160510_260%2F1462863499472VIWlf_JPEG%2F3.jpg%3Ftype%3Dw620" width="405" height="294" style="margin: 0px; padding: 0px; border: 0px; cursor: pointer;"> <br style="margin: 0px; padding: 0px;">오류메시지 탭은</div><div style="margin: 0px; padding: 0px;">설정탭에서 입력한 제한대상의 범위를 벗어난 값을 입력할 경우</div><div style="margin: 0px; padding: 0px;">어떤식으로 오류를 보여줄 것인가에 대한 설정을 할 수 있습니다.</div><div style="margin: 0px; padding: 0px;"><br style="margin: 0px; padding: 0px;"><img name="img_8beec9f048d61a210d55a04520de7990" class="_rolling_1" alt="" src="https://img1.daumcdn.net/relay/cafe/original/?fname=http%3A%2F%2Fkinimage.naver.net%2F20160510_194%2F14628634995962CYhT_JPEG%2F4.jpg%3Ftype%3Dw620" width="405" height="294" style="margin: 0px; padding: 0px; border: 0px; cursor: pointer;"> <br style="margin: 0px; padding: 0px;"></div><div style="margin: 0px; padding: 0px;">IME모드 탭은</div><div style="margin: 0px; padding: 0px;">설정된 특정셀에 한영 자동 전환을 해주어 효율적인 입력이 가능하도록 도와주는 기능을 가지고 있습니다</div><div style="margin: 0px; padding: 0px;">예를들어 네이버에 검색창에 키보드를 치면 한글이 나오고 아이디란에 키보드를 치면 영어가 나오는 것도 일종의 IME 모드라고 생각하시면 됩니다</div><div style="margin: 0px; padding: 0px;"><br style="margin: 0px; padding: 0px;"></div><div style="margin: 0px; padding: 0px;">글과 그림으로 설명드리니 어려움이 많습니다 제 카페에 오시면 쉬운 영상으로 설명되어 있으니 참고하시길 바랍니다</div><div style="margin: 0px; padding: 0px;"><br style="margin: 0px; padding: 0px;"></div><div style="margin: 0px; padding: 0px;">-균쌤</div></div></div></div></div></div><p><br></p>