- ©«¤l
- 4901
- ¥DÃD
- 44
- ºëµØ
- 24
- ¿n¤À
- 4916
- ÂI¦W
- 105
- §@·~¨t²Î
- Windows 7
- ³nÅ骩¥»
- Office 20xx
- ¾\ŪÅv
- 150
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥x¥_
- µù¥U®É¶¡
- 2010-4-30
- ³Ì«áµn¿ý
- 2024-5-7
|
[¤À¨É] 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¤@ÓºKn³øªí¥u¯àÅã¥Ü«e 251 Ó¤ÀªRÂÅ¥»
¦b¤ÀªRÂÅ¥»¤¤ÅܧóÀx¦s®æ 32
½Õ¾ãÂk¹º¨D¸ÑªºÀx¦s®æ 200
¦Ûq¨ç¼Æ ¨ü©ó¥i¥Îªº°O¾ÐÅé
Åã¥Ü¤ñ¨Ò½d³ò 10 % ¨ì 400 %
³øªí ¨ü©ó¥i¥Îªº°O¾ÐÅé
°Ñ·Ó±Æ§Ç ¦b³æ¤@±Æ§Ç¤¤¬° 3¡FY¬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 ªº¥~³¡¨Ó·½) ºKn¤Î¤Àª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¤À¶Äæ¦ì¤¤Åã¥Ü©Ò¦³¶µ¥ØªººKn¡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«Ø¥ß¤§¤½¦¡ªº¶µ¥Ø¡Cpºâ¶µ¥Ø¥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¤À¶Äæ¦ì¤¤Åã¥Ü©Ò¦³¶µ¥ØªººKn¡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¾ÐÅé |
|