²é¿´: 543  |  »Ø¸´: 10
µ±Ç°Ö÷ÌâÒѾ­´æµµ¡£
µ±Ç°Ö»ÏÔʾÂú×ãÖ¸¶¨Ìõ¼þµÄ»ØÌû£¬µã»÷ÕâÀï²é¿´±¾»°ÌâµÄËùÓлØÌû

parklyn

Ìú¸Ëľ³æ (Ö°Òµ×÷¼Ò)

°¢É­Äɶӳ¤

[½»Á÷] excelÀïÊý¾Ý¼ÆËãÎÊÌâ

excelÀïÓÐÒ»ÁÐÊý£¬ÈçºÎ¿ìËÙµÄÇó³öǰnÏîÆ½¾ùÖµ£¬Ç°nÏîµÄ±ê×¼²î£¿±ÈÈç300¸öÊý£¬ÏÖÔÚÒªÇóǰ1£¬2£¬3£¬4£¬5£¬6.¡£¡£¡£300¸öÊýµÄƽ¾ùÖµ¼°±ê×¼²î£¿Ð»Ð»£¡
ÒÑÔÄ   »Ø¸´´ËÂ¥   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû

sinaky

Èô²»»á²åÈëÖ±½ÓÕÒÒ»¸ö¸ñд=AVERAGE(C1:C300)CΪÄãÄÇÁÐÊýµÄÁкż´¿É£¬ÄÇÒ»¸öÒ²Ïàͬ¡£
ÀàËÆµÄһЩͨÓú¯ÊýÄã¿ÉÒԵ㹤¾ßÀ¸¡°²åÈ루I£©¡±À´ÊìϤ¡£
4Â¥2010-03-14 11:54:46
ÒÑÔÄ   »Ø¸´´ËÂ¥   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû
²é¿´È«²¿ 11 ¸ö»Ø´ð

daisiwuxie

½ð³æ (ÕýʽдÊÖ)

parklyn(½ð±Ò+1): 2010-03-14 14:47
ÀÁµÃ˵ÁË£¬¿´Á´½Ó°É£¬
http://www0.ccidnet.com/school/zhuan/excelfunction.htm
2Â¥2010-03-14 11:50:33
ÒÑÔÄ   »Ø¸´´ËÂ¥   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû

sinaky

parklyn(½ð±Ò+1): 2010-03-14 14:48
²åÈëAVERAGE(C1:C300) CΪÁкſÉÇ󯽾ùÖµ£»STDEVP(C1:C300)·µ»Ø±ê×¼²î
3Â¥2010-03-14 11:51:17
ÒÑÔÄ   »Ø¸´´ËÂ¥   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû

parklyn

Ìú¸Ëľ³æ (Ö°Òµ×÷¼Ò)

°¢É­Äɶӳ¤

ÒýÓûØÌû:
Originally posted by sinaky at 2010-03-14 11:51:17:
²åÈëAVERAGE(C1:C300) CΪÁкſÉÇ󯽾ùÖµ£»STDEVP(C1:C300)·µ»Ø±ê×¼²î

ÎÒÊÇÏëÇóͬһÁÐµÄ ±ÈÈçÇó³öǰ3¸ö£¬Äܲ»ÄÜÖ±½ÓÍϳöǰ4£¬5£¬6....n¸öÄØ£¿
5Â¥2010-03-14 12:16:57
ÒÑÔÄ   »Ø¸´´ËÂ¥   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû
×î¾ßÈËÆøÈÈÌûÍÆ¼ö [²é¿´È«²¿] ×÷Õß »Ø/¿´ ×îºó·¢±í
[¿¼ÑÐ] Ò»Ö¾Ô¸Ìì½ò´óѧ»¯Ñ§¹¤ÒÕרҵ£¨081702£©315·ÖÇóµ÷¼Á +8 yangfz 2026-03-17 8/400 2026-03-18 10:43 by yjolah
[¿¼ÑÐ] 297Çóµ÷¼Á +4 Ï·¾«µ¤µ¤µ¤ 2026-03-17 4/200 2026-03-18 09:32 by zhukairuo
[˶²©¼ÒÔ°] ºþ±±¹¤Òµ´óѧ ÉúÃü¿ÆÑ§Ó뽡¿µÑ§Ôº-¿ÎÌâ×éÕÐÊÕ2026¼¶Ê³Æ·/ÉúÎï·½Ïò˶ʿ +3 1ϲ´º8 2026-03-17 5/250 2026-03-17 17:18 by ber´¨cool×Ó
[¿¼ÑÐ] ±¾ÈË¿¼085602 »¯Ñ§¹¤³Ì ר˶ +16 ²»ÖªµÀ½Ðʲô£¡ 2026-03-15 18/900 2026-03-17 17:05 by ruiyingmiao
[¿¼ÑÐ] 085600²ÄÁÏÓ뻯¹¤Çóµ÷¼Á +5 Ð÷ÐÒÓë×Ó 2026-03-17 5/250 2026-03-17 16:40 by laoshidan
[¿¼ÑÐ] Ò»Ö¾Ô¸ËÕÖÝ´óѧ²ÄÁϹ¤³Ì£¨085601£©×¨Ë¶ÓпÆÑо­ÀúÈýÏî¹ú½±Á½¸öʵÓÃÐÍרÀûÒ»ÏîÊ¡¼¶Á¢Ïî +6 ´ó»ðɽС»ðɽ 2026-03-16 8/400 2026-03-17 15:05 by ÎÞи¿É»÷111
[¿¼ÑÐ] 285»¯¹¤Ñ§Ë¶Çóµ÷¼Á£¨081700£© +9 ²ñ¿¤Ã¨_ 2026-03-12 9/450 2026-03-17 10:18 by Sammy2
[¿¼ÑÐ] 278Çóµ÷¼Á +3 Yy7400 2026-03-13 3/150 2026-03-17 08:24 by laoshidan
[¿¼ÑÐ] 11408 Ò»Ö¾Ô¸Î÷µç£¬277·ÖÇóµ÷¼Á +3 zhouzhen654 2026-03-16 3/150 2026-03-17 07:03 by laoshidan
[¿¼ÑÐ] »¯Ñ§µ÷¼Á0703 +8 °¡ÎÒÎÒµÄ 2026-03-11 8/400 2026-03-16 17:23 by ÎҵĴ¬Îҵĺ£
[¿¼ÑÐ] 311Çóµ÷¼Á +5 26ÑÐ0 2026-03-15 5/250 2026-03-16 16:21 by a²»Ò×
[¿¼ÑÐ] 085600µ÷¼Á +5 ÑúÑú123sun 2026-03-12 6/300 2026-03-16 15:58 by ÑúÑú123sun
[¿¼ÑÐ] 070303Ò»Ö¾Ô¸Î÷±±´óѧѧ˶310ÕÒµ÷¼Á +5 dÈçÔ¸Éϰ¶ 2026-03-12 8/400 2026-03-16 15:19 by peike
[¿¼ÑÐ] ²ÄÁÏÓ뻯¹¤Ò»Ö¾Ô¸Äϲý´óѧ327Çóµ÷¼ÁÍÆ¼ö +7 Ncdx123456 2026-03-13 8/400 2026-03-16 12:15 by karry wen
[¿¼ÑÐ] 0703 ÎïÀí»¯Ñ§µ÷¼Á +3 ÎÒ¿ÉÒÔÉϰ¶µÄ¶Ô 2026-03-13 5/250 2026-03-16 10:50 by ÎÒ¿ÉÒÔÉϰ¶µÄ¶ÔÂ
[¿¼ÑÐ] 0856ר˶279Çóµ÷¼Á +5 ¼ÓÓͼÓÓÍ£¡? 2026-03-15 5/250 2026-03-15 11:58 by 2020015
[¿¼ÑÐ] 308 085701 ËÄÁù¼¶ÒѹýÇóµ÷¼Á +7 ÎÂÇÇÇÇÇÇÇÇ 2026-03-12 14/700 2026-03-14 10:49 by JourneyLucky
[¿¼ÑÐ] Çó²ÄÁϵ÷¼Á 085600Ó¢Ò»Êý¶þ×Ü·Ö302 ǰÈý¿Æ235 ¾«Í¨»úÆ÷ѧϰ Ò»Ö¾Ô¸¹þ¹¤´ó +4 ÁÖyaxin 2026-03-12 4/200 2026-03-13 22:04 by ÐÇ¿ÕÐÇÔÂ
[¿¼ÑÐ] ²ÄÁÏ301·ÖÇóµ÷¼Á +5 Liyouyumairs 2026-03-12 5/250 2026-03-13 14:42 by JourneyLucky
[¿¼ÑÐ] 333Çóµ÷¼Á +3 152697 2026-03-12 4/200 2026-03-13 07:08 by Iveryant
ÐÅÏ¢Ìáʾ
ÇëÌî´¦ÀíÒâ¼û