ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

[¤À¨É] Excel ªº³W®æ¤Î­­¨î(ºK¿ý¦ÛExcel »¡©ú)

[¤À¨É] Excel ªº³W®æ¤Î­­¨î(ºK¿ý¦ÛExcel »¡©ú)

¥»©«³Ì«á¥Ñ Hsieh ©ó 2011-5-10 00:02 ½s¿è

Excel ªº³W®æ¤Î­­¨î(ºK¿ý¦ÛExcel »¡©ú)
« ©ó: 2009-02-21, 16:08:22 »      

--------------------------------------------------------------------------------
Excel2003 ªº³W®æ¤Î­­¨î¡@

¤u§@ªí©M¬¡­¶Ã¯³W®æ

¯S©Ê ³Ì¤j­­¨î
¶}±Ò¬¡­¶Ã¯ ¨ü­­©ó¥i¥Îªº°O¾ÐÅé©M¨t²Î¸ê·½
¤u§@ªí¤j¤p 65,536 ¦C * 256 Äæ
Äæ¼e 255 ­Ó¦r¤¸
¦C°ª 409 ­ÓÂI¼Æ
¤À­¶½u 1000 ±ø¤ô¥­¤Î««ª½½u
Àx¦s®æ¤º®eªºªø«× (¤å¦r) 32,767 ­Ó¦r¤¸¡C¦b¤@­ÓÀx¦s®æ¤¤¶È¯àÅã¥Ü1,024 ­Ó¦r¤¸¡F¦b¸ê®Æ½s¿è¦CÅã¥Ü¥þ³¡ 32,767 ­Ó¦r¤¸¡C
¬¡­¶Ã¯¤¤À˵ø­Ó¼Æ ¨ü­­©ó¥i¥Îªº°O¾ÐÅé (¹w³]­È¬O 3 ­Ó¤u§@ªí)
¬¡­¶Ã¯¤¤ªº¦â±m­Ó¼Æ 56
¬¡­¶Ã¯¤¤Àx¦s®æ¼Ë¦¡­Ó¼Æ 4,000
¬¡­¶Ã¯¤¤¨ã¦WªºÀ˵øªí (À˵øªí¡G¥i©R¦W¤Î®M¥Î¦Ü¬¡­¶Ã¯ªº¤@²ÕÅã¥Ü¤Î¦C¦L³]©w¡C±z¥i¥H«Ø¥ß¤@­Ó¬¡­¶Ã¯ªº¦h­ÓÀ˵øªí¡A¦ÓµL»ÝÀx¦s¬¡­¶Ã¯ªº­Ó§O½Æ¥»¡C)­Ó¼Æ ¨ü­­©ó¥i¥Îªº°O¾ÐÅé
¦Û­q¼Æ¦r®æ¦¡ ¤¶©ó 200 ©M 250 ¤§¶¡ (®Ú¾Ú±z¦w¸Ëªº Excel »y¨¥ª©¥»¦Ó©w)¡C
¦b¬¡­¶Ã¯¤¤ªº¦WºÙ ¨ü­­©ó¥i¥Îªº°O¾ÐÅé
¦b¬¡­¶Ã¯¤¤ªºµøµ¡ ¨ü­­©ó¨t²Î¸ê·½
¦bµøµ¡¤¤ªºµ¡®æ 4
³sµ²¤u§@ªí ¨ü­­©ó¥i¥Îªº°O¾ÐÅé
¤ÀªRÂÅ¥» (¤ÀªRÂÅ¥»¡G¤u§@ªí¼Ò«¬¤¤¥i¨ú¥Nªº¤@²Õ¤w©R¦Wªº¿é¤J­È¡C) ¨ü­­©ó¥i¥Îªº°O¾ÐÅé¡F¤@­ÓºK­n³øªí¥u¯àÅã¥Ü«e 251 ­Ó¤ÀªRÂÅ¥»
¦b¤ÀªRÂÅ¥»¤¤ÅܧóÀx¦s®æ 32
½Õ¾ãÂk¹º¨D¸ÑªºÀx¦s®æ 200
¦Û­q¨ç¼Æ ¨ü­­©ó¥i¥Îªº°O¾ÐÅé
Åã¥Ü¤ñ¨Ò½d³ò 10 % ¨ì 400 %
³øªí ¨ü­­©ó¥i¥Îªº°O¾ÐÅé
°Ñ·Ó±Æ§Ç ¦b³æ¤@±Æ§Ç¤¤¬° 3¡F­Y¬O¨Ï¥Î´`§Ç±Æ§Ç«hµL­­¨î
Á٭춥¼h 16
¦b¸ê®Æªí³æ¤¤ªºÄæ¦ì 32
¦b¬¡­¶Ã¯¤¤¦Û­q¤u¨ã¦C ¨ü­­©ó¥i¥Îªº°O¾ÐÅé
¦Û­q¤u¨ã ¨ü­­©ó¥i¥Îªº°O¾ÐÅé

¤u§@¸s²Õ³W®æ

¯S©Ê ³Ì¤j­­¨î
¨Ï¥ÎªÌ¥i¦b¦P¤@®É¶¡¤º¶}±Ò¤Î¦@¥Î¤@­Ó¦@¥Î¬¡­¶Ã¯ (¦@¥Î¬¡­¶Ã¯¡G¬°¤¹³\ºô¸ô¤Wªº¦h¦ì¨Ï¥ÎªÌ¦P®ÉÀ˵ø¤Î¶i¦æÅܧó¦Ó³]©wªº¬¡­¶Ã¯¡CÀx¦s¬¡­¶Ã¯ªº¨C¦ì¨Ï¥ÎªÌ§¡¥i¬d¬Ý¨ä¥L¨Ï¥ÎªÌ©Ò°µªºÅܧó¡C)¡C 256
¦@¥Î¬¡­¶Ã¯¤¤­Ó¤HªºÀ˵øªí (À˵øªí¡G¥i©R¦W¤Î®M¥Î¦Ü¬¡­¶Ã¯ªº¤@²ÕÅã¥Ü¤Î¦C¦L³]©w¡C±z¥i¥H«Ø¥ß¤@­Ó¬¡­¶Ã¯ªº¦h­ÓÀ˵øªí¡A¦ÓµL»ÝÀx¦s¬¡­¶Ã¯ªº­Ó§O½Æ¥»¡C)­Ó¼Æ ¨ü­­©ó¥i¥Îªº°O¾ÐÅé
«O¦sÅܧó¾úµ{°O¿ý (Åܧó¾úµ{°O¿ý¡G¦@¥Î¬¡­¶Ã¯¤¤«O¦s¤§¹L¥h½s¿è§@·~¤¤©Ò§@Åܧ󪺬ÛÃö¸ê°T¡C¦¹Ãþ¸ê°T¥]¬A¶i¦æÅܧ󪺤H­û©m¦W¡BÅܧ󪺮ɶ¡¡A¥H¤ÎÅܧ󪺸ê®Æ¤º®e¡C)ªº¤Ñ¼Æ 32,767 (¹w³]­È¬° 30 ¤é)
¤@¦¸¥i¦X¨Öªº¬¡­¶Ã¯­Ó¼Æ ¨ü­­©ó¥i¥Îªº°O¾ÐÅé
¦b¦@¥Î¬¡­¶Ã¯¤¤ªºÀx¦s®æ·|³Q¼Ð¥Ü¥X¨Ó 32,767
·íÅܧó¤Ï¥Õ´£¥Ü³Q¶}±Ò®É¡A¥i¥Î¨ÓÃѧO¤£¦P¨Ï¥ÎªÌ©Ò°µ­×§ïªº¦â±m­Ó¼Æ¡C 32 (¨C­Ó¨Ï¥ÎªÌ¬O¥H¤£¦Pªº¦â±m¨Ó¥Nªí¡F¥Ø«e¨Ï¥ÎªÌ©Ò°µªºÅܧó¬O¥H²`ÂŦâ¨Ó¼Ð¥Ü)

­pºâ³W®æ

¯S©Ê ³Ì¤j­­¨î
¼Æ¦rºë½T«× 15 ¦ì¼Æ
Àx¦s®æ¤¤¤¹³\¿é¤Jªº³Ì¤j­È 9.99999999999999E+307
³Ì¤jªº¥i®e³\¥¿¼Æ 1.79769313486231E+308
³Ì¤pªº¥i®e³\­t¼Æ -2.2251E-308
³Ì¤pªº¥i®e³\¥¿¼Æ 2.229E-308
³Ì¤jªº¥i®e³\­t¼Æ -1E-307
¤½¦¡¤º®eªºªø«× 1,024 ­Ó¦r¤¸
¤Ï½Æ¹Bºâ 32,767
¤u§@ªí°}¦C ¦]¨ü­­©ó¥i¥Î°O¾ÐÅé¡A©Ò¥H¡A°}¦C¤£¥i¥H¬O¾ã­ÓÄæ¡C¨Ò¦p¡A¤@­Ó°}¦C¤£¯à¬O¥þ³¡ªº C:C Äæ©ÎªÌ¬O¨ì C1:C65536 ªº½d³ò¡C¤£¹L¡A°}¦Cªº½d³ò¥i¥H¬O C1:D65535¡A¦]¬°¦¹½d³ò¬O¤u¥óªí¤j¤p¤§³Ì¤j­Èªº¦C¡A¦ý¨Ã¤£¥]¬A¾ã­Ó C ©Î D Äæ¡C
¿ï¨ú½d³ò 2,048
¦b¨ç¼Æ¤¤ªº¤Þ¼Æ 30
¨ç¼Æªº±_ª¬¶¥¼h 7
¤u§@ªí¨ç¼Æªº¥i¥Î¼Æ¥Ø 329
­pºâ¥i®e³\ªº³Ì¦­¤é´Á January 1, 1900 (¦pªG¨Ï¥Î 1904 ªº¤é´Á¨t²Îªº¸Ü¡A«h¬° January 1, 1904)
­pºâ¥i®e³\ªº³Ì±ß¤é´Á December 31, 9999
¥i¥H¿é¤Jªº³Ì¤j®É¶¡­È 9999:59:59

¼Ï¯Ã¤ÀªRªí³W®æ

¯S©Ê ³Ì¤j­­¨î
¤u§@ªí¤¤ªº¼Ï¯Ã¤ÀªRªí (¼Ï¯Ã¤ÀªRªí¡G±q¤£¦P¨Ó·½ (¥]§t Excel ªº¥~³¡¨Ó·½) ºK­n¤Î¤ÀªR¸ê®Æ (¦p¸ê®Æ®w°O¿ý) ªº¤¬°Ê¦¡¡B¸óªí®æªº Excel ³øªí¡C)­Ó¼Æ ¨ü­­©ó¥i¥Îªº°O¾ÐÅé
¨C­ÓÄæ¦ì°ß¤@ªº¶µ¥Ø 32,500
¼Ï¯Ã¤ÀªRªí³øªí¤¤ªº¦CÄæ¦ì (¦CÄæ¦ì¡G¼Ï¯Ã¤ÀªRªí¤¤«ü©w¤F¦C¤è¦VªºÄæ¦ì¡C»P¦CÄæ¦ìÃöÁpªº¶µ¥Ø·|Åã¥Ü¬°¦C¼ÐÅÒ¡C)©ÎÄæÄæ¦ì (ÄæÄæ¦ì¡G¼Ï¯Ã¤ÀªRªí¤¤«ü©w¤FÄæ¤è¦VªºÄæ¦ì¡C»PÄæÄæ¦ìÃöÁpªº¶µ¥Ø·|Åã¥Ü¬°Äæ¼ÐÅÒ¡C)­Ó¼Æ ¨ü­­©ó¥i¥Îªº°O¾ÐÅé
¼Ï¯Ã¤ÀªRªí³øªí¤¤ªº¤À­¶Äæ¦ì (¤À­¶Äæ¦ì¡G¼Ï¯Ã¤ÀªRªí©Î¼Ï¯Ã¤ÀªR¹Ï¤¤«ü©wµ¹¤À­¶¤è¦VªºÄæ¦ì¡C±z¥i¥H¦b¤À­¶Äæ¦ì¤¤Åã¥Ü©Ò¦³¶µ¥ØªººK­n¡A©Î¤@¦¸Åã¥Ü¤@­Ó¶µ¥Ø¡A³o¼Ë´N·|¿z¿ï¥X©Ò¦³¨ä¥L¶µ¥Øªº¸ê®Æ¡C)­Ó¼Æ 256 (¥i¯à·|¨ü­­©ó¥i¥Îªº°O¾ÐÅé)
¼Ï¯Ã¤ÀªRªí³øªí¤¤ªº¸ê®ÆÄæ¦ì (¸ê®ÆÄæ¦ì¡G¥]§t¼Ï¯Ã¤ÀªRªí©Î¼Ï¯Ã¤ÀªR¹Ï¤¤©Ò·JÁ`¤§¸ê®Æªº¨Ó·½²M³æ¡B¸ê®Æªí©Î¸ê®Æ®w¤ºªºÄæ¦ì¡C¸ê®ÆÄæ¦ì³q±`¥]§t²Î­p¸ê®Æ©Î¾P°â¶q¤§Ãþªº¼Æ­È¸ê®Æ¡C)ªº­Ó¼Æ 256
¼Ï¯Ã¤ÀªRªí³øªí¤¤ªº­pºâ¶µ¥Ø (­pºâ¶µ¥Ø¡G¼Ï¯Ã¤ÀªRªíÄæ¦ì©Î¼Ï¯Ã¤ÀªR¹ÏÄæ¦ì¤¤¨Ï¥Î±z«Ø¥ß¤§¤½¦¡ªº¶µ¥Ø¡C­pºâ¶µ¥Ø¥iÂǥѨϥμϯäÀªRªí©Î¼Ï¯Ã¤ÀªR¹Ï¤§¬Û¦PÄæ¦ì¤¤ªº¨ä¥L¶µ¥Ø¤º®e¨Ó°õ¦æ­pºâ¡C)¤½¦¡ªº­Ó¼Æ ¨ü­­©ó¥i¥Îªº°O¾ÐÅé

¹Ïªí³W®æ

¯S©Ê ³Ì¤j­­¨î
¹Ïªí³sµ²¨ì¤u§@ªí ¨ü­­©ó¥i¥Îªº°O¾ÐÅé
¤@­Ó¹Ïªí©Ò¯à°Ñ·Óªº¤u§@ªí 255
¤@­Ó¹Ïªí¤¤ªº¸ê®Æ¼Æ¦C (¸ê®Æ¼Æ¦C¡G¹Ïªí¤¤Ã¸»sªº¬ÛÃö¸ê®ÆÂI¡C¹Ïªí¤¤ªº¨C­Ó¸ê®Æ¼Æ¦C³£¦³°ß¤@ªº¦â±m©Î¹Ï¼Ë¡A¨Ã¥H¹Ïªí¹Ï¨Òªí¥Ü¡C±z¥i¥H¦b¹Ïªí¤¤Ã¸»s¤@©Î¦h­Ó¸ê®Æ¼Æ¦C¡C¶ê§Î¹Ï¥u¦³¤@­Ó¸ê®Æ¼Æ¦C¡C)ªº­Ó¼Æ 255
¥­­±¹Ïªí¨ä¸ê®Æ¼Æ¦C¤¤¸ê®ÆÂI (¸ê®ÆÂI¡Gø»s¦b¹Ïªí¤Wªº­Ó§O­È¡C¬ÛÃö¸ê®ÆÂI²Õ¦¨¸ê®Æ¼Æ¦C¡C¸ê®ÆÂI¥Ñ¾î±ø¡BÄæ¡B½u¡B®°°Ï¡BÂI¤Î¨ä¥L¹Ï®×¨Óªí¥Ü¡C³o¨Ç¹Ï®×ºÙ§@¸ê®Æ¼Ð°O¡C)ªº­Ó¼Æ 32,000
¸ê®Æ¼Æ¦C¤¤¥ßÅé¹Ïªíªº¸ê®ÆÂI­Ó¼Æ 4,000
¤@­Ó¹Ïªí¤¤©Ò¦³¸ê®Æ¼Æ¦Cªº¸ê®ÆÂI­Ó¼Æ 256,000
½u±ø¼Ë¦¡ 8
½u±øÂI¼Æ 4
°Ï°ì¹Ï¼Ë (¿Ã¹õÅã¥Ü) 18
Á`¦@°Ï°ì¹Ï¼Ë©M¦â±m²Õ¦X (±m¦âÅã¥Ü) 56,448
¹Ï¼Ë©M¦â±m²Õ¦X (±m¦â¦C¦L) 56,448 (¹ê»Úªº­Ó¼Æ·|¦]¬°¦Lªí¾÷©M¥¦ªº³nÅ骺®t²§¦Ó¦³©Ò¤£¦P)
¼Ï¯Ã¤ÀªR¹Ï (¼Ï¯Ã¤ÀªR¹Ï¡G´£¨Ñ¸ê®Æ¤¬°Ê¦¡¤ÀªRªº¹Ïªí¡A»P¼Ï¯Ã¤ÀªRªíÃþ¦ü¡C±z¥i¥HÅܧó¸ê®ÆªºÀ˵ø¡A¬d¬Ý¤£¦P¼h¦¸ªº²Ó¸`¡A©Î¬O©ì¦²Äæ¦ì¤ÎÅã¥Ü©ÎÁôÂÃÄæ¦ì¤¤ªº¶µ¥Ø¡A¨Ó­«·s²Õ´¹Ïªíª©­±°t¸m¡C)¤¤ªº¤À­¶Äæ¦ì (¤À­¶Äæ¦ì¡G¼Ï¯Ã¤ÀªRªí©Î¼Ï¯Ã¤ÀªR¹Ï¤¤«ü©wµ¹¤À­¶¤è¦VªºÄæ¦ì¡C±z¥i¥H¦b¤À­¶Äæ¦ì¤¤Åã¥Ü©Ò¦³¶µ¥ØªººK­n¡A©Î¤@¦¸Åã¥Ü¤@­Ó¶µ¥Ø¡A³o¼Ë´N·|¿z¿ï¥X©Ò¦³¨ä¥L¶µ¥Øªº¸ê®Æ¡C)­Ó¼Æ 256 (¥i¯à·|¨ü­­©ó¥i¥Îªº°O¾ÐÅé)
¼Ï¯Ã¤ÀªRªí³øªí¤¤ªº¸ê®ÆÄæ¦ì (¸ê®ÆÄæ¦ì¡G¥]§t¼Ï¯Ã¤ÀªRªí©Î¼Ï¯Ã¤ÀªR¹Ï¤¤©Ò·JÁ`¤§¸ê®Æªº¨Ó·½²M³æ¡B¸ê®Æªí©Î¸ê®Æ®w¤ºªºÄæ¦ì¡C¸ê®ÆÄæ¦ì³q±`¥]§t²Î­p¸ê®Æ©Î¾P°â¶q¤§Ãþªº¼Æ­È¸ê®Æ¡C)­Ó¼Æ 256
¦b¼Ï¯Ã¤ÀªR¹Ï¤¤­pºâ¶µ¥Ø¤½¦¡ ¨ü­­©ó¥i¥Îªº°O¾ÐÅé

¶â!³q±`¨Ï¥ÎªÌ³£·|¦³³oÃþªº°ÝÃD¡AÁÂÁª©¥D·J¾ã³o¨Ç¬ÛÃöªº°T®§¤è«K§Ú­Ì¦^¾Ð¡A­Ë¬O¦³¤@ÂI¤£©ú¥Õªº¬Oexcel 2007¨Ï¥Îªº©w¸q­­«×§ó¼s¤F¡A¥i¬O¬°¦ó±N2003ªºÀÉ®×Âà¤J°õ¦æ¥¨¶°´N¬O·|¤ñ¸ûºC©O?

TOP

¦¬¨ì¡A¦ý¤£¾å±ooffice»P2003ª©®t²§¦h¤Ö??¥Ø«e¥Î¤F2007ª©Ä±±oÁÙok©Ò¥H¤£¥´ºâ´«¦^2003ª©¤F

TOP

§Ú¦³¸Õ¹L°}¦C¥Î¾ãÄæ.¶]°_¨Ó´X¥G§Ö·í¾÷
mytea

TOP

¦^´_ 3# yuch8663


    ¨ä¹ê¦U¦ì¥i¯à¹ï³o¨Ç­­¨î¦³©Ò»~¸Ñ
·íµM³o¨Ç­­¨î¬O2003ª©¥H«eªºª©¥»
¦VÄæ¦C¼Æ2007´N¼W¥[¤F«Ü¦hÄæ¦C
³o¨Ç­­¨î¬OÅý¦U¦ì¦b¤½¦¡¹Bºâ©Îµ{¦¡³]­p®Éªº°Ñ¦Ò­È
¥L¸ò°õ¦æ®Ä²v¬O¨SÃö«Yªº
¦U¦ì¦³¿³½ìªº¸Ü¥i¥H¥h´ú¸Õ¬Ý¬Ý
2003¶}±ÒªÅ¥Õ¬¡­¶Ã¯©Ò¥Îªº¹q¸£¸ê·½¨ì©³¦h¤Ö
2007¶}±ÒªÅ¥Õ¬¡­¶Ã¯©Ò¥Îªº¹q¸£¸ê·½¨ì©³¦h¤Ö
(¦P¤@§@·~¨t²ÎCPU¨Ï¥Î²v©M°O¾ÐÅé¨Ï¥Î¶q)
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

±q¨Ó¨S¦³·Q¨ìÁÙ¦³³o¼Ë  ¤@¯ë³£¨S¦³¨Ï¥Î³o»ò¦h ¥H¬°¥i¥H¤@ª½µL­­¨îªº  ¦¬Ã¬»á¦h

TOP

¨ä¹ê¤@¯ë§Ú¦Û¤v¶]excel¦pªG¸ê®ÆªºÄæ¼Æ¶W¹L¬ù3000¦h¶]°_¨Ó´N·|¦³ÂI¹y¾·ªº¡A·íµM³o¸òµwÅéÁÙ¬O¦³«Ü¤jªºÃö«Y¡A¥u¬O¯Â´NExcel¨Ó»¡¡A¸ê®Æ¶q¤jªº®É­Ô°õ¦æ°_¨ÓÁÙ¬O·|¹y¡C

TOP

¨º¸U¤@¶W¥X65,536¦C«ç»ò¿ì¡H
80 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

TOP

        ÀR«ä¦Û¦b : ¤f»¡¦n¸Ü¡B¤ß·Q¦n·N¡B¨­¦æ¦n¨Æ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD