<![CDATA[
<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;">컴활2급실기 함수 질문 <img src="https://img1.daumcdn.net/relay/cafe/original/?fname=http%3A%2F%2Fstatic.naver.net%2Fkin%2F09renewal%2Fexppoint%2Fico_capa_60.gif" width="22" height="15" class="grade" alt="내공60" style="margin: 0px; padding: 0px 1px 0px 0px; border: 0px; position: relative; top: 2px; vertical-align: top;"></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;">질문 26건 질문마감률</span><span style="margin: 0px -1px 0px 4px; padding: 0px; color: rgb(44, 95, 153);">100%</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.03.21. 22:40</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);">18</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="_endContentsText" style="margin: 0px; padding: 0px;">제가 실전기출문제 직접풀어보다가 궁금한것이 있습니다.<div style="margin: 0px; padding: 0px;"><table border="0" cellpadding="0" cellspacing="0" width="541" style="margin: 0px; padding: 0px; border-collapse: collapse; width: 406pt;"><colgroup style="margin: 0px; padding: 0px;"><col width="104" span="3" style="margin: 0px; padding: 0px; width: 78pt;"><col width="117" style="margin: 0px; padding: 0px; width: 88pt;"><col width="112" style="margin: 0px; padding: 0px; width: 84pt;"></colgroup><tbody style="margin: 0px; padding: 0px;"><tr height="18" style="margin: 0px; padding: 0px; height: 13.5pt;"><td height="18" class="xl64" colspan="2" width="208" style="margin: 0px; padding: 0px; height: 13.5pt; width: 156pt;"><br style="margin: 0px; padding: 0px;">[표5] 완제품 생산현황</td><td width="104" style="margin: 0px; padding: 0px; width: 78pt;"></td><td width="117" style="margin: 0px; padding: 0px; width: 88pt;"></td><td width="112" style="margin: 0px; padding: 0px; width: 84pt;"></td></tr><tr height="18" style="margin: 0px; padding: 0px; height: 13.5pt;"><td height="18" class="xl63" style="margin: 0px; padding: 0px; height: 13.5pt;">생산일자</td><td class="xl63" style="margin: 0px; padding: 0px; border-left-style: none;">공정</td><td class="xl63" style="margin: 0px; padding: 0px; border-left-style: none;">제품</td><td class="xl63" style="margin: 0px; padding: 0px; border-left-style: none;">옵션</td><td class="xl66" style="margin: 0px; padding: 0px; border-left-style: none;">제품식별번호</td></tr><tr height="18" style="margin: 0px; padding: 0px; height: 13.5pt;"><td height="18" class="xl65" style="margin: 0px; padding: 0px; height: 13.5pt; border-top-style: none;">2007-03-09</td><td class="xl63" style="margin: 0px; padding: 0px; border-top-style: none; border-left-style: none;">ps01</td><td class="xl63" style="margin: 0px; padding: 0px; border-top-style: none; border-left-style: none;">pgh</td><td class="xl63" style="margin: 0px; padding: 0px; border-top-style: none; border-left-style: none;">a</td><td class="xl65" style="margin: 0px; padding: 0px; border-top-style: none; border-left-style: none;">PGH-A-1</td></tr><tr height="18" style="margin: 0px; padding: 0px; height: 13.5pt;"><td height="18" class="xl65" style="margin: 0px; padding: 0px; height: 13.5pt; border-top-style: none;">2008-04-11</td><td class="xl63" style="margin: 0px; padding: 0px; border-top-style: none; border-left-style: none;">ps02</td><td class="xl63" style="margin: 0px; padding: 0px; border-top-style: none; border-left-style: none;">pgw</td><td class="xl63" style="margin: 0px; padding: 0px; border-top-style: none; border-left-style: none;">s</td><td class="xl65" style="margin: 0px; padding: 0px; border-top-style: none; border-left-style: none;">PGW-S-2</td></tr><tr height="18" style="margin: 0px; padding: 0px; height: 13.5pt;"><td height="18" class="xl65" style="margin: 0px; padding: 0px; height: 13.5pt; border-top-style: none;">2007-10-23</td><td class="xl63" style="margin: 0px; padding: 0px; border-top-style: none; border-left-style: none;">ps03</td><td class="xl63" style="margin: 0px; padding: 0px; border-top-style: none; border-left-style: none;">pgs</td><td class="xl63" style="margin: 0px; padding: 0px; border-top-style: none; border-left-style: none;">f</td><td class="xl65" style="margin: 0px; padding: 0px; border-top-style: none; border-left-style: none;">PGS-F-3</td></tr><tr height="18" style="margin: 0px; padding: 0px; height: 13.5pt;"><td height="18" class="xl65" style="margin: 0px; padding: 0px; height: 13.5pt; border-top-style: none;">2009-06-27</td><td class="xl63" style="margin: 0px; padding: 0px; border-top-style: none; border-left-style: none;">ps03</td><td class="xl63" style="margin: 0px; padding: 0px; border-top-style: none; border-left-style: none;">pgf</td><td class="xl63" style="margin: 0px; padding: 0px; border-top-style: none; border-left-style: none;">w</td><td class="xl65" style="margin: 0px; padding: 0px; border-top-style: none; border-left-style: none;">PGF-W-3</td></tr><tr height="18" style="margin: 0px; padding: 0px; height: 13.5pt;"><td height="18" class="xl65" style="margin: 0px; padding: 0px; height: 13.5pt; border-top-style: none;">2008-12-30</td><td class="xl63" style="margin: 0px; padding: 0px; border-top-style: none; border-left-style: none;">ps04</td><td class="xl63" style="margin: 0px; padding: 0px; border-top-style: none; border-left-style: none;">pgw</td><td class="xl63" style="margin: 0px; padding: 0px; border-top-style: none; border-left-style: none;">a</td><td class="xl65" style="margin: 0px; padding: 0px; border-top-style: none; border-left-style: none;">PGW-A-4</td></tr><tr height="18" style="margin: 0px; padding: 0px; height: 13.5pt;"><td height="18" class="xl65" style="margin: 0px; padding: 0px; height: 13.5pt; border-top-style: none;">2009-07-03</td><td class="xl63" style="margin: 0px; padding: 0px; border-top-style: none; border-left-style: none;">ps01</td><td class="xl63" style="margin: 0px; padding: 0px; border-top-style: none; border-left-style: none;">pgh</td><td class="xl63" style="margin: 0px; padding: 0px; border-top-style: none; border-left-style: none;">s</td><td class="xl65" style="margin: 0px; padding: 0px; border-top-style: none; border-left-style: none;">PGH-S-1</td></tr><tr height="18" style="margin: 0px; padding: 0px; height: 13.5pt;"><td height="18" class="xl65" style="margin: 0px; padding: 0px; height: 13.5pt; border-top-style: none;">2008-09-17</td><td class="xl63" style="margin: 0px; padding: 0px; border-top-style: none; border-left-style: none;">ps02</td><td class="xl63" style="margin: 0px; padding: 0px; border-top-style: none; border-left-style: none;">pgf</td><td class="xl63" style="margin: 0px; padding: 0px; border-top-style: none; border-left-style: none;">q</td><td class="xl65" style="margin: 0px; padding: 0px; border-top-style: none; border-left-style: none;">PGF-Q-2</td></tr></tbody></table><br style="margin: 0px; padding: 0px;"></div><div style="margin: 0px; padding: 0px;">표5의 공정,제품 및 옵션을 참조하여 제품식별번호를 계산하고 [E33:E39] 영역에 대문자로 표시하시오.</div><div style="margin: 0px; padding: 0px;">▶제품식별번호=제품-옵션-공정의 마지막 숫자 [표시 예: 공정(ps09),제품(aaa),옵션(a)→'AAA-A-9']</div><div style="margin: 0px; padding: 0px;">▶UPPER,RIGHT함수와 & 연산자 모두 사용</div><div style="margin: 0px; padding: 0px;"><br style="margin: 0px; padding: 0px;"></div><div style="margin: 0px; padding: 0px;">이 문제입니다. 책에 있는 답이 =UPPER(C33)&"-"&UPPER(D33)&"-"&RIGHT(B33,1) 이건데</div><div style="margin: 0px; padding: 0px;">저는 이렇게 풀었습니다 =UPPER(C33&"-"&D33&"-"&RIGHT(B33,1))</div><div style="margin: 0px; padding: 0px;">풀이수식과는 다르지만 저기 위에있는 사항들도 다지켰고 정답도 풀이랑 똑같이 나옵니다.</div><div style="margin: 0px; padding: 0px;">이럴경우 시험장에서는 틀린거라고 체크되나요??</div></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=248502746&page=1#" id="cmtstr_0" class="btn _write_opinion _param('kin,10202,248502746,0,KxtrKAtdKogdFxbwFZvZFA29KAUXFAMGpzkRD4vGF029E0-HLvpK3dw6xt==') " 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=248502746&page=1#" class="btn opinion _metoo_wonder disable _param('10202,248502746,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=248502746&page=1#" class="_statement _ros _param('question,10202,248502746,KxtrKAtdKogdFxbwFZvZFA29KAUXFAMGpzkRD4vGF029E0-HLvpK3dw6xt==')" 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="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=248502746&page=1#" 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);">45</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.03.21. 23:07</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;">감사합니다 수욜시험 마음 편히 볼수있겠네요^^ 답변내용이 많은 도움 되었습니다.</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;">그렇지 않습니다<br style="margin: 0px; padding: 0px;">문제에서 제시한 함수를 전부썻고, 결과값 또한 일치하기때문에 정답으로 인정이됩니다<br style="margin: 0px; padding: 0px;"><br style="margin: 0px; padding: 0px;">-균쌤</div></div></div></div></div><p><br></p>
<!-- -->
]]>
카페 게시글
균쌤의 지식인
컴활2급실기 함수 질문
남균
추천 0
조회 92
16.04.12 15:21
댓글 0
다음검색
