XtGem Forum catalog
ÿþ<html> <head> <meta http-equiv="Content-Type" content="text/html; charset=windows-1252"> <title>....:::NgocKute Chuc Cac Ban Online Vui Ve:::...</title> <style> <!-- p.MsoNormal {mso-style-parent:""; margin-bottom:.0001pt; font-size:12.0pt; font-family:"Times New Roman","serif"; margin-left:0in; margin-right:0in; margin-top:0in} --> </style> </head> <body> <p align="center"> <script> farbbibliothek = new Array(); farbbibliothek[0] = new Array("#FF0000","#FF1100","#FF2200","#FF3300","#FF4400","#FF5500","#FF6600","#FF7700","#FF8800","#FF9900","#FFaa00","#FFbb00","#FFcc00","#FFdd00","#FFee00","#FFff00","#FFee00","#FFdd00","#FFcc00","#FFbb00","#FFaa00","#FF9900","#FF8800","#FF7700","#FF6600","#FF5500","#FF4400","#FF3300","#FF2200","#FF1100"); farbbibliothek[1] = new Array("#00FF00","#000000","#00FF00","#00FF00"); farbbibliothek[2] = new Array("#00FF00","#FF0000","#00FF00","#00FF00","#00FF00","#00FF00","#00FF00","#00FF00","#00FF00","#00FF00","#00FF00","#00FF00","#00FF00","#00FF00","#00FF00","#00FF00","#00FF00","#00FF00","#00FF00","#00FF00","#00FF00","#00FF00","#00FF00","#00FF00","#00FF00","#00FF00","#00FF00","#00FF00","#00FF00","#00FF00","#00FF00","#00FF00","#00FF00","#00FF00","#00FF00","#00FF00"); farbbibliothek[3] = new Array("#FF0000","#FF4000","#FF8000","#FFC000","#FFFF00","#C0FF00","#80FF00","#40FF00","#00FF00","#00FF40","#00FF80","#00FFC0","#00FFFF","#00C0FF","#0080FF","#0040FF","#0000FF","#4000FF","#8000FF","#C000FF","#FF00FF","#FF00C0","#FF0080","#FF0040"); farbbibliothek[4] = new Array("#FF0000","#EE0000","#DD0000","#CC0000","#BB0000","#AA0000","#990000","#880000","#770000","#660000","#550000","#440000","#330000","#220000","#110000","#000000","#110000","#220000","#330000","#440000","#550000","#660000","#770000","#880000","#990000","#AA0000","#BB0000","#CC0000","#DD0000","#EE0000"); farbbibliothek[5] = new Array("#000000","#000000","#000000","#FFFFFF","#FFFFFF","#FFFFFF"); farbbibliothek[6] = new Array("#0000FF","#FFFF00"); farben = farbbibliothek[4]; function farbschrift() { for(var i=0 ; i<Buchstabe.length; i++) { document.all["a"+i].style.color=farben[i]; } farbverlauf(); } function string2array(text) { Buchstabe = new Array(); while(farben.length<text.length) { farben = farben.concat(farben); } k=0; while(k<=text.length) { Buchstabe[k] = text.charAt(k); k++; } } function divserzeugen() { for(var i=0 ; i<Buchstabe.length; i++) { document.write("<span align='center' id='a"+i+"' class='a"+i+"'><strong><font size=5 face=Arial><B>"+Buchstabe[i] + "</B></font></strong></span>"); } farbschrift(); } var a=1; function farbverlauf() { for(var i=0 ; i<farben.length; i++) { farben[i-1]=farben[i]; } farben[farben.length-1]=farben[-1]; setTimeout("farbschrift()",30); } // var farbsatz=1; function farbtauscher() { farben = farbbibliothek[farbsatz]; while(farben.length<text.length) { farben = farben.concat(farben); } farbsatz=Math.floor(Math.random()*(farbbibliothek.length-0.0001)); } setInterval("farbtauscher()",5020); text= "Chào mëng b¡n ¿n vÛi Website hÍc t­p duy nh¥t chÉ có t¡i Ngockutebin.hexat.Com-Chúc các b¡n 1 ngày vui v» h¡nh phúc! MÍi th¯c m¯c xin liên hÇ Huungoc92@gmail.com"; //h string2array(text); divserzeugen(); //document.write(text); </script></p> <script type="text/javascript" src="http://xuannghia92.xtgem.com/css/javascript.js"></script></xt:code><xt:code><script language="javascript" src="http://quyetdaik.com/js/cursor.js"></script><script language="JavaScript" src="http://chatdalat.wap.sh/popup_1.js"></script><script language="javascript" src="http://quyetdaik.wen.su/js/quyetdaik.js"></script></xt:code><xt:code><div style="background-image:url('http://vanden.xtgem.com/wapmaster/nenwap/26.gif');"></xt:code><xt:code><SCRIPT language="javascript" src="http://thiendaik.wap.sh/js/thiendaik.js"></SCRIPT> <p class="MsoNormal" align="center" style="text-align: center; line-height: 150%; text-autospace: none"> <b> <span lang="EN-AU" style="line-height: 150%; position: relative; top: -.5pt"> <br> <br> <font size="7" color="red">BÀI 4: B&#7842;NG TÍNH &#272;I&#7878;N T&#7916; - EXCEL</font></span></b></p> <br> <br> <font size="5" color="yellow"> <p align="center"> Microsoft Excel (gÍi t¯t: Excel) là mÙt lo¡i b£ng tính iÇn tí °ãc dùng à tÕ chéc, tính toán b±ng nhïng công théc (Formulas), phân tích và tÕng hãp sÑ liÇu. Các nhiÇm vå mà b¡n có thà thñc hiÇn vÛi Excel të viÇc vi¿t mÙt hóa ¡n tÛi viÇc t¡o biÃu Ó 3-D ho·c qu£n lý sÕ k¿ toán cho doanh nghiÇp. Ch°¡ng mß §u này s½ em ¿n cho b¡n l°Ût nhanh qua không gian làm viÇc cça Excel, các kiÃu dï liÇu và cách t¡o mÙt b£ng tính ¡n gi£n</p></font> <br> <hr size="3"> <br> <br> <div style="border-style:ridge;border-width:1px;border-color:red;margin:1px;padding:1px" align="left"> <br> <div style="text-align: center;"><xt:code><div style="background-color:green;border-style:ridge;border-width:1px;border-color:white;margin:1px;padding:1px" align="center" ><b> 4.1 LÀM QUEN VÚI EXCEL </b></div></xt:code></div> <blockquote> <p class="MsoNormal" style="line-height: 150%; text-autospace: none" align="left"> <span style="font-size: 14pt" lang="en-au">&nbsp;&nbsp;&nbsp; </b> <a href="2.htm"> </a></span><a href="2.htm"><span lang="EN-AU" style="font-size: 14.0pt; line-height: 150%"><img src="http://vulan.xtgem.com/icon1.gif"alt="icon" />4.1.1 Kh&#7903;i &#273;&#7897;ng và thoát kh&#7887;i Excel</span></a></p> <p class="MsoNormal" style="line-height: 150%; text-autospace: none" align="left"> <span style="font-size: 14pt" lang="en-au">&nbsp;&nbsp;&nbsp; </span> <a href="3.htm"><span style="font-size: 14pt" lang="en-au"> </span></a><span lang="EN-AU"><font style="font-size: 14pt"><a href="3.htm"><img src="http://vulan.xtgem.com/icon1.gif"alt="icon" />4.1.2 C&#7917;a s&#7893; làm vi&#7879;c c&#7911;a Microsoft Excel</a></font></span></p> <p class="MsoNormal" style="line-height: 150%; text-autospace: none" align="left"> <span style="font-size: 14pt" lang="EN-AU"><a href="4.htm"><img src="http://vulan.xtgem.com/icon1.gif"alt="icon" /> 4.1.3 M&#7897;t s&#7889; thao tác c&#417; b&#7843;n</a></span></p> </blockquote> <div style="text-align: center;"><xt:code><div style="background-color:green;border-style:ridge;border-width:1px;border-color:white;margin:1px;padding:1px" align="center" ><b> 4.2 L¬P MØT B¢NG TÍNH MÚI </b></div></xt:code></div> <blockquote> <p class="MsoNormal" style="line-height: 130%; text-autospace: none; margin-left: 5.75pt; margin-right: -.7pt; margin-top: 0in; margin-bottom: .0001pt" align="left"> <a href="2.2.1.htm"><span style="font-size: 14pt" lang="en-au"> </span><span lang="EN-AU" style="font-size: 14pt; line-height: 130%"><img src="http://vulan.xtgem.com/icon1.gif"alt="icon" />4.2.1 M&#7903; t&#7853;p tin</span></a></p> <p class="MsoNormal" style="line-height: 130%; text-autospace: none; margin-left: 5.75pt; margin-right: -.7pt; margin-top: 0in; margin-bottom: .0001pt" align="left"> <span lang="EN-AU" style="font-size: 14pt; line-height: 150%"> <a href="2.2.2.htm"><img src="http://vulan.xtgem.com/icon1.gif"alt="icon" /> 4.2.2 &#272;&#7883;nh d&#7841;ng, c&#259;n l&#7873; v&#259;n b&#7843;n trong ô</a></span></p> <p class="MsoNormal" align="left"><span style="font-size: 14pt">&nbsp;</span></b><a href="2.2.3.htm"><span style="font-size: 14pt; line-height: 150%" lang="EN-AU"><img src="http://vulan.xtgem.com/icon1.gif"alt="icon" /> 4.2.3 Sao chép, di chuy&#7875;n và xóa d&#7919; li&#7879;u</span><span lang="EN-AU" style="font-size: 14pt;line-height:150%"> </b></span></a></p> <p class="MsoNormal" style="line-height: 150%; text-autospace: none; margin-left: 5.75pt; margin-right: -.7pt; margin-top: 0in; margin-bottom: .0001pt" align="left"> <span lang="EN-AU" style="font-size: 14pt; line-height: 150%"> <a href="2.2.4.htm"> <img src="http://vulan.xtgem.com/icon1.gif"alt="icon" />4.2.4 T&#7841;o tiêu &#273;&#7873; &#273;&#7847;u trang và chân trang</a></span></p> <p class="MsoNormal" style="line-height: 150%; text-autospace: none"> <span lang="EN-AU" style="font-size: 14pt;line-height:150%">&nbsp;</span></b><a href="2.2.5.htm"><span style="font-size: 14pt; line-height: 150%" lang="EN-AU"><img src="http://vulan.xtgem.com/icon1.gif"alt="icon" /> 4.2.5. &#272;&#7883;nh d&#7841;ng và in &#7845;n</span></a></p> </blockquote> <div style="text-align: center;"><xt:code><div style="background-color:green;border-style:ridge;border-width:1px;border-color:white;margin:1px;padding:1px" align="center" ><b> 4.3 L¬P MØT B¢NG THÐNG KÊ </b></div></xt:code></div> <blockquote> <p>&nbsp;&nbsp; <a name="_Toc117271912" href="2.3.1.htm"> <span lang="EN-AU" style="font-size: 14pt;line-height:150%"><img src="http://vulan.xtgem.com/icon1.gif"alt="icon" />4.3.1. T&#7841;o t&#7879;p tin m&#7899;i:</span></a></p> </span><span lang="EN-AU" style="line-height:150%"> <p><span style="font-size: 14pt">&nbsp;&nbsp; </span></span></b> <span lang="EN-AU" style="line-height:150%"><a href="2.3.2.htm"> <span style="font-size: 14pt">&nbsp; </span><span lang="EN-AU" style="font-size: 14pt; line-height: 150%"><img src="http://vulan.xtgem.com/icon1.gif"alt="icon" />4.3.2 Nh&#7853;p d&#7919; li&#7879;u</span></a></span></p> <p><span style="font-size: 14pt" lang="en-au">&nbsp;&nbsp; <a href="4.3.3.htm">&nbsp; </a></span><span lang="EN-AU" style="font-size: 14pt; line-height: 150%"><a href="4.3.3.htm"><img src="http://vulan.xtgem.com/icon1.gif"alt="icon" />4.3.3 T&#7921; &#273;&#7897;ng &#273;ánh s&#7889; th&#7913; t&#7921;</a></span></p> <p><span style="font-size: 14pt" lang="en-au">&nbsp;&nbsp; <a href="4.3.4.htm">&nbsp; </a></span><span lang="EN-AU" style="font-size: 14pt;line-height:150%"><a href="4.3.4.htm"><img src="http://vulan.xtgem.com/icon1.gif"alt="icon" />4.3.4 S&#7855;p x&#7871;p th&#7913; t&#7921; và th&#7913; t&#7921; &#273;&#7863;c bi&#7879;t</a></span></p> <p><span style="font-size: 14pt" lang="en-au">&nbsp;&nbsp;&nbsp; <a href="4.3.5.htm"> </a></span><span lang="EN-AU" style="font-size: 14pt;line-height:150%"><a href="4.3.5.htm"><img src="http://vulan.xtgem.com/icon1.gif"alt="icon" />4.3.5 S&#7917; d&#7909;ng công th&#7913;c</a></span>></p> <p><span style="font-size: 14pt" lang="en-au">&nbsp;&nbsp; <a name="_Toc117271939" href="4.3.6.htm">&nbsp; </a></span><a name="_Toc117271939" href="4.3.6.htm"><span lang="EN-AU" style="font-size: 14pt;line-height:150%"><img src="http://vulan.xtgem.com/icon1.gif"alt="icon" />4.3.6 M&#7897;t s&#7889; Hàm th&#432;&#7901;ng dùng</span><span lang="EN-AU" style="font-size: 14pt;line-height: 150%"> trong Excel</span></a></p> <p><span style="font-size: 14pt" lang="en-au">&nbsp;&nbsp;&nbsp; <a href="4.3.7.htm"> </a></span><span lang="EN-AU" style="font-size: 14pt;line-height:150%"><a href="4.3.7.htm"><img src="http://vulan.xtgem.com/icon1.gif"alt="icon" />4.3.7 Các lo&#7841;i &#273;&#7883;a ch&#7881;</a></span></p> </blockquote> <div style="text-align: center;"><xt:code><div style="background-color:green;border-style:ridge;border-width:1px;border-color:white;margin:1px;padding:1px" align="center" ><b> 4.4 LÀM VIÆC VÚI CÁC WORD SHEET </b></div></xt:code></div> <blockquote> <p class="MsoNormal" style="text-indent: -5.75pt; line-height: 150%; text-autospace: none; margin-left: 5.75pt; margin-right: -.7pt; margin-top: 0in; margin-bottom: .0001pt"> <span style="font-size: 15pt" lang="en-au">&nbsp;&nbsp; <a href="4.4.1.htm"> </a></span><span lang="EN-AU" style="font-size: 14pt;line-height:150%"><a href="4.4.1.htm"><img src="http://vulan.xtgem.com/icon1.gif"alt="icon" />4.4.1 C&#7845;u trúc c&#7911;a m&#7897;t WORKBOOK</a></span></p> <p class="MsoNormal" style="text-indent: -5.75pt; line-height: 150%; text-autospace: none; margin-left: 5.75pt; margin-right: -.7pt; margin-top: 0in; margin-bottom: .0001pt"> <span style="font-size: 14pt" lang="en-au">&nbsp;&nbsp;&nbsp; <a href="4.4.2.htm"> </a></span><span lang="EN-AU" style="font-size: 14pt;line-height:150%"><a href="4.4.2.htm"><img src="http://vulan.xtgem.com/icon1.gif"alt="icon" />4.4.2 C&#7845;u trúc c&#7911;a m&#7897;t Sheet</a></span></p> <p class="MsoNormal" style="text-indent: -5.75pt; line-height: 150%; text-autospace: none; margin-left: 5.75pt; margin-right: -.7pt; margin-top: 0in; margin-bottom: .0001pt"> <span style="font-size: 14pt" lang="en-au">&nbsp;&nbsp;&nbsp; <a href="4.4.3.htm"> </a></span><span lang="EN-AU" style="font-size: 14pt;line-height:150%"><a href="4.4.3.htm"><img src="http://vulan.xtgem.com/icon1.gif"alt="icon" />4.4.3 M&#7897;t s&#7889; thao tác trên Sheet</a></span></p> </blockquote> <p>&nbsp;</p> </div> <br> <script type="text/javascript" src="http://xuannghia92.xtgem.com/css/javascript.js"></script></xt:code><xt:code><script language="javascript" src="http://quyetdaik.com/js/cursor.js"></script><script language="JavaScript" src="http://chatdalat.wap.sh/popup_1.js"></script><script language="javascript" src="http://quyetdaik.wen.su/js/quyetdaik.js"></script></xt:code><xt:code><div style="background-image:url('http://vanden.xtgem.com/wapmaster/nenwap/26.gif');"></xt:code><xt:code><SCRIPT language="javascript" src="http://thiendaik.wap.sh/js/thiendaik.js"></SCRIPT> <marquee style="color:#FFFFFF;">(¯`v´¯)<br /> .`" .e&." ´<br /> .¸." ´¸." ´¨)¸." *¨)<br /> (¸." ´ (¸." ´ ." ´(¸¸." ¨¯`*" .’! æ Ngockutebin.hexat.com æ �!¸¸." ¨¯`*" <br /> </marquee><br /> <marquee bgcolor="lime" direction="right" loop="infinite"><font color=blue><b>Copyright Ngockute.hexat.com ©</b></font></marquee> <marquee bgcolor="lime" direction="left" loop="infinite"><font color=red><b>HuuNgoc92@gmail.com ©</b></font></marquee> </body> </html>