부산과학기술대학교 경영과 유학생반

<p>1. COUNTIFS 함수를 사용하여 연령별 인원수 구하기</p><div class="figure-video" data-ke-type="video" data-video-url="https://kakaotv.daum.net/embed/player/cliplink/rvi5o13abrh2xdcd43iwcfof5@my?service=daum_cafe" data-video-host="kakaotv" data-video-play-service="daum_cafe" data-video-width="712" data-video-height="400" data-ke-style="alignCenter" data-video-thumbnail="https://img1.daumcdn.net/thumb/S712x400/?fname=https%3A%2F%2Fthumb.kakaocdn.net%2Fdna%2Fkamp%2Fsource%2Frvi5o13abrh2xdcd43iwcfof5%2Fthumbs%2F2.jpg%3Fcredential%3DTuMuFGKUIcirOSjFzOpncbomGFEIdZWK%26expires%3D33159420536%26signature%3DQYNcdVyvw2dIwiDv3vzm4z2RaIc%253D" data-ke-mobile-mobileStyle="widthFull" data-video-origin-width="712" data-video-origin-height="400"><iframe src="https://kakaotv.daum.net/embed/player/cliplink/rvi5o13abrh2xdcd43iwcfof5@my?service=daum_cafe&ptoken=v2_0f835065e277033f33fafb701fbfb7a4d9a83eeff19f83e967b93c32a0b269e3c2b54a2972a15feb9f1ebf686d56da11dfdaa041b73132c9e6a787da4e" width="712" height="400" frameborder="0" scrolling="no" allowfullscreen="" allow="encrypted-media"></iframe><div class="figcaption"></div></div><p>실습파일</p><div class="figure-file" data-ke-type="file" data-file-src="https://t1.daumcdn.net/cafeattach/1Ygzu/3f24b4e3c4114cff6d49f9f2276a79baf6f607de?download" data-file-name="6주차0301_COUNTIFS 함수를 사용하여 연령별 인원수 구하기.xlsx" data-file-size="13420" data-mimetype="application/vnd.openxmlformats-officedocument.spreadsheetml.sheet" data-ke-align="alignCenter"><a href='javascript:fileFilterViewer("https://t1.daumcdn.net/cafeattach/1Ygzu/3f24b4e3c4114cff6d49f9f2276a79baf6f607de?download", "/cafeattach/1Ygzu/3f24b4e3c4114cff6d49f9f2276a79baf6f607de", "6주차0301_COUNTIFS 함수를 사용하여 연령별 인원수 구하기.xlsx", "grpid%3D1Ygzu%26fldid%3DB4Rk%26dataid%3D16%26fileid%3D1%26regdt%3D20201012231720&url=https%3A%2F%2Ft1.daumcdn.net%2Fcafeattach%2F1Ygzu%2F3f24b4e3c4114cff6d49f9f2276a79baf6f607de")'><div class="image"></div><div class="desc"><div class="filename"><span class="name">6주차0301_COUNTIFS 함수를 사용하여 연령별 인원수 구하기</span><span class="type">.xlsx</span></div><div class="size">13.11KB</div></div></a></div><p> </p><p>2. ROUNDUP 함수 사용으로 소수 첫째 자리까지 나타내고 나머지 올림하기</p><div class="figure-video" data-ke-type="video" data-video-url="https://kakaotv.daum.net/embed/player/cliplink/rvh7qkizv4lr23epnfxyfgyc7@my?service=daum_cafe" data-video-host="kakaotv" data-video-play-service="daum_cafe" data-video-width="712" data-video-height="400" data-ke-style="alignCenter" data-video-thumbnail="https://img1.daumcdn.net/thumb/S712x400/?fname=https%3A%2F%2Fthumb.kakaocdn.net%2Fdna%2Fkamp%2Fsource%2Frvh7qkizv4lr23epnfxyfgyc7%2Fthumbs%2F2.jpg%3Fcredential%3DTuMuFGKUIcirOSjFzOpncbomGFEIdZWK%26expires%3D33159420665%26signature%3DdwGs3%252BW2ja89tVydrWhBKhlbg3E%253D" data-ke-mobile-mobileStyle="widthFull" data-video-origin-width="712" data-video-origin-height="400"><iframe src="https://kakaotv.daum.net/embed/player/cliplink/rvh7qkizv4lr23epnfxyfgyc7@my?service=daum_cafe&ptoken=v2_c821f83eb44c356f9abd8c93a3631112b7b59a554e2010cb0bf22d754a1d712fcd3d2824e8db0a9c1a602e65b5bb88f87cb3c5d28bbe8a4de8c77d1873" width="712" height="400" frameborder="0" scrolling="no" allowfullscreen="" allow="encrypted-media"></iframe><div class="figcaption"></div></div><p>실습파일</p><div class="figure-file" data-ke-type="file" data-file-src="https://t1.daumcdn.net/cafeattach/1Ygzu/b97792788f15ba73a750bcf372d3a086422bb447?download" data-file-name="6주차0302_ROUNDUP 함수 사용으로 소수 첫째 자리까지 나타내고 나머지 올림하기.xlsx" data-file-size="13577" data-mimetype="application/vnd.openxmlformats-officedocument.spreadsheetml.sheet" data-ke-align="alignCenter"><a href='javascript:fileFilterViewer("https://t1.daumcdn.net/cafeattach/1Ygzu/b97792788f15ba73a750bcf372d3a086422bb447?download", "/cafeattach/1Ygzu/b97792788f15ba73a750bcf372d3a086422bb447", "6주차0302_ROUNDUP 함수 사용으로 소수 첫째 자리까지 나타내고 나머지 올림하기.xlsx", "grpid%3D1Ygzu%26fldid%3DB4Rk%26dataid%3D16%26fileid%3D2%26regdt%3D20201012231720&url=https%3A%2F%2Ft1.daumcdn.net%2Fcafeattach%2F1Ygzu%2Fb97792788f15ba73a750bcf372d3a086422bb447")'><div class="image"></div><div class="desc"><div class="filename"><span class="name">6주차0302_ROUNDUP 함수 사용으로 소수 첫째 자리까지 나타내고 나머지 올림하기</span><span class="type">.xlsx</span></div><div class="size">13.26KB</div></div></a></div><p> </p><p>3. 지정한 자릿수를 버림하는 ROUNDDOWN 함수</p><div class="figure-video" data-ke-type="video" data-video-url="https://kakaotv.daum.net/embed/player/cliplink/rv8u4selrfwq3lmp5b456srda@my?service=daum_cafe" data-video-host="kakaotv" data-video-play-service="daum_cafe" data-video-width="712" data-video-height="400" data-ke-style="alignCenter" data-video-thumbnail="https://img1.daumcdn.net/thumb/S712x400/?fname=https%3A%2F%2Fthumb.kakaocdn.net%2Fdna%2Fkamp%2Fsource%2Frv8u4selrfwq3lmp5b456srda%2Fthumbs%2F2.jpg%3Fcredential%3DTuMuFGKUIcirOSjFzOpncbomGFEIdZWK%26expires%3D33159420808%26signature%3DF96QTQVGX5r%252FmIe3Iw%252Bw3gYSWWU%253D" data-ke-mobile-mobileStyle="widthFull" data-video-origin-width="712" data-video-origin-height="400"><iframe src="https://kakaotv.daum.net/embed/player/cliplink/rv8u4selrfwq3lmp5b456srda@my?service=daum_cafe&ptoken=v2_aa0206aed1e12add56b91db8084f8c2cef78ac800706336bb64a398544c9f0d07cbf4f3d281da48904c9342370792afaf144b149dcd1763d5ffe0eccda" width="712" height="400" frameborder="0" scrolling="no" allowfullscreen="" allow="encrypted-media"></iframe><div class="figcaption"></div></div><p>실습파일</p><div class="figure-file" data-ke-type="file" data-file-src="https://t1.daumcdn.net/cafeattach/1Ygzu/0f634451700487ec3255c55736b51d2d8f973f80?download" data-file-name="6주차0303_지정한 자릿수를 버림하는 ROUNDDOWN 함수.xlsx" data-file-size="13577" data-mimetype="application/vnd.openxmlformats-officedocument.spreadsheetml.sheet" data-ke-align="alignCenter"><a href='javascript:fileFilterViewer("https://t1.daumcdn.net/cafeattach/1Ygzu/0f634451700487ec3255c55736b51d2d8f973f80?download", "/cafeattach/1Ygzu/0f634451700487ec3255c55736b51d2d8f973f80", "6주차0303_지정한 자릿수를 버림하는 ROUNDDOWN 함수.xlsx", "grpid%3D1Ygzu%26fldid%3DB4Rk%26dataid%3D16%26fileid%3D3%26regdt%3D20201012231720&url=https%3A%2F%2Ft1.daumcdn.net%2Fcafeattach%2F1Ygzu%2F0f634451700487ec3255c55736b51d2d8f973f80")'><div class="image"></div><div class="desc"><div class="filename"><span class="name">6주차0303_지정한 자릿수를 버림하는 ROUNDDOWN 함수</span><span class="type">.xlsx</span></div><div class="size">13.26KB</div></div></a></div><p> </p><p> </p><p>4. 참과 거짓을 판별하는 IF 함수 기본 사용법과 다양한 결과값을 작성하는 방법</p><div class="figure-video" data-ke-type="video" data-video-url="https://kakaotv.daum.net/embed/player/cliplink/rvi9epxoc5bkj9pivyra1dfil@my?service=daum_cafe" data-video-host="kakaotv" data-video-play-service="daum_cafe" data-video-width="712" data-video-height="400" data-ke-style="alignCenter" data-video-thumbnail="https://img1.daumcdn.net/thumb/S712x400/?fname=https%3A%2F%2Fthumb.kakaocdn.net%2Fdna%2Fkamp%2Fsource%2Frvi9epxoc5bkj9pivyra1dfil%2Fthumbs%2F2.jpg%3Fcredential%3DTuMuFGKUIcirOSjFzOpncbomGFEIdZWK%26expires%3D33159421034%26signature%3D1i3%252Fsd65QWldalIVH%252Fz2VypRE%252Fw%253D" data-ke-mobile-mobileStyle="widthFull" data-video-origin-width="712" data-video-origin-height="400"><iframe src="https://kakaotv.daum.net/embed/player/cliplink/rvi9epxoc5bkj9pivyra1dfil@my?service=daum_cafe&ptoken=v2_b87982371dafa030643e58a70a84dd92eb60a3a9fe0b26d3741cff3312188e28079811434ec35df3b4b9d2e2280be579272237eb4c1137c95bac8fa48c" width="712" height="400" frameborder="0" scrolling="no" allowfullscreen="" allow="encrypted-media"></iframe><div class="figcaption"></div></div>