Excel word ppt officeʹÓü¼ÇÉ´óÈ«(DOC¸ñʽ)-µÚ30²¿·Ö

¿ì½Ý²Ù×÷: °´¼üÅÌÉÏ·½Ïò¼ü ¡û »ò ¡ú ¿É¿ìËÙÉÏÏ·­Ò³ °´¼üÅÌÉ쵀 Enter ¼ü¿É»Øµ½±¾ÊéĿ¼ҳ °´¼üÅÌÉÏ·½Ïò¼ü ¡ü ¿É»Øµ½±¾Ò³¶¥²¿! Èç¹û±¾ÊéûÓÐÔĶÁÍ꣬ÏëÏ´μÌÐø½Ó×ÅÔĶÁ£¬¿ÉʹÓÃÉÏ·½ "Êղص½ÎÒµÄä¯ÀÀÆ÷" ¹¦ÄÜ ºÍ "¼ÓÈëÊéÇ©" ¹¦ÄÜ£¡


varLettersTens¡¡¡¡&¡¡¡¡¡¨¡¡¡¡billion¡¨¡¡¡¡Case¡¡¡¡16¡¡¡¡varLettersTens¡¡¡¡=¡¡¡¡¡¨sixteen¡¨¡¡¡¡varLettersUnits¡¡¡¡=¡¡¡¡¡¨¡¨¡¡¡¡

varTwelveLetters¡¡¡¡=¡¡¡¡varLettersTens¡¡¡¡&¡¡¡¡¡¨¡¡¡¡billion¡¨¡¡¡¡Case¡¡¡¡17¡¡¡¡varLettersTens¡¡¡¡=¡¡¡¡¡¨seventeen¡¨¡¡¡¡

varLettersUnits¡¡=¡¡¡¨¡¨¡¡varTwelveLetters¡¡=¡¡varLettersTens¡¡&¡¡¡¨¡¡billion¡¨¡¡Case¡¡18¡¡varLettersTens¡¡=¡¡¡¡

¡¨eighteen¡¨¡¡¡¡varLettersUnits¡¡¡¡=¡¡¡¡¡¨¡¨¡¡¡¡varTwelveLetters¡¡¡¡=¡¡¡¡varLettersTens¡¡¡¡&¡¡¡¡¡¨¡¡¡¡billion¡¨¡¡¡¡Case¡¡¡¡19¡¡¡¡

varLettersTens¡¡=¡¡¡¨nineteen¡¨¡¡varLettersUnits¡¡=¡¡¡¨¡¨¡¡varTwelveLetters¡¡=¡¡varLettersTens¡¡&¡¡¡¨¡¡¡¡

billion¡¨¡¡¡¡¡¡End¡¡¡¡¡¡Select¡¡¡¡¡¡If¡¡¡¡¡¡Right£¨varTwelveFigures£»¡¡¡¡¡¡1£©¡¡¡¡¡¡=¡¡¡¡¡¡0¡¡¡¡¡¡Then¡¡¡¡¡¡varTwelveLetters¡¡¡¡¡¡=¡¡¡¡

varLettersTens¡¡¡¡¡¡&¡¡¡¡¡¡¡¨¡¡¡¡¡¡billion¡¨¡¡¡¡¡¡End¡¡¡¡¡¡If¡¡¡¡¡¡End¡¡¡¡¡¡If¡¡¡¡¡¡If¡¡¡¡¡¡Len£¨£§varTwelveFigures£§£©¡¡¡¡¡¡=¡¡¡¡¡¡3¡¡¡¡¡¡Then¡¡¡¡

varTwelveLetters¡¡=¡¡varLettersHundreds¡¡&¡¡¡¨¡¡¡¨¡¡&¡¡varLettersTens¡¡&¡¡¡¨¡¡¡¨¡¡&¡¡varLettersUnits¡¡&¡¡¡¨¡¡¡¡

billion¡¨¡¡¡¡Select¡¡¡¡Case¡¡¡¡Right£¨£§varTwelveFigures£§£»¡¡¡¡2£©¡¡¡¡Case¡¡¡¡11¡¡¡¡varLettersTens¡¡¡¡=¡¡¡¡¡¨eleven¡¨¡¡¡¡

varLettersUnits¡¡=¡¡¡¡¡¨¡¨¡¡varTwelveLetters¡¡=¡¡¡¡varLettersHundreds¡¡¡¡&¡¡¡¨¡¡¡¨¡¡&¡¡varLettersTens¡¡&¡¡¡¡¡¨¡¡¡¡

billion¡¨¡¡¡¡Case¡¡¡¡12¡¡¡¡varLettersTens¡¡¡¡=¡¡¡¡¡¨twelve¡¨¡¡¡¡varLettersUnits¡¡¡¡=¡¡¡¡¡¨¡¨¡¡¡¡varTwelveLetters¡¡¡¡=¡¡¡¡

varLettersHundreds¡¡&¡¡¡¨¡¡¡¨¡¡&¡¡varLettersTens¡¡&¡¡¡¨¡¡billion¡¨¡¡Case¡¡13¡¡varLettersTens¡¡=¡¡¡¨thirteen¡¨¡¡¡¡

varLettersUnits¡¡=¡¡¡¨¡¨¡¡¡¡¡¡¡¡



¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡CCVII¡¡¡¡


¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­Page¡¡208¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­

¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡Excel_word_ppt_ʹÓü¼ÇÉ´óÈ«£¨ÍêÈ«°æ£©¡¡¡¡



varTwelveLetters¡¡¡¡=¡¡¡¡varLettersHundreds¡¡¡¡&¡¡¡¡¡¨¡¡¡¡¡¨¡¡¡¡&¡¡¡¡varLettersTens¡¡¡¡&¡¡¡¡¡¨¡¡¡¡billion¡¨¡¡¡¡Case¡¡¡¡14¡¡¡¡

varLettersTens¡¡=¡¡¡¨fourteen¡¨¡¡varLettersUnits¡¡=¡¡¡¨¡¨¡¡varTwelveLetters¡¡=¡¡varLettersHundreds¡¡&¡¡¡¨¡¡¡¡

¡¨¡¡¡¡&¡¡¡¡varLettersTens¡¡¡¡&¡¡¡¡¡¨¡¡¡¡billion¡¨¡¡¡¡Case¡¡¡¡15¡¡¡¡varLettersTens¡¡¡¡=¡¡¡¡¡¨fifteen¡¨¡¡¡¡varLettersUnits¡¡¡¡=¡¡¡¡¡¨¡¨¡¡¡¡

varTwelveLetters¡¡¡¡=¡¡¡¡varLettersHundreds¡¡¡¡&¡¡¡¡¡¨¡¡¡¡¡¨¡¡¡¡&¡¡¡¡varLettersTens¡¡¡¡&¡¡¡¡¡¨¡¡¡¡billion¡¨¡¡¡¡Case¡¡¡¡16¡¡¡¡

varLettersTens¡¡=¡¡¡¨sixteen¡¨¡¡varLettersUnits¡¡=¡¡¡¨¡¨¡¡varTwelveLetters¡¡=¡¡varLettersHundreds¡¡&¡¡¡¨¡¡¡¨¡¡¡¡

&¡¡varLettersTens¡¡&¡¡¡¨¡¡billion¡¨¡¡Case¡¡17¡¡varLettersTens¡¡=¡¡¡¨seventeen¡¨¡¡varLettersUnits¡¡=¡¡¡¨¡¨¡¡¡¡

varTwelveLetters¡¡¡¡=¡¡¡¡varLettersHundreds¡¡¡¡&¡¡¡¡¡¨¡¡¡¡¡¨¡¡¡¡&¡¡¡¡varLettersTens¡¡¡¡&¡¡¡¡¡¨¡¡¡¡billion¡¨¡¡¡¡Case¡¡¡¡18¡¡¡¡

varLettersTens¡¡=¡¡¡¨eighteen¡¨¡¡varLettersUnits¡¡=¡¡¡¨¡¨¡¡varTwelveLetters¡¡=¡¡varLettersHundreds¡¡&¡¡¡¨¡¡¡¡

¡¨¡¡&¡¡varLettersTens¡¡&¡¡¡¨¡¡billion¡¨¡¡Case¡¡19¡¡varLettersTens¡¡=¡¡¡¨nineteen¡¨¡¡varLettersUnits¡¡=¡¡¡¨¡¨¡¡¡¡

varTwelveLetters¡¡=¡¡varLettersHundreds¡¡&¡¡¡¨¡¡¡¨¡¡&¡¡varLettersTens¡¡&¡¡¡¨¡¡billion¡¨¡¡End¡¡Select¡¡¡¡If¡¡¡¡

Right£¨varTwelveFigures£»¡¡¡¡1£©¡¡¡¡=¡¡¡¡0¡¡¡¡Then¡¡¡¡varTwelveLetters¡¡¡¡=¡¡¡¡varLettersHundreds¡¡¡¡&¡¡¡¡¡¨¡¡¡¡¡¨¡¡¡¡&¡¡¡¡

varLettersTens¡¡¡¡&¡¡¡¡¡¨¡¡¡¡billion¡¨¡¡¡¡End¡¡¡¡If¡¡¡¡If¡¡¡¡Right£¨Left£¨£§varTwelveFigures£§£»¡¡¡¡2£©£»¡¡¡¡1£©¡¡¡¡=¡¡¡¡0¡¡¡¡Then¡¡¡¡

varTwelveLetters¡¡=¡¡varLettersHundreds¡¡&¡¡¡¨¡¡¡¨¡¡&¡¡varLettersUnits¡¡&¡¡¡¨¡¡billion¡¨¡¡End¡¡If¡¡End¡¡If¡¡If¡¡¡¡

Right£¨varNineFigures£»¡¡2£©¡¡=¡¡¡¨00¡¨¡¡Then¡¡varNineLetters¡¡=¡¡varLettersHundreds¡¡&¡¡¡¨¡¡¡¨¡¡&¡¡¡¨¡¡billions¡¨¡¡¡¡

GoTo¡¡jumpFinish¡¡End¡¡If¡¡¡¡¡¡¡¡



¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡CCVIII¡¡¡¡


¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­Page¡¡209¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­

¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡Excel_word_ppt_ʹÓü¼ÇÉ´óÈ«£¨ÍêÈ«°æ£©¡¡¡¡



End¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡If¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡''''¡¡¡¡

**************************************************************************¡¡

*********************¡¡'¡¡jumpFinish£º¡¡If¡¡varLenghtNumber¡¡¡¶¡¡4¡¡Then¡¡fctNumbersLetters¡¡=¡¡¡¡

varThreeLetters¡¡¡¡End¡¡¡¡If¡¡¡¡If¡¡¡¡varLenghtNumber¡¡¡¡¡·¡¡¡¡3¡¡¡¡And¡¡¡¡varLenghtNumber¡¡¡¡¡¶¡¡¡¡7¡¡¡¡Then¡¡¡¡

fctNumbersLetters¡¡=¡¡varSixLetters¡¡&¡¡¡¨¡¡¡¨¡¡&¡¡varThreeLetters¡¡End¡¡If¡¡If¡¡varLenghtNumber¡¡¡·¡¡6¡¡¡¡

And¡¡varLenghtNumber¡¡¡¶¡¡10¡¡Then¡¡fctNumbersLetters¡¡=¡¡varNineLetters¡¡&¡¡¡¨¡¡¡¨¡¡&¡¡varSixLetters¡¡¡¡

&¡¡¡¨¡¡¡¨¡¡&¡¡varThreeLetters¡¡If¡¡varSixFigures¡¡=¡¡0¡¡Then¡¡fctNumbersLetters¡¡=¡¡varNineLetters¡¡&¡¡¡¨¡¡¡¨¡¡¡¡

&¡¡varThreeLetters¡¡End¡¡If¡¡End¡¡If¡¡If¡¡varLenghtNumber¡¡¡·¡¡9¡¡And¡¡varLenghtNumber¡¡¡¶¡¡13¡¡Then¡¡¡¡

fctNumbersLetters¡¡=¡¡varTwelveLetters¡¡&¡¡¡¨¡¡¡¨¡¡&¡¡varNineLetters¡¡&¡¡¡¨¡¡¡¨¡¡&¡¡varSixLetters¡¡&¡¡¡¨¡¡¡¨¡¡&¡¡¡¡

varThreeLetters¡¡If¡¡varSixFigures¡¡=¡¡0¡¡Then¡¡fctNumbersLetters¡¡=¡¡varTwelveLetters¡¡&¡¡¡¨¡¡¡¨¡¡&¡¡¡¡

varNineLetters¡¡&¡¡¡¨¡¡¡¨¡¡&¡¡varThreeLetters¡¡End¡¡If¡¡If¡¡varSixFigures¡¡=¡¡0¡¡And¡¡varNineFigures¡¡=¡¡0¡¡¡¡

Then¡¡¡¡fctNumbersLetters¡¡¡¡=¡¡¡¡varTwelveLetters¡¡¡¡&¡¡¡¡¡¨¡¡¡¡¡¨¡¡¡¡&¡¡¡¡varThreeLetters¡¡¡¡End¡¡¡¡If¡¡¡¡End¡¡¡¡If¡¡¡¡

varPremiereLettre¡¡¡¡¡¡¡¡¡¡¡¡=¡¡¡¡¡¡¡¡¡¡UCase£¨Left£¨fctNumbersLetters£»¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡1£©£©¡¡¡¡¡¡¡¡fctNumbersLetters¡¡¡¡¡¡¡¡¡¡¡¡=¡¡¡¡

varPremiereLettre¡¡¡¡&¡¡¡¡Right£¨fctNumbersLetters£»¡¡¡¡Len£¨fctNumbersLetters£©¡¡¡¡¡¡1£©¡¡¡¡End¡¡¡¡Function¡¡¡¡

¡¡¡¶24¡·ÈçºÎÈõ¥Ôª¸ñΪ0ʱÏÔʾΪ¡¡¡¡¸ñʽ£¬µ¥Ôª¸ñ£¬Êý×Ö£¬»á¼ÆרÓá¡¡¡

µ±µ¥Ôª¸ñΪ¡¨0¡¨Ê±£»Ò²¿ÉÒÔµãÑ¡¹¤¾ßÀ¸Éϵġ¨Ç§·Öλ·Ö¸ô·û¡¨£»¼´¡¨¶ººÅͼ±ê¡¨¡£¡¡¡¡¡¡¡¡

Ñ¡Öбí¸ñ·¶Î§¡¡±à¼­/¶¨Î»/¿Õµ¥Ôª¸ñÈ»ºóÊäÈë¡¡°´c£«enter¡¡¡¡¶¨Î»ºó£¬½«Êó±êÔÚ¹«Ê½±à¼­À¸Öе㡡

һϣ¬È»ºóÖ±½ÓÊäÈë¡°¡­¡¨£»È»ºó°´Ctrl£«Enter¡¡¡¡¡¡¡¡



¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡CCIX¡¡¡¡


¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­Page¡¡210¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­

¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡Excel_word_ppt_ʹÓü¼ÇÉ´óÈ«£¨ÍêÈ«°æ£©¡¡¡¡



¡¡¡¶26¡·ÎÒÒª½«´óÁ¿Åú×¢ÀïÃæµÄ¼¸¸ö×ÖÌ滻ΪÆäËü×ÖÔõô×ö£¿¡¡¡¡ÓÃÐÞ¶©£­£­£¾Åú×¢¡¡È»ºóÓÃÌæ»»¡¡

¡¡¡¶25¡·excelÈçºÎÑ­ÐУ¨row£©ÅÅÐò£¿¡¡¡¡¡¡¡¶27¡·É¸Ñ¡²Ù×÷ʱ£¬ÓÐʱ״̬Çø»á³öÏÖÂú×ãÌõ¼þµÄ¸öÊýͳ¼Æ£¬¡¡

ÓÐʱ²»»áÔõô°ì£¿¡¡¡¡É¸Ñ¡ÎÊÌâÔÚɸѡ²Ù×÷ʱ£¬ÓÐʱ״̬À¸»á³öÏÖÂú×ãÌõ¼þµÄ¸öÊýͳ¼Æ£¬²»ÊÇÖ¸Çó¡¡

ºÍ¡£¡¡µ«ÓÐʱ²»ÏÔʾ¸öÊýͳ¼Æ¡£¸÷λ¸ßÊÖ£¬ÈçºÎ²Ù×÷£¡£¡£¡¡¡¹¤¾ß¡­¡­¡­¡­¡­Ñ¡Ïî¡­¡­¡­¡­¡­ÖØмÆËã¡­¡­¡­¡­¡­Ñ¡¡¡

¡¡£¨ÊÖ¶¯¼ÆË㣩¡­¡­¡­¡­¡­È·¶¨¡¶28¡·¹ØÓÚ·Ö¼¶ÏÔʾ¹¤×÷±íµÄ˵Ã÷Òþ²Ø¹¦ÄÜÈçºÎÄÜÒþ²ØÁлòÀ¸Ê±ÒÔ¡¡£«¡¡¡¡»ò¡¡¡¡

¡¡¿ØÖÆÄØ£¿Ï£Íû´ó¼ÒÃ÷°×СµÜÎÊÌ⣡¡¡ÄÇ¿ÉÄܾÍÊÇ·Ö¼¶ÏÔʾ°É¡¡¡¡



¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡CCX¡¡¡¡


¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­Page¡¡211¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­

¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡Excel_word_ppt_ʹÓü¼ÇÉ´óÈ«£¨ÍêÈ«°æ£©¡¡¡¡



¹ØÓÚ·Ö¼¶ÏÔʾ¹¤×÷±íMicrosoft¡¡¡¡Excel¡¡¡¡¿É´´½¨Êý¾Ý·Ö¼¶ÏÔʾ£¬ÓÃÊó±êµ¥»÷¼´¿ÉÏÔʾºÍÒþ²ØÃ÷ϸ¡¡

Êý¾ÝµÄ¼¶±ð¡£µ¥»÷·Ö¼¶ÏÔʾ·ûºÅ¡¢¡¡ºÍ¡¡¿ÉѸËÙµØÖ»ÏÔʾÄÇЩΪ¹¤×÷±íÖи÷²¿·ÖÌṩ»ã×Ü»ò±êÌâ¡¡

µÄÐлòÁУ¬»òÕß¿ÉʹÓ÷ּ¶ÏÔʾ·ûºÅÀ´²é¿´µ¥¸ö»ã×ܺͱêÌâϵÄÃ÷ϸÊý¾Ý¡£×¼±¸Òª½øÐзּ¶ÏÔ¡¡

ʾµÄÊý¾Ý¡¡Òª·Ö¼¶ÏÔʾµÄÊý¾ÝӦΪÊý¾ÝÇåµ¥£¨Çåµ¥£º°üº¬Ïà¹ØÊý¾ÝµÄһϵÁй¤×÷±íÐУ¬ÀýÈ磬¡¡

·¢Æ±Êý¾Ý¿â»òÒ»×é¿Í»§Ãû³ÆºÍµç»°ºÅÂë¡£Çåµ¥µÄµÚÒ»ÐоßÓÐÁбêÖ¾¡££©µÄ¸ñʽ£¬ÆäÖеÚÒ»Ðеġ¡

ÿһÁж¼ÓбêÖ¾£¬Í¬Ò»ÁÐÖаüº¬ÏàËƵÄÊý¾Ý£¬Çåµ¥ÖÐûÓпÕÐкͿÕÁС£ÔÚ·Ö¼¶ÏÔʾǰ£¬ÐèÒª½«¡¡

Êý¾Ý½øÐÐÅÅÐòÒԱ㽫ͬһ×éÖеÄÐзÅÔÚÒ»Æð¡£ÔÚÉÏÎĵÄʾÀýÖУ¬Êý¾ÝÇåµ¥ÊǸù¾ÝµØÇøÒÔ¼°Ô·ݡ¡

ÅÅÐòµÄ£¬Òò´Ë¡°¶«²¿¡±µØÇøÇåµ¥ÖÐÈýÔ·ݺÍËÄÔ·ݵÄÃ÷ϸÊý¾ÝÐб»·ÖÔÚÁËÒ»Æ𣬶ø¡°Î÷²¿¡±µØÇøÇå¡¡

µ¥ÖÐÿÔµÄÃ÷ϸÊý¾ÝÐÐÒ²±»·ÖÔÚÁËÒ»Æð¡£ÔÚÿ×éÃ÷ϸÊý¾ÝÐеÄÉÏ·½»òÏ·½½«ÏÔʾ»ã×ÜÐС£ÎªÁË¡¡

»ñµÃ×î¼ÑЧ¹û£¬»ã×ÜÐÐÓ¦°üº¬ÒýÓÃÿ¸öÃ÷ϸÊý¾ÝÐÐÖе¥Ôª¸ñµÄ¹«Ê½¡£ÔÚʾÀýÖУ¬Ã¿ÔºÍÿ¸öµØ¡¡

ÇøµÄÃ÷ϸÊý¾ÝÏ·½¶¼ÓÐÒ»¸ö»ã×ÜÐС£ÀýÈ磬µÚ¡¡14¡¡¡¡ÐеÄÊý¾ÝÊǵڡ¡11¡¡¡¡Ðе½µÚ¡¡13¡¡¡¡ÐеÄÏúÊ۶

µÄ»ã×Ü¡£Ò²¿É·Ö¼¶ÏÔʾ°üº¬ÃèÊöÐÔÎı¾»òÆäËûÊý¾ÝµÄ»ã×ÜÐÐÖеÄÊý¾Ý¡£Èç¹ûÒª·Ö¼¶ÏÔʾÁжø²»¡¡

ÊÇÐУ¬ÇëÈ·±£Çåµ¥µÄµÚÒ»ÁÐÓÐÁб꣬²¢ÇÒÃ÷ϸÊý¾ÝÁеÄÓұ߻ò×ó±ßÓÐÒ»¸ö»ã×ÜÁС£¡¡ÏÔʾºÍÒþ¡¡

²Ø·Ö¼¶ÏÔʾÊý¾Ý¡¡·Ö¼¶ÏÔʾ¿ÉÒÔ¾ßÓÐÖÁ¶à°Ë¸ö¼¶±ðµÄÃ÷ϸÊý¾Ý£¬ÆäÖÐÿ¸öÄÚ²¿¼¶±ðΪǰÃæµÄÍâ¡¡

²¿¼¶±ðÌṩÃ÷ϸÊý¾Ý¡£ÔÚʾÀýÖУ¬°üº¬ËùÓÐÐеĻã×ܵġ°ÏúÊÛ×ܶÐÐΪµÚÒ»¼¶±ð¡£°üº¬Ã¿Ô»㡡

×ܵÄÐÐΪµÚ¶þ¼¶£¬ÏúÊÛµÄÃ÷ϸÊý¾ÝÐÐΪµÚÈý¼¶¡£ÈôÒªÖ»ÏÔʾij¸öÌØÊ⼶±ðÖеÄÐУ¬Äú¿ÉÒÔµ¥»÷¡¡

ÏëÒª²é¿´µÄ¼¶±ð¶ÔÓ¦µÄÊý×Ö¡£ÔÚʾÀýÖУ¬¡°¶«²¿¡±µØÇøµÄÃ÷ϸÊý¾ÝÐк͡°Î÷²¿¡±µØÇø¡°¡¡ËÄÔ·ݡ±µÄÃ÷¡¡

ϸÊý¾ÝÐб»Òþ²Ø£¬²»¹ý¿Éµ¥»÷·ûºÅÀ´ÏÔʾÕâЩÐС£¡¡¡¡×Ô¶¯ÓëÊÖ¶¯·Ö¼¶ÏÔʾÊý¾Ý¡¡¡¡×Ô¶¯·Ö¼¶ÏÔʾ¡¡Èç¡¡

¹ûÄúµÄ»ã×ÜÊý¾ÝÖÐʹÓÃÁË°üº¬ÖîÈç¡¡SUM¡¡¡¡º¯Êý£¨º¯Êý£ºº¯ÊýÊÇÔ¤ÏȱàдµÄ¹«Ê½£¬¿ÉÒÔ¶ÔÒ»¸ö»ò¡¡

¶à¸öÖµÖ´ÐÐÔËË㣬²¢·µ»ØÒ»¸ö»ò¶à¸öÖµ¡£º¯Êý¿ÉÒÔ¼ò»¯ºÍËõ¶Ì¹¤×÷±íÖеĹ«Ê½£¬ÓÈÆäÔÚÓù«Ê½¡¡

Ö´Ðкܳ¤»ò¸´ÔӵļÆËãʱ¡££©µÄ¹«Ê½£¬ÄÇô¡¡Excel¡¡¡¡¿ÉÒÔÏñʾÀýÖÐÒ»Ñù×Ô¶¯µØ·Ö¼¶ÏÔʾÊý¾Ý¡£¡¡

»ã×ÜÊý¾Ý±ØÐëÓëÃ÷ϸÊý¾ÝÏàÁÚ¡£Èç¹û½«×Ô¶¯·ÖÀà»ã×ܲåÈë°´ÐÐ×éÖ¯µÄÊý¾ÝÇåµ¥£¬Ôò¡¡Excel¡¡¡¡»á¡¡

ÔÚͬʱ×Ô¶¯·Ö¼¶ÏÔʾ¹¤×÷±í£¬Òò´Ë¾Í¿ÉÏÔʾ»òÒþ²ØËùÐèµÄÈκÎÃ÷ϸÊý¾Ý¡£ÊÖ¶¯·Ö¼¶ÏÔʾ¡¡Èç¹û¡¡

ûÓжÔÊý¾Ý½øÐÐ×éÖ¯£¬ÄÇô¡¡Excel¡¡¡¡¾Í²»ÄÜ×Ô¶¯¶ÔÆä·Ö¼¶ÏÔʾ£¬µ«Äú¿ÉÊÖ¶¯´´½¨·Ö¼¶ÏÔʾ¡£Àý¡¡

È磬Èç¹û»ã×ÜÊý¾ÝÐлòÁаüº¬ÊýÖµ»òÃèÊöÐÔÎı¾£¬¶ø²»Êǹ«Ê½£¬ÔòÐèÒªÊÖ¶¯·Ö¼¶ÏÔʾÊý¾Ý¡£¡¡¡¡



¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡CCXI¡¡¡¡


¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­Page¡¡212¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­

¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡Excel_word_ppt_ʹÓü¼ÇÉ´óÈ«£¨ÍêÈ«°æ£©¡¡¡¡



ÓÃÑùʽ×Ô¶¨Òå·Ö¼¶ÏÔʾÎÞÂÛÊÇÔÚ´´½¨·Ö¼¶ÏÔʾʱ»¹ÊÇ´´½¨ºó£¬¾ù¿É¶ÔÆäÓ¦ÓÃ×Ô¶¯Ñùʽ£¨Ñùʽ£º¡¡

×ÖÌå¡¢×ֺźÍËõ½øµÈ¸ñʽÉèÖÃÌØÐÔµÄ×éºÏ£¬½«ÕâÒ»×éºÏ×÷Ϊ¼¯ºÏ¼ÓÒÔÃüÃûºÍ´æ´¢¡£Ó¦ÓÃÑùʽʱ£¬¡¡

½«Í¬Ê±Ó¦ÓøÃÑùʽÖÐËùÓеĸñʽÉèÖÃÖ¸Áî¡££©¡£¶ÔÓÚ·Ö¼¶ÏÔʾµÄÐУ¬Excel¡¡¡¡Ê¹ÓÃÖîÈç¡¡¡¡

RowLevel_1¡¡¡¡ºÍ¡¡¡¡RowLevel_2¡¡¡¡uses¡¡¡¡ÕâÑùµÄÑùʽ¡£¶ÔÓÚ·Ö¼¶ÏÔʾµÄÁУ¬¡¡Excel¡¡¡¡Ê¹ÓÃÖîÈç¡¡¡¡

ColLevel_1¡¡¡¡ºÍ¡¡ColLevel_2¡£uses¡¡¡¡ÕâÑùµÄÑùʽ¡£ÑùʽʹÓôÖÌ塢бÌå»òÆäËûÎı¾¸ñʽÀ´Çø·ÖÊý¡¡

¾ÝÖеĻã×ÜÐС£Í¨¹ý¸ü¸ÄÕâЩÑùʽµÄ¶¨Ò巽ʽ£¬¿ÉÓ¦Óò»Í¬µÄÎı¾ºÍµ¥Ôª¸ñ¸ñʽÀ´×Ô¶¨Òå·Ö¼¶¡¡

ÐÎʽµÄÍâ¹Û¡£»¹¿ÉʹÓÃ×Ô¶¯Ì×Óøñʽ£¨×Ô¶¯Ì×Óøñʽ£º¿ÉÓ¦ÓÃÓÚÊý¾ÝÇøÓòµÄÄÚÖõ¥Ôª¸ñ¸ñʽ¼¯¡¡

ºÏ£¬ÀýÈ磬×ÖÌå´óС¡¢Í¼°¸ºÍ¶ÔÆ뷽ʽ¡£Excel¡¡¡¡¿Éʶ±ðÑ¡¶¨ÇøÓòµÄ»ã×ÜÊý¾ÝºÍÃ÷ϸÊý¾ÝµÄ¼¶±ð£¬¡¡

È»ºó¶ÔÆäÓ¦ÓÃÏàÓ¦µÄ¸ñʽ¡££©À´ÉèÖ÷ּ¶ÏÔʾÊý¾ÝµÄ¸ñʽ¡£¡¶29¡·ÈçºÎ´òÓ¡ÐбêÁкÅÄØ£¿ÓÖ¡¡

Èç¹ûû´òÓ¡»úÈçºÎÔ¤ÀÀ´òÓ¡£¿¡¡¡¡ÇëÎÊÈçºÎ´òÓ¡ÐбêÁкÅÄØ£¿¡¡»¹ÓУº¿ÉÒÔÕ³Ìù´øÓÐÐбêÁкŵÄͼ¡¡

ƬÂ𣿡¡¡¡¡¡

¡¡¡¶30¡·×Ô¶¯ÌîÂú±àÐòºÅÌî³äÐòºÅÎÊÌâÌî³äÐòºÅÎÊÌâ¡¡Èç¹ûÎÒÓÃ10¡­001À´×÷ÐòºÅ£¬ÓÃÌî³ä¡­¡­¡­ÐòÁС¡

ûÓз´Ó¦£¬Èç¹ûÓÃÌî³ä¡­¡­¡­ÏòÏÂÌî³ä£¬ÔòÈ«ÊÇ10¡­001£»Èç¹ûÓÃ001À´×÷ÐòºÅ£¬Ôò×Ô¶¯°Ñ001±ä³É¡¡

ÁË1£¬Èç¹û°Ñµ¥Ôª¸ñÉè³ÉÎı¾£¬ÔÚÌî³äʱͬÑù³öÏÖÉÏÃæµÄÇé¿ö¡£ÓÐûÓа취À´ÊµÏÖÐòºÅ×Ô¶¯Ìî¡¡

³äµÄ¹ý³Ì¡£1ÉèΪÎı¾Ê±»áÌî³äΪ001¡¡002¡¡003¡¡2¿É¿¼ÂÇ×Ô¶¨ÒåÌî³ä3³ýÁËÌî³ä·½·¨Í⣬»¹¿É¿¼¡¡

Âǹ«Ê½¡¡¡¡

¶Ôì¶10¡­001¡¡¡¡¡¡¡¡



¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡CCXII¡¡¡¡


¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­Page¡¡213¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­

¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡Excel_word_ppt_ʹÓü¼ÇÉ´óÈ«£¨ÍêÈ«°æ£©¡¡¡¡



1¡£ÔÚA1ÊäÈë¡¡10¡­001¡¡¡¡2¡£Ñ¡È¡A1£ºA15¡¡¡¡3¡££§±à¼­£§¡·£§ÌîÂú£§¡¡¡¡4¡£Ñ¡£§ÊýÁУ§¡·£§¡¡×Ô¶¯ÌîÈ룧¡·£§È·¶¨£§¡¡¡¡ÖÁì¶Êä¡¡

Èë001£»±ä³É1¡¡¡¡Äú¿ÉÒÔÓ㧸ñʽ£§¡·£§´¢´æ¸ñ£§¡£¡£¡£Ó㧡¡×Ô¶©£§Îª¡¡000µÄ·½Ê½Íê³Éá᣻×÷·¨Í¬ÉϹ©Äú²Î¿¼£¡¡¡¡¡¡¡

ÁíÒ»¸ö·½·¨~¡¡¡¡ÈôAÀ¸Îª±àºÅ£»BÀ¸ÖÐÓÐ×ÊÁÏ£¨Ò»¶¨ÒªÓÐ×ÊÁÏร¡£©¡¡¡¡ÔòÒà¿ÉÔÚA1¡¡ÖÐÊäÈë10¡­001¡¡¡¡£»áá¿ì¡¡

°´¶þÏÂA1¡¡µÄ£§¿Øµã£§£¨ÓÒϽÇÓÐÒ»¸öºÚµã£»ÓαêÒƹýÈ¥»á±ä³É£«ºÅ£©Ò»ÑùOK£¡¡¡¡¡¹©Äú²Î¿¼£¡¡¡¡¡¡¡

Îҵķ½·¨ºÜ±¿£ºÔÚA1ºÍA2Á½¸ñ·Ö±ðÊäÈë10¡­001ºÍ10¡­002£»È»ºóÑ¡¶¨Á½¸ñÏòÏÂÍÏ£»½á¹ûÒ»Ñù¡£¡¡¡¡ÓÒ¼ü¡¡

µÄ×÷ÓÃÏÈдÉÏ10¡­001£»È»ºóÓÃÊó±êÓÒ¼üÀ­¶¯µ¥Ôª¸ñ£¬Ñ¡Ôñ¡°¡¡ÒÔÐòÁз½Ê½Ìî³ä¡±¾Í¿ÉÒÔÁË¡£¡¡¡¡

¼ÙÉè10¡­001ÔÚA1µ¥Ôª£¬µã»÷A1µ¥Ôª£¬°´×¡Ìî³ä±ú£¬°´ÏÂCRL¼ü£¬ÏòÏÂÀ­¼´¿É¡¡¡¡

Ö±½ÓʹÓÃÌî³ä±ú¾Í¿ÉÒÔʵÏÖ10£­001¡£¡£¡£¡£¡£¡£10£­019¡¡¡¡¡¡¡¡

¡¡¡¶31¡·excelÊý×Ö¸ñʽÕûÊý×î¶à¿É¼ÆË㼸λ£¿Ð¡ÊýÒ²Ò»ÑùÂ𣿡¡excelµÄ15λ¾«¶ÈÊÇָʲô£¿ÊDz»ÊÇ¡¡

˵֧³Ö15λµÄÕûÊý£¿¡¡¡¡ÕâÊÇÊäÈë18λµÄÕûÊýÁí¼Ó5λСÊý123123123123123000¡£00000¡¡¡¡ÕâÊÇÒ»¡¡

¸ö18λµÄСÊý0¡£000000000000003553¡¡¡¡ÊDz»ÊǶÔСÊýλÊýµÄÖ§³ÖÊÇÎÞÏÞµÄÄØ£¿¡¡¡¡¡¡

×î¶à15룬³¬¹ý²¿·Ö¾ùΪ0¡£ÔÚÊäÈ볬¹ý15λµÄÊý¾Ýʱ£¬Ó¦½«µ¥Ôª¸ñÉèÖÃΪÎı¾»òÔÚÊäÈëÊý¾Ý¡¡

Ç°¼Ó¡°'¡±¡¡¡¡0¡£000000000000003553¡¡¡¡¡¡µÄÓÐЧÊý×ÖÖ»ÓÐËÄλÊýÒ²¾ÍÊÇ¡¡3553¡¡¡¡Èô¸ÄÊäÈëΪ¡¡¡¡

0¡£100000000000003553¡¡¡¡ÔòÖ»»áÏÔʾ¡¡0¡£100000000000004000¡¡¡¡´Ó¡¡1¡¡~¡¡4¡¡¡¡¹²15λ¡¡¡¡

ÎÒÊÔÁË£¬¡¡0¡£100000000000003553ÏÔʾµÄÊÇ0¡£100000000000003¡¡¡¡¡¡¡¶32¡·ÈçºÎÔÚµ¥Ôª¸ñÏÂÀ­µÃ¡¡

Ò»µÈ²î»òµÈ±ÈÐòÁУ¿¡¡¡¡Ìî³ä±ú¡¡¡¡



¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡CCXIII¡¡¡¡


¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­Page¡¡214¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­

¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡Excel_word_ppt_ʹÓü¼ÇÉ´óÈ«£¨ÍêÈ«°æ£©¡¡¡¡



ÇëÎÊ£ºÔÚʲôÇé¿öÏ°´×¡Ìî³ä±úÏÂÀ­µÃµ½Ò»¸öÐòÁУ¬Ê²Ã´Ê±ºò»áÊÇÒ»¸ö¿½±´¡£²»Òª¸æËßÎÒ°´×¡¡¡

CTRL¼ü¡£ÄÇÒ²ÊÇÒ»ÑùµÄ¡£ÎÒÊÇ˵£ºÈç¹û¶ÔÓÚAÁв»°´CTRL¼üÏÂÀ­µÃµ½Ò»¸öÐòÁУ¬ÄÇôͬÑùµÄ¡¡

µ½BÁÐʱ¾Í¿ÉÄÜÊÇÒ»¸ö¿½±´¡£Èç¹û°´×¡CTRL¡¡¡¡¼üÔòÏà·´ÕâÓÐʲô¹æÂÉÂ𣿡¡¡¡¡¡

µã»÷ÓÒ¼üÏÂÀ­»á³öÏÖÑ¡¡¡Ïî¡£¡¡¡¡¡¡

ÔÚA1µ¥Ôª¸ñÖÐÊäÈë¡¡1¡¡¡¡£¬ÔÚA2¡¡ÖÐÊäÈë¡¡2£¬Ñ¡ÖÐÕâÁ½¸öµ¥Ôª¸ñ£¬×ó¼ü°´×¡Ìî³ä±úÍùÏÂÍÏ£¬Äã¿´¿´¡¡

ÈçºÎ£¿£¡¡¡¡¡¡¡

¡¡¡¶33¡·£«¡¡¡¡ºÍ¡¡&¡¡¡¡µÄÓ÷¨Îı¾ÐÍÊý×Öʲôʱºò»á±»ÈÏΪÊÇÊýÖµ£¿¡¡=¡¨3¡¨=3¡¡¡¡µÃµ½false¡¡=¡¨3¡¨£«2¡¡¡¡µÃ¡¡

µ½5¡¡=¡¨3¡¨£«¡¨3¡¨¡¡¡¡µÃµ½6¡¡¡¡ÇëÎÊÕâÖÖÀàÐͱ仯ÓÐʲô¹æÂÉÂð¡¡¡¡¡¡

£«¡¡¡¡ÔËËã·û¡¡ÓÃÀ´ÇóÁ½ÊýÖ®ºÍ¡£¡¡Óï·¨¡¡result¡¡=¡¡expression1£«expression2¡¡£«¡¡¡¡ÔËËã·ûµÄÓï·¨¾ßÓС¡

ÒÔϼ¸¸ö²¿·Ö£º¡¡²¿·Ö¡¡ÃèÊ