2017 »á¼Æ¼ÌÐø½ÌÓýÊÔÌâ¼°´ð°¸ ÏÂÔØ±¾ÎÄ

ÄÚÈÝ·¢²¼¸üÐÂʱ¼ä : 2025/11/25 11:10:22ÐÇÆÚÒ» ÏÂÃæÊÇÎÄÕµÄÈ«²¿ÄÚÈÝÇëÈÏÕæÔĶÁ¡£

ÅжÏÌâ ( ËùÊô¿Î³Ì£º´úÀí¼ÇÕ˹ÜÀí°ì·¨ ) Ò³Ê×

1. ´úÀí¼ÇÕË»ú¹¹ÉèÁ¢·ÖÖ§»ú¹¹Ê±£¬Ó¦ÓÉ·ÖÖ§»ú¹¹ÏòËùÔڵصÄÉóÅú»ú¹ØÉêÇëÉè

Á¢¡£

¶Ô A¡¢ ´í B¡¢

ÕýÈ·´ð°¸£ºB

ÅжÏÌâ ( ËùÊô¿Î³Ì£º´úÀí¼ÇÕ˹ÜÀí°ì·¨ ) Ò³Ê×

2. ´úÀí¼ÇÕË»ú¹¹½ÓÊÜίÍÐÈ˶ÔÍâÌṩ²ÆÎñ±¨±íʱ£¬ÐèÒª¾­´úÀí¼ÇÕË»ú¹¹¸ºÔðÈË

ºÍίÍÐÈ˸ºÔðÈËÇ©Ãû²¢¸ÇÕ¡£

¶Ô A¡¢ ´í B¡¢

ÕýÈ·´ð°¸£ºA

ÅжÏÌâ ( ËùÊô¿Î³Ì£ºÍæ×ªEXCELº¯Êý ) Ò³Ê×

3. SUMIFSº¯ÊýµÄ¹¦ÄÜÊǶÔÂú×ã¶àÖÖÌõ¼þµÄÊý¾Ý·ÖÀà»ã×Ü¡£

¶Ô A¡¢ ´í B¡¢

ÕýÈ·´ð°¸£ºA

ÅжÏÌâ ( ËùÊô¿Î³Ì£ºÍæ×ªEXCELº¯Êý ) Ò³Ê× 4. PMTº¯ÊýµÄ¹¦ÄÜÊÇÒÑÖªÏÖÖµ»òÖÕÖµÇóÄê½ð¡£

¶Ô A¡¢ ´í B¡¢

ÕýÈ·´ð°¸£ºA

ÅжÏÌâ ( ËùÊô¿Î³Ì£ºÆóÒµ²ÆÎñ·çÏÕ¹ÜÀí-»ãÂÊ·çÏÕ ) Ò³Ê× 5. Ñ¡ÔñÓÐÀûµÄºÏͬ»õ±ÒÊôÓÚ»ãÂÊ·çÏÕ¹ÜÀíµÄÉÌÒµ·½·¨¡£

¶Ô A¡¢ ´í B¡¢

ÕýÈ·´ð°¸£ºA

ÅжÏÌâ ( ËùÊô¿Î³Ì£ºÆóÒµ²ÆÎñ·çÏÕ¹ÜÀí-»ãÂÊ·çÏÕ ) Ò³Ê×

6. ÿÈÕÒøÐм伴ÆÚÍâ»ãÊг¡ÃÀÔª¶ÔÈËÃñ±Ò½»Ò×¼ÛÔÚÖйúÍâ»ã½»Ò×ÖÐÐĹ«²¼µÄ

ÃÀÔª½»Ò×Öмä¼ÛÉÏÏÂ3%·ù¶ÈÄÚ¸¡¶¯¡£

¶Ô A¡¢ ´í B¡¢

ÕýÈ·´ð°¸£ºB

ÅжÏÌâ ( ËùÊô¿Î³Ì£º¡¶ÖØÇìÊÐ»á¼Æ»ù´¡¹¤×÷¹æ·¶ÊµÊ©Ï¸Ôò¡·½â¶Á ) Ò³Ê× 7. ÔÚ°ìÀí»á¼ÆÒƽ»¹¤×÷ʱ£¬Òƽ»ÈËÔ±Òò²¡»òÕ߯äËûÌØÊâÔ­Òò²»ÄÜÇ××Ô°ìÀíÒÆ½»

µÄ£¬¾­µ¥Î»¸ºÔðÈËÅú×¼£¬¿ÉÓÉÒÆ½»ÈËԱίÍÐËûÈË´ú°ìÒÆ½»£¬Î¯ÍÐÈËÎÞÐè³Ðµ£ÓëÒÆ½»¹¤×÷Ïà¹ØÁªµÄÔðÈΡ£

¶Ô A¡¢ ´í B¡¢

ÕýÈ·´ð°¸£ºB

ÅжÏÌâ ( ËùÊô¿Î³Ì£º¡¶ÖØÇìÊÐ»á¼Æ»ù´¡¹¤×÷¹æ·¶ÊµÊ©Ï¸Ôò¡·½â¶Á ) Ò³Ê× 8. ¹ú¼Ò»ú¹Ø¡¢Éç»áÍÅÌå¡¢ÆóÒµ¡¢ÊÂÒµµ¥Î»¡¢ÆäËû×éÖ¯ºÍ¹«Ãñ¸öÈË£¬¶¼Ó¦µ±ÉèÖÃ

»á¼ÆÕ˲¾£¬½øÐÐ»á¼ÆºËËã¡£

¶Ô A¡¢ ´í B¡¢

ÕýÈ·´ð°¸£ºB

ÅжÏÌâ ( ËùÊô¿Î³Ì£ºÍæ×ªEXCELº¯Êý ) Ò³Ê×

9. LOOKUPº¯ÊýµÄ¹¦ÄÜÊǸù¾ÝijһÊý¾Ý£¬²éÕÒÁíÍâÊý¾Ý¡£

¶Ô A¡¢ ´í B¡¢

ÕýÈ·´ð°¸£ºA

ÅжÏÌâ ( ËùÊô¿Î³Ì£ºÍæ×ªEXCELº¯Êý ) Ò³Ê×

10. SUMIFº¯ÊýµÄ¹¦ÄÜÊǶÔÂú×ãÒ»ÖÖÌõ¼þµÄÊý¾Ý·ÖÀà»ã×Ü¡£

¶Ô A¡¢ ´í B¡¢

ÕýÈ·´ð°¸£ºA

µ¥Ñ¡Ìâ ( ËùÊô¿Î³Ì£º´úÀí¼ÇÕ˹ÜÀí°ì·¨ ) Ò³Ê×

11. ÔÚ¶Ô´úÀí¼ÇÕË»ú¹¹½øÐÐÈÕ³£¼à¶½¹ÜÀíʱ£¬·¢ÏÖ²ÉÈ¡ÆÛÆ­¡¢»ß¸µÈ²»Õýµ±ÊÖ¶Î

È¡µÃ´úÀí¼ÇÕË×ʸñµÄ£¬ÓÉÉóÅú»ú¹Ø×ö³öÒÔÏÂÄÄÖֳʹ¦£¿£¨ £©

ÔðÁîÆäÏÞÆÚ½øÐÐÕý³£³ÌÐòµÇ¼Ç A¡¢

³·ÏúÆä´úÀí¼ÇÕË×ʸñ B¡¢

ÔÝÍ£Æä´úÀí¼ÇÕË×ʸñ²¢ÏÞÆÚÕû¸Ä C¡¢

×¢ÏúÆä´úÀí¼ÇÕË×ʸñ D¡¢

ÕýÈ·´ð°¸£ºB

µ¥Ñ¡Ìâ ( ËùÊô¿Î³Ì£º´úÀí¼ÇÕ˹ÜÀí°ì·¨ ) Ò³Ê×

12. 2015Äê²ÆÕþ²¿ÒÔ80ºÅÁî·¢²¼µÄ¡¶´úÀí¼ÇÕ˹ÜÀí°ì·¨¡·×Ô£¨ £©¿ªÊ¼Ê©ÐС£

2016.1.1 A¡¢

2016.3.1 B¡¢

2016.5.1 C¡¢

2016.7.1 D¡¢

ÕýÈ·´ð°¸£ºC

µ¥Ñ¡Ìâ ( ËùÊô¿Î³Ì£º´úÀí¼ÇÕ˹ÜÀí°ì·¨ ) Ò³Ê×

13. ÏØ¼¶ÒÔÉÏÈËÃñÕþ¸®²ÆÕþ²¿Ãż°Æä¹¤×÷ÈËÔ±ÔÚ´úÀí¼ÇÕË×ʸñ¹ÜÀí¹ý³ÌÖУ¬ÏÂÁÐ

ÄÄÖÖÐÐΪ»á½«ÆäÒÆËÍ˾·¨»ú¹Ø´¦Àí£¿£¨ £©

ÀÄÓÃְȨ A¡¢

ÍæºöÖ°ÊØ B¡¢

áß˽Îè±× C¡¢

ÉæÏÓ·¸×ï D¡¢

ÕýÈ·´ð°¸£ºD

µ¥Ñ¡Ìâ ( ËùÊô¿Î³Ì£ºÍæ×ªEXCELº¯Êý ) Ò³Ê×