Excel½Ì³ÌÏÂÔØºÍÈí¼þÏÂÔØÖÐÐÄ£¬Microsoft¼¼ÊõÉçÇøÁªÃ˳ÉÔ±£¬È«Çò¼«¾ßÓ°ÏìÁ¦µÄExcelÃÅ»§£¬Office¼¼ÊõÅàѵÉçÇø

Word±í¸ñÖеÄÊý¾Ý´¦Àí¼¼ÇÉ

2019-01-06  ×÷Õß:ExcelHome  ÔĶÁ:´Î
´ó¼Ò¶¼ÖªµÀ£¬ExcelµÄÊý¾Ý´¦Àí¹¦ÄÜÄÇÊǷdz£µÄÇ¿´ó£¬Ê²Ã´ÅÅÐò¡¢É¸Ñ¡¡¢·ÖÀàͳ¼Æ¶¼²»ÔÚ»°Ï£¬º¯Êý¹«Ê½¡¢Í¸ÊÓ±íµÈ¹¦ÄܸüÊÇÈÃÈËÉñÍù£¡¿ÉÊÇ£¬Ð´±¨¸æÊ±£¬ÎÒ½«Êý¾Ý±í¸ñÒѾ­Â¼Èëµ½WordÖÐÁË£¬ÔÙ½«±í¸ñŪµ½ExcelÖд¦ÀíÓеãÌ«Âé·³£¬ÔÚWordÖпÉÒÔ¶Ô±í¸ñÊý¾Ý½øÐмòµ¥µÄ´¦Àíô£¿

01 Word±í¸ñÊý¾ÝÅÅÐò
ÈçÏÂͼ£¬ÔÚÎĵµÖÐÁгöÁËÒ»¸öÉÌÆ·ÏúÊÛͳ¼Æ±í¸ñ£¬·¢ÏÖÏúÊÛ¶îδÅÅÐò£¬ÏÖÔÚÏë¶Ô±í¸ñÒÔÏúÊÛ¶î´Ó´óµ½Ð¡½µÐòÅÅÁÐÉÌÆ·£¬ÔÚWordÖÐÓ¦¸ÃÔõô×ö£¿

²Ù×÷²½Ö裺
Ñ¡ÖÐÕû¸ö±í¸ñ£¬µ¥»÷¡¾±í¸ñ¹¤¾ß¡¿-¡¾²¼¾Ö¡¿-¡¾ÅÅÐò¡¿ÃüÁ

ÔÚµ¯³öµÄ¡¾ÅÅÐò¡¿¶Ô»°¿òÖУ¬½«“ÏúÊÛ¶î”ÉèÖÃΪÖ÷Òª¹Ø¼ü×Ö£¬ÅÅÐòÀàÐÍΪ“Êý×Ö”£¬ÅÅÐò·½Ê½Îª½µÐò£º

ÔÚWordÖУ¬¿ÉÒÔ°´±Ê»®¡¢Êý×Ö¡¢ÈÕÆÚºÍÆ´ÒôµÈËÄÖÖ²»Í¬ÀàÐͽøÐÐÅÅÐò£»×î¶à¿ÉÒÔÉèÖÃ3¸ö¹Ø¼ü×Ö¡£±¾Àý×îºóÅÅÐòЧ¹ûÈçÏÂͼ£º


02 Word±í¸ñÖеē¹«Ê½”
»¹ÊǸղŵÄÉÌÆ·ÏúÊÛ±í£¬ÏÖÔÚÏëÔö¼ÓÒ»¸ö“ÀûÈó”ÁУ¬¼ÙÉèÀûÈóÂʰ´5%À´¼ÆË㣬ÄÇÿÖÖÉÌÆ·µÄÀûÈó¾ÍÊÇ£ºÏúÊÛ¶î*5%£¬¼ÈÈ»Êý¾ÝÒѾ­ÔÚWordÖÐÁË£¬ÏñÕâÑùµÄ¼òµ¥¼ÆËã¾ÍûÓбØÒªÔÙÂé·³Excel»ò¼ÆËãÆ÷À²£¡

Ê×ÏÈ£¬ÎÒÃÇÐèÒªÏÈÀ´Á˽âÒ»ÏÂWord±í¸ñµÄÃüÃû¹æÔò£¬Æäʵ£¬ÔÚWordÖУ¬±í¸ñÖеÄÿһ¸öµ¥Ôª¸ñ£¬Í¬Ñù¿ÉÒÔÏñÔÚExcelÖÐÄÇÑùÓÃÁбê¼ÓÐкŵķ½Ê½À´±íʾ£¬±ÈÈçµÚÒ»ÁеÚ1ÐеēÐòºÅ”Õâ¸öµ¥Ôª¸ñ£¬¿ÉÒÔÀí½âΪA1µ¥Ôª¸ñ£º

ÐèҪעÒâµÄÊÇ£¬Èç¹û±í¸ñÖдæÔںϲ¢µ¥Ôª¸ñ£¬ÄÇÕâ¸öºÏ²¢µ¥Ôª¸ñ»áÒԺϲ¢Ç°µÄµ¥Ôª¸ñÇøÓòµÄ×óÉϽǵ¥Ôª¸ñµÄλÖÃÀ´±íʾ¡£
ºÃ£¬ÓÐÕâ¸ö֪ʶ×öÆÌµæ£¬ÏÖÔھͿÉÒÔÖ±½ÓÔÚWord±í¸ñÖÐÀ´ÊäÈ롾¹«Ê½¡¿À²£¡
½«¹â±ê¶¨Î»µ½ÇÛ²ËÐеÄÀûÈóµ¥Ôª¸ñ£¬µ¥»÷¡¾±í¸ñ¹¤¾ß¡¿-¡¾²¼¾Ö¡¿Ñ¡ÏÖеġ¾¹«Ê½¡¿ÃüÁµ¯³ö¹«Ê½¶Ô»°¿ò£º

ÔÚ¡¾¹«Ê½¡¿Îı¾¿òÖÐÊäÈë“D2*0.05”£¬µ¥»÷È·¶¨£¬¸ÃÉÌÆ·µÄÀûÈóÖµ¼´±»×Ô¶¯¼ÆËã³öÀ´¡£ÓÉÓÚWord±í¸ñÖе¥Ôª¸ñµÄ±íʾ·½Ê½Ê¼ÖÕΪ¾ø¶ÔÒýÓã¬Òò´ËÐèÒª¶ÔÆäËûµ¥Ôª¸ñÖð¸öÊäÈë»òÅúÁ¿Õ³ÌùºóÔÙÖð¸öÐ޸ġ£
½«µÚ1ÐеÄÀûÈóֵѡÖи´ÖÆ£¬²¢Õ³Ìùµ½ÏÂÃæµÄ¿Õµ¥Ôª¸ñÖУº

°´Ï¡¾Alt+F9¡¿½«¹«Ê½×ªÎªÓò´úÂëÐÎʽ£¬½«ÆäÖеēD2”°´Î»ÖÃÐòÁÐÒÀ´Î×÷Ð޸ģº

ÐÞ¸ÄÍê³Éºó£¬ÔÙ°´¡¾Alt+F9¡¿×éºÏ¼ü½«Óò´úÂëת»»ÎªÏÔʾ½á¹û£¬Íê³É¼ÆË㣬Èç¹û¼ÆËã½á¹ûûÓб仯£¬ÇëÑ¡ÖиÃÁУ¬Ö±½Ó°´¡¾F9¡¿Ë¢Ð£º


03 Word±í¸ñÖеĺ¯Êý
Word±í¸ñ²»½ö¿ÉÒÔÊäÈë¼òµ¥µÄ¹«Ê½£¬»¹¿ÉÒÔʹÓó£Óõĺ¯Êý¶ÔÊý¾Ý½øÐÐͳ¼Æ£¬±ÈÈ磬ÏÖÔÚÒª¶ÔÉϱíÖеÄÏúÊÛ¶îºÍÀûÈó¶î½øÐлã×Ü£¬¿ÉÒÔÕâÑù×ö£º

¶¨Î»Ã´ÏúÊÛ¶îÒ»¶¨×îÏÂÃæµÄ¿Õ°×µ¥Ôª¸ñ£¬µ¥»÷¡¾±í¸ñ¹¤¾ß¡¿-¡¾²¼¾Ö¡¿Ñ¡ÏÖеġ¾¹«Ê½¡¿ÃüÁµ¯³ö¹«Ê½¶Ô»°¿ò£º

ÔÚ¡¾Õ³Ìùº¯Êý¡¿ÏÂÀ­ÁбíÖÐÑ¡ÔñSUMº¯Êý£¬Ôٻص½¡¾¹«Ê½¡¿Îı¾¿òÖУ¬ÊäÈë²ÎÊý“ABOVE”£¬µ¥»÷¡¾È·¶¨¡¿ÃüÁî°´Å¥£¬¼´¿ÉµÃµ½ÏúÊÛ¶îµÄ»ã×ܽá¹û¡£
¸´ÖÆÏúÊÛ¶î»ã×ܽá¹û£¬Õ³Ìùµ½ÀûÈó»ã×ܵ¥Ôª¸ñ£¬Ö±½Ó°´¡¾F9¡¿Ë¢Ð¼´¿ÉµÃµ½ÀûÈó»ã×Ü¡£ÕâÊÇÎªÊ²Ã´ÄØ£¿

ϸÐĵÄС»ï°é¿Ï¶¨·¢ÏÖÁË£¬ÕâÀïµÄSUMº¯ÊýʹÓõÄÊÇABOVE²ÎÊý£¬¶ø²»Êǵ¥Ôª¸ñÒýÓá£ABOVE±í´ïµÄº¬ÒåÊǶԵ±Ç°µ¥Ôª¸ñÉÏ·½µÄ°üº¬Êý×ÖµÄÁ¬Ðøµ¥Ôª¸ñ½øÐÐͳ¼Æ£¬Òò´Ë£¬½«´Ë¹«Ê½¸´ÖƵ½ÆäËûµ¥Ôª¸ñºó£¬Ö±½ÓF9ˢоͿÉÒԵõ½ÕýÈ·µÄͳ¼Æ½á¹û¡£
×îºó£¬ÐèҪ˵Ã÷µÄÊÇ£¬³ýÁËSUMº¯ÊýÍ⣬Word»¹¿ÉÒÔʹÓÃAVERAGE¡¢COUNT¡¢MAX¡¢MINµÈº¯Êý£¬´ó¼Ò¿ÉÒÔÔÚ¡¾Õ³Ìùº¯Êý¡¿ÏÂÀ­ÁбíÖв鿴¡£µ«ÊÇ£¬Word±Ï¾¹ÊÇ´¦ÀíÎÄ×ÖÅŰæµÄ¹¤¾ß£¬ËùÒÔÊý¾Ý´¦Àí²¢²»ÊÇÆä³¤ÏÈç¹ûÊý¾ÝûÓд¦ÀíºÃ£¬½¨Ò黹ÊÇÏÈÔÚExcelµÈÈí¼þÖÐÏÈ´¦Àíͳ¼ÆºÃºóÔÙÕ³Ìùµ½WordÖнøÐÐÅŰ档


×ªÔØÇë×¢Ã÷À´Ô´"ExcelHome"²¢±£ÁôÔ­ÎÄÁ´½Ó¡£
¹Ì¶¨Á´½Ó£ºhttps://www.excelhome.net/lesson/article/word/1930.html
·ÖÏíµ½£º
Copyright 1999 - 2020 Excel Home.All Rights Reserved.
±¾Õ¾ÌØÆ¸·¨ÂɹËÎÊ£ºÐ컳ÓñÂÉʦ Àî־ȺÂÉʦ   »¦ICP±¸11019229ºÅ-2

»¦¹«Íø°²±¸ 31011702000001ºÅ

Õ÷ÐÅ