¼ÆËã»ú»ù´¡4

ÎĵµÌṩÓÐÏ޵Ļָ´ C¡¢¾­¹ýWordÿ¸ôÒ»¶¨Ê±¼ä×Ô¶¯±£´æÎĵµ£¬Ô­ÎĵµÄÚÈݽ«»á¸Ä±ä D¡¢Óû§µ¥»÷¡°³£Óá±¹¤¾ßÀ¸Éϵı£´æ°´Å¥ÓëWordÌṩµÄ×Ô¶¯±£´æÎĵµ£¬¶þÕßµÄЧ¹ûÊǵȼ۵ġ£

67¡¢ÔÚWordÓ¦ÓóÌÐòÖ÷´°¿ÚÖУ¬£¨C£©

A¡¢Ö»ÄÜÔÚÒ»¸ö´°¿ÚÖУ¬±à¼­Ò»¸öÎĵµ B¡¢ÄÜ´ò¿ª¶à¸ö´°¿Ú£¬µ«Ö»Äܱ༭ͬһ¸öÎĵµ

C¡¢ÄÜ´ò¿ª¶àÍâ´°¿Ú£¬±à¼­¶à¸öÎĵµ£¬Ò²¿ÉÒÔÓм¸¸ö´°¿Ú±à¼­Í¬Ò»¸öÎĵµ D¡¢ÄÜ´ò¿ª¶à¸ö´°¿Ú£¬±à¼­¶à¸öÎĵµ£¬µ«²»¿ÉÒÔÓÐÁ½¸ö´°¿Ú±à¼­Í¬Ò»¸öÎĵµ

68¡¢ÔÚWord´°¿ÚÖУ¬Èô¹â±êÍ£ÔÚij¸ö×Ö·û֮ǰ£¬µ±Ñ¡Ôñij¸öÑùʽʱ£¬¸ÃÑùʽ»á¶Ôµ±Ç°£¨D£©Æð×÷Óá£

A¡¢Õû¸öÎĵµ B¡¢ÐÐ C¡¢×Ö·û D¡¢¶ÎÂä 69¡¢ÔÚWord±à¼­×´Ì¬£¬ÒªÏëʵÏÖͼÎÄ»ìÅÅ£¬±ØÐ루D£©

A¡¢ÏÈѡȡһ¸öͼÐÎ B¡¢ÏÈѡȡһ¶ÎÎÄ×Ö C¡¢ÏÈѡȡһ¶Îº¬ÓÐͼÐεÄÎÄ×Ö D¡¢ÏȰÑͼÐμÓÉÏ¡°Í¼ÎÄ¿ò¡±

70¡¢ÈôÒªÉ趨´òÓ¡Ö½ÕÅ´óС£¬Ó¦Ê¹Óã¨A£© A¡¢¡°Îļþ¡±²Ëµ¥Öеġ°Ò³ÃæÉèÖá±ÃüÁî B¡¢¡°Îļþ¡±²Ëµ¥Öеġ°´òÓ¡Ô¤ÀÀ¡±ÃüÁî C¡¢¡°ÊÓͼ¡±²Ëµ¥Öеġ°¹¤¾ßÀ¸¡±ÃüÁî D¡¢¡°ÊÓͼ¡±²Ëµ¥Öеġ°Ò³Ã桱ÃüÁî 71¡¢ÔÚWordÖУ¬Ò»°ãÕû¸öÎĵµÊÇÓÉÈô¸É¸ö¶ÎÂä×é³É£¬ÏÂÁÐÓйضÎÂäµÄÐðÊöÖУ¬ÕýÈ·µÄÊÇ£¨C£© A¡¢ÆÁÄ»ÉÏÏÔʾµÄ×ÔÈ»¶Î¾ÍÊÇÒ»¸ö¶ÎÂä B¡¢ÔÚÊäÈëÒ»¶Îºó°´+£¬¾ÍÐγÉÒ»¸ö¶ÎÂä

C¡¢Ò»¸ö¶ÎÂä¿É°üº¬¼¸¸ö×ÔÈ»¶Î D¡¢Ã¿¸ö¶ÎÂäµÄ¶ÎÂä±ê¼Ç¶¼ÊÇ´¦ÓÚÒþ²Ø×´Ì¬ÏÂ

73¡¢ÔÚWordµÄ±à¼­×´Ì¬£¬½øÐÐ×ÖÌåÉèÖòÙ×÷ºó£¬°´ÐÂÉèÖõÄ×ÖÌåÏÔʾµÄÊÇ£¨C£©

A¡¢²åÈëµãËùÔÚ¶ÎÂäÖеÄÎÄ×Ö B¡¢²åÈëµãËùÔÚÐÐÖеÄÎÄ×Ö C¡¢ÎĵµÖб»Ñ¡¶¨µÄÎÄ×Ö D¡¢ÎĵµµÄÈ«²¿ÎÄ×Ö

74¡¢ÔÚWordµÄ±à¼­×´Ì¬£¬ÓйزéÕÒ²Ù×÷µÄÐðÊöÖУ¬ÕýÈ·µÄÊÇ£¨A£©

A¡¢²éÕÒʱ£¬¿ÉÒÔÎÞ¸ñʽ½øÐС¢Ò²¿ÉÒÔ´ø¸ñʽ½øÐС¢»¹¿ÉÒÔ²éÕÒÒ»Ð©ÌØÊâµÄ·Ç´òÓ¡×Ö·û B¡¢²éÕÒʱ£¬Ö»ÄÜ´ø¸ñʽ½øÐÐ C¡¢²éÕÒʱ£¬Ö»ÄÜÔÚÕû¸öÎĵµ·¶Î§ÄÚ½øÐÐ D¡¢²éÕÒʱ£¬¿ÉÒÔÎÞ¸ñʽ½øÐС¢Ò²¿ÉÒÔ´ø¸ñʽ½øÐУ¬µ«²»ÄܲéÕÒÒ»Ð©ÌØÊâµÄ·Ç´òÓ¡×Ö·û

75¡¢ÔÚWordÖУ¬Óйرí¸ñ²Ù×÷µÄÐðÊöÖУ¬²»ÕýÈ·µÄÊÇ£¨D£©

A¡¢ÎÄ×ÖÄÜת»»³É±í¸ñ B¡¢±í¸ñÄÜת»»³ÉÎÄ×Ö C¡¢ÎÄ×ÖÓë±í¸ñ¿ÉÒÔÏ໥ת»» D¡¢ÎÄ×ÖÓë±í¸ñ²»ÄÜÏ໥ת»»

76¡¢ÏÂÃæ¹ØÓÚWordµÄÐðÊöÖУ¬²»ÕýÈ·µÄÊÇ£¨C£©

A¡¢±í¸ñÖпÉÒÔÌîÈëÎÄ×Ö¡¢Êý×Ö»òͼÐÎ B¡¢Word¿Éͬʱ´ò¿ª¶à¸öÎĵµ£¬µ«»î¶¯ÎĵµÖ»ÓÐÒ»¸ö

C¡¢ÉèÖÃÁË¡°ÐÞ¸ÄȨÏÞ¿ÚÁµÄÎĵµ£¬Èç¹û²»ÖªµÀ¿ÚÁ¾ÍÎÞ·¨´ò¿ªËü D¡¢´ÓÎļþ²Ëµ¥ÖÐÑ¡Ôñ¡°´òÓ¡Ô¤ÀÀ¡±ÃüÁÔÚ³öÏÖµÄÔ¤ÀÀÊÓͼÏ£¬¼È¿ÉÒÔä¯ÀÀ´òÓ¡½á¹û£¬ÓÖ¿ÉÒԱ༭Îı¾

77¡¢ÔÚWord±à¼­×´Ì¬£¬Èô²åÈëµÄ±í¸ñÖУ¬ÄÚÍâ¿òÏßÊÇÐéµÄ£¬ÏëÒª½«Æä¸Ä±äΪʵÏߣ¬Ó¦Ñ¡Ôñ£¨D£©ÃüÁî¡£

A¡¢¡°±í¸ñ¡±²Ëµ¥Öеġ°Òþ²ØÐé¿ò¡± B¡¢¡°±í¸ñ¡±²Ëµ¥Öеġ°Ñ¡¶¨±í¸ñ¡± C¡¢¡°¸ñʽ¡±²Ëµ¥Öеġ°ÖƱíλ¡± D¡¢¡°¸ñʽ¡±²Ëµ¥Öеġ°±ß¿òºÍµ×ÎÆ¡± 78¡¢ÔÚWordµÄˮƽ¹ö¶¯Ìõ×ó±ßÉèÓС°ÆÕͨÊÓͼ¡±¡¢¡°Áª»ú°æÊ½¡±¡°Ò³ÃæÊÓͼ¡±ºÍ¡°´ó¸ÙÊÓͼ¡±

13

°´Å¥£¬¿É¿ìËÙÔÚ4ÖÖÊÓͼ¼äÇл»£¬Èç¹ûÓû§Òª»æÖÆÍ¼ÐÎʱ£¬Ó¦Çл»µ½£¨B£©

A¡¢´ó¸ÙÊÓͼ B¡¢Ò³ÃæÊÓͼ C¡¢Áª»ú°åʽÊÓͼ D¡¢ÆÕͨÊÓͼ

79¡¢ÔÚWordµÄ±à¼­×´Ì¬£¬¹²Ð½¨ÁËÁ½¸öÎĵµ£¬Ã»ÓжԸÃÁ½¸öÎĵµ½øÐС°±£»¤¡±»ò¡°Áí´æÎª¡±²Ù×÷£¬Ôò£¨B£©

A¡¢Á½¸öÎĵµÃû¶¼³öÏÖÔÚ¡°Îļþ¡±²Ëµ¥ÖÐ B¡¢Á½¸öÎĵµÃû¶¼³öÏÖÔÚ¡°´°¿Ú¡±²Ëµ¥ÖÐ

C¡¢Ö»ÓеÚÒ»¸öÎĵµÎÒ³öÏÖÔÚ¡°Îļþ¡±²Ëµ¥ÖÐ D¡¢Ö»ÓеÚÒ»¸öÎĵµÎÒ³öÏÖÔÚ¡°´°¿Ú¡±²Ëµ¥ÖÐ

80¡¢ÔÚWord´°¿Ú²Ëµ¥À¸µÄ¡°Îļþ¡±²Ëµ¥ÖУ¬Ò»°ãϲ¿ÓÐÈô¸É¸öÎļþÃû£¬ÕâЩÎļþÃû±íÃ÷£¨C£© A¡¢ËüÃÇĿǰ¾ù´¦ÓÚ´ò¿ª×´Ì¬ B¡¢ËüÃÇĿǰÕýÅŶӵȴý´òÓ¡ C¡¢ËüÃÇÔÚ×î½üÓÃWord´¦Àí¹ý

D¡¢ËüÃÇÊǵ±Ç°Ä¿Â¼ÖÐÀ©Õ¹ÃûΪ. DOCÎļþ

(¶þ)¡¢Ìî¿ÕÌâ

1¡¢ÔÚWord±à¼­×´Ì¬£¬µ±ÓÐij¸öÏÂÀ­Ê½²Ëµ¥ÏÔʾʱ£¬Ö±½Ó°´£¨ESC£© ¼ü¿ÉÈ¡ÏûÆÁÄ»ÉϵÄÏÂÀ­²Ëµ¥¡£

2¡¢ÔÚWord±à¼­×´Ì¬£¬Èô½«µ±Ç°ÎĵµÒÔÒ»¸öÐÂÎļþÃû´æÔÚ´ÅÅÌÉÏ£¬Ó¦Ñ¡Ôñ¡°Îļþ¡±²Ëµ¥ÖÐµÄ £¨Áí´æÎª£© ÃüÁî¡£

3¡¢Ôڱ༭״̬ÊäÈëÎı¾Ê±£¬Ã¿°´Ò»´Î¼ü£¬Ôò²úÉúÒ»¸ö£¨¶ÎÂä±ê¼Ç£©¡£

4¡¢ÔÚWordÖУ¬Ö´ÐÐ £¨Õ³Ìù£© ÃüÁ¿É½«¼ôÌù°åÖеÄÄÚÈÝ¿½±´µ½µ±Ç°ÎĵµµÄ²åÈëµã´¦¡£ 5¡¢

6¡¢ÔÚWordÎĵµ±à¼­ÖУ¬Ê¹Óà £¨¼ôÌù°å£© ¿É·½±ãµØ½øÐÐÎļþÄÚÈݵÄɾ³ý¡¢¿½±´¡¢Òƶ¯¼°Îļþ¼äµÄ²Ù×÷¡£

7¡¢ÔÚWordµÄ±à¼­×´Ì¬£¬ÒªÈ¡ÏûWordÖ÷´°¿ÚÏÔʾµÄ¡°¸ñʽ¡±¹¤¾ßÀ¸£¬Ó¦Ê¹Óà £¨ÊÓͼ£© ²Ëµ¥ÖеÄÃüÁî¡£

8¡¢ÔÚWordÎĵµ±à¼­ÖУ¬ÈôÒª²åÈëÒ»¸ö¡°·ÖÒ³·û¡±£¬¿ÉÖ´ÐУ¨²åÈ룩 ²Ëµ¥ÖеÄÃüÁî¡£ 9¡¢ÔÚWordÎĵµ±à¼­ÖУ¬Ê¹ÓüôÌù°å¿É·½±ãµØ½øÐÐÎļþÄÚÈݵÄɾ³ý¡¢¿½±´¡¢Òƶ¯µÈ²Ù×÷£¬ÔÚʹÓüôÌù°å¸´ÖÆÎı¾Ê±£¬ÏÈÑ¡¶¨Òª¸´ÖƵÄÎı¾£¬°´ £¨CTRL+C£© ¼ü£¬ÔÙ½«²åÈëµãÒÆµ½Ä¿±êλÖ㬰´ £¨CTRL+V£©¼ü£¬Ôò¼ôÌù°åÖеÄÎı¾±»Õ³Ìùµ½Ä¿±êλÖã¬Íê³ÉÁ˸´ÖƲÙ×÷¡£

10¡¢ÔÚWordÖУ¬ÓÃÊó±êµ¥»÷¸ñʽ¹¤¾ßÀ¸Öеġ°±àºÅ¡±»ò¡°ÏîÄ¿·ûºÅ¡±°´Å¥À´ÉèÖÃÏîÄ¿·ûºÅºÍ¶ÎÂä±àºÅ״̬¡£Ò»µ©ÉèÖÃÒÔºó£¬Ã¿°´Ò»´Î £¨ENTER£©¼ü£¬¶¼»áÔÚÏÂÒ»ÐÐÐÐÊ××Ô¶¯Ìí¼ÓÒ»¸öÏîÄ¿·ûºÅ»ò±àºÅ£¬¹Ø±ÕÌí¼ÓÏîÄ¿·ûºÅºÍ¶ÎÂä±àºÅ״̬ÊÇͨ¹ýÔٴε¥»÷ÏîÄ¿·ûºÅ»ò±àºÅ°´Å¥À´Íê³ÉµÄ¡£

11¡¢ÔÚWordÖУ¬Èôɾ³ý±í¸ñµÄÒ»ÕûÐÐʱ£¬Ó¦°Ñ²åÈëµãÒÆµ½ÒªÉ¾³ýµÄÐÐÖеÄÈÎÒ»µ¥Ôª¸ñ£¬ÔÚ¡°±í¸ñ¡±²Ëµ¥£¬Ñ¡Ôñ£¨ ɾ³ýµ¥Ôª¸ñ£© ÃüÁɾ³ýÕûÐС£ 12¡¢

13¡¢ÔÚWordÖУ¬±í¸ñÖеÄÊý¾ÝÊÇ¿ÉÒÔ°´ £¨ÁУ© ½øÐÐÅÅÐòµÄ¡£Óû§¿ÉÒÔͨ¹ý £¨±í¸ñ£©²Ëµ¥Öеġ°ÅÅÐò¡±ÃüÁîÀ´ÊµÏÖ¡£

14¡¢

15¡¢ÔÚWordÖУ¬Ã¿¸ö¶ÎÂä¶¼ÓÐ×Ô¼ºµÄ¶ÎÂä±ê¼Ç£¬¶ÎÂä±ê¼ÇµÄλÖÃÔÚ £¨¶ÎÂäµÄβ²¿£© ËÄ¡¢ÖÐÎİæExcel¼°ÆäÓ¦Óà £¨Ò»£©Ñ¡ÔñÌâ

3¡¢°Ñµ¥Ôª¸ñÖ¸ÕëÒÆµ½AZ1000µÄ×î¼òµ¥·½·¨ÊÇ£¨C£©

14

A¡¢Í϶¯¹ö¶¯Ìõ B¡¢°´+¡´AZ1000¡µ¼ü C¡¢ÔÚÃû³Æ¿òÊäÈëAZ1000£¬²¢°´»Ø³µ¼ü

D¡¢ÏÈÓÃ+¡´¡ú¡µ¼üÒÆµ½AZÁУ¬ÔÙÓÃ+¡´¡ý¡µ¼üÒÆµ½1000ÐÐ

5¡¢Ò»¸öExcel¹¤×÷²¾ÎļþÔÚµÚÒ»´Î´æÅÌʱ²»±Ø¼üÈëÀ©Õ¹Ãû£¬Excel×Ô¶¯ÒÔ£¨B£©×÷ΪÆäÀ©Õ¹Ãû¡£

A¡¢. WK1 B¡¢. XLS C¡¢. XCL D¡¢. DOC 6¡¢ÔÚExcelÖУ¬Ê¹Óù«Ê½ÊäÈëÊý¾Ý£¬Ò»°ãÔÚ¹«Ê½Ç°ÐèÒª¼Ó£¨A£©

A¡¢= B¡¢µ¥ÒýºÅ C¡¢¡ç D¡¢ÈÎÒâ·ûºÅ 7¡¢ÔÚ¹«Ê½ÖÐÊäÈë¡°=¡çC1+E¡ç1¡±ÊÇ£¨C£©

A¡¢Ïà¶ÔÒýÓà B¡¢¾ø¶ÔÒýÓà C¡¢»ìºÏÒýÓà D¡¢ÈÎÒâÒýÓÃ

8¡¢ÏÂÁÐÐòÁÐÖУ¬²»ÄÜÖ±½ÓÀûÓÃ×Ô¶¯Ìî³ä¿ìËÙÊäÈëµÄÊÇ£¨B£©

A¡¢ÐÇÆÚÒ»¡¢ÐÇÆÚ¶þ¡¢ÐÇÆÚÈý ¡¢?? B¡¢µÚÒ»Àà¡¢µÚ¶þÀà¡¢µÚÈýÀà¡¢??

C¡¢¼×¡¢ÒÒ¡¢±û¡¢?? D¡¢Mon¡¢Tue¡¢Wed¡¢?? 10¡¢ÒÑÖª¹¤×÷±íÖÐC3µ¥Ôª¸ñÓëD4µ¥Ôª¸ñµÄÖµ¾ùΪ0£¬C4µ¥Ôª¸ñÖÐΪ¹«Ê½¡°=C3=D4¡±£¬ÔòC4µ¥Ôª¸ñÏÔʾµÄÄÚÈÝΪ£¨B£©

A¡¢C3=D4 B¡¢TRUE C¡¢#N£¯A D¡¢0

11¡¢ÀûÓÃExcelµÄ×Ô¶¨ÒåÐòÁй¦Äܽ¨Á¢ÐÂÐòÁУ¬ÔÚÊäÈëµÄÐÂÐòÁи÷ÏîÖ®¼äÒªÓã¨D£©¼ÓÒÔ·Ö¸ô¡£

A¡¢È«½Ç·ÖºÅ¡°£»¡± B¡¢È«½Ç¶ººÅ¡°£¬¡± C¡¢°ë½Ç·ÖºÅ¡°£»¡± D¡¢°ë½Ç¶ººÅ¡°£¬¡±

12¡¢ÒªÔÚExcel¹¤×÷²¾ÖÐͬʱѡÔñ¶à¸ö²»ÏàÁڵŤ×÷±í£¬¿ÉÒÔÔÚ°´×¡£¨A£©¼üµÄͬʱÒÀ´Îµ¥»÷¸÷¸ö¹¤×÷±íµÄ±êÇ©¡£

A¡¢ B¡¢ C¡¢ D¡¢

13¡¢ÔÚExcel¹¤×÷±íµ¥Ôª¸ñµÄ×Ö·û´®³¬¹ý¸Ãµ¥Ôª¸ñµÄÏÔʾ¿í¶Èʱ£¬ÏÂÁÐÐðÊöÖУ¬²»ÕýÈ·µÄÊÇ£¨D£© A¡¢¸Ã×Ö·û´®¿ÉÄÜÕ¼ÓÃÆä×ó²àµ¥Ôª¸ñµÄÏÔʾ¿Õ¼äÈ«²¿ÏÔʾ³öÀ´ B¡¢¸Ã×Ö·û´®¿ÉÄÜÕ¼ÓÃÆäÓҲ൥Ԫ¸ñµÄÏÔʾ¿Õ¼äÈ«²¿ÏÔʾ³öÀ´ C¡¢¸Ã×Ö·û´®¿ÉÄÜÖ»ÔÚÆä

ËùÔÚµ¥Ôª¸ñµÄÏÔʾ¿Õ¼ä²¿·ÖÏÔʾ³öÀ´£¬¶àÓಿ·Ö±»ÆäÓҲ൥Ԫ¸ñÖеÄÄÚÈÝÕÚ¸Ç D¡¢¸Ã×Ö·û´®¿ÉÄÜÖ»ÔÚÆäËùÔÚµ¥Ôª¸ñµÄÏÔʾ¿Õ¼ä²¿·ÖÏÔʾ³öÀ´£¬¶àÓಿ·Ö±»É¾³ý 14¡¢Excel¹¤×÷±íµÄÁÐ×ø±ê·¶Î§ÊÇ£¨A£©

A¡¢A~IV B¡¢A~VI C¡¢1~256 D¡¢1~512

15¡¢Ê¹ÓÃ×ø±ê¡çD¡ç1ÒýÓù¤×÷±íDÁеÚ1Ðеĵ¥Ôª¸ñ£¬Õâ³ÆÎª¶Ôµ¥Ôª¸ñ×ø±êµÄ£¨A£©

A¡¢¾ø¶ÔÒýÓà B¡¢Ïà¶ÔÒýÓà C¡¢»ìºÏÒýÓà D¡¢½»²æÒýÓà 16¡¢ÔÚExcel¹æ¶¨¿ÉÒÔʹÓõÄÔËËã·ûÖУ¬Ã»ÓУ¨C£©ÔËËã·û¡£

A¡¢ËãÊõ B¡¢¹ØÏµ C¡¢Âß¼­ D¡¢×Ö·û 18¡¢Excel¹¤×÷±íA1µ¥Ôª¸ñµÄÄÚÈÝΪ¹«Ê½=SUM£¨B2£ºD7£©£¬ÔÚÓÃɾ³ýÐеÄÃüÁµÚ2ÐÐɾ³ýºó£¬A1µ¥Ôª¸ñÖеĹ«Ê½½«µ÷ÕûΪ£¨C£© A¡¢=SUM£¨ERR£© B¡¢=SUM£¨B3£ºD7£© C¡¢=SUM£¨B2£ºD6£© D¡¢#VALUF£¡ 19¡¢ÔÚExcel¹¤×÷±íijÁеÚÒ»¸öµ¥Ôª¸ñÖÐÊäÈëµÈ²îÊýÁÐÆðʼֵ£¬È»ºó£¨D£©µ½µÈ²îÊýÁÐ×îºóÒ»¸öÊýÖµËùÔÚµ¥Ôª¸ñ¡£¿ÉÒÔÍê³ÉÖðÒ»Ôö¼ÓµÄµÈ²îÊýÁÐÌî³äÊäÈë¡£

A¡¢ÓÃÊó±ê×ó¼üÍÏ×§µ¥Ôª¸ñÓÒϽǵÄÌî³ä±ú£¨Ìî³äµã£© B¡¢°´×¡¼ü£¬ÓÃÊó

15

±ê×ó¼üÍÏ×§µ¥Ôª¸ñÓÒϽǵÄÌî³ä±ú£¨Ìî³äµã£© C¡¢°´×¡¼ü£¬ÓÃÊó±ê×ó¼üÍÏ×§µ¥Ôª¸ñÓÒϽǵÄÌî³ä±ú£¨Ìî³äµã£© D¡¢°´×¡¼ü£¬ÓÃÊó±ê×ó¼üÍÏ×§µ¥Ôª¸ñÓÒϽǵÄÌî³ä±ú£¨Ìî³äµã£©

20¡¢Excel¹¤×÷±íG8µ¥Ôª¸ñµÄֵΪ7654.375£¬Ö´ÐÐijЩ²Ù×÷Ö®ºó£¬ÔÚG8µ¥Ôª¸ñÖÐÏÔʾһ´®¡°#¡±·ûºÅ£¬ËµÃ÷G8µ¥Ôª¸ñµÄ£¨C£©

A¡¢¹«Ê½ÓÐ´í£¬ÎÞ·¨¼ÆËã B¡¢Êý¾ÝÒѾ­Òò²Ù×÷ʧÎó¶ø¶ªÊ§ C¡¢ÏÔʾ¿í¶È²»¹»£¬Ö»Òªµ÷Õû¿í¶È¼´¿É D¡¢¸ñʽÓëÀàÐͲ»Æ¥Å䣬ÎÞ·¨ÏÔʾ 21¡¢ÔÚExcel¹¤×÷±íÉÏ£¬Óã¨B£©²»¿ÉÒÔ½«C3ºÍD8Á½¸öµ¥Ôª¸ñµÄÄÚÈÝÒ»´Î¸´ÖƵ½ÇøÓòA8£ºA9ÖС£

A¡¢²Ëµ¥ÃüÁî B¡¢Êó±êÍÏ×§ C¡¢¹¤¾ßÀ¸°´Å¥ D¡¢¿ì½Ý²Ëµ¥ÃüÁî

23¡¢ÓÐÈËÓù«Ê½ÊäÈë·¨ÔÚExcel¹¤×÷±íÇøÓòB1£ºB25ÖÐÊäÈëÆðʼֵΪ1£¬¹«²îΪ3µÄµÈ²îÊýÁС£Æä²Ù×÷¹ý³ÌÈçÏ£ºÏÈÔÚB1µ¥Ôª¸ñÖÐÊäÈëÊý×Ö1£¬È»ºóÔÚB2µ¥Ôª¸ñÖÐÊäÈ빫ʽ£¨A£©£¬×îºó½«¸Ã¹«Ê½Ïòϸ´ÖƵ½ÇøÓòB3£ºB25ÖС£

A¡¢=B1+2 B¡¢=2-B1 C¡¢=B1-2 D¡¢=¡çB¡ç1+2

24¡¢É蹤×÷±íÇøÓòA1£ºA12¸÷µ¥Ôª¸ñ´ÓÉÏÏòÏÂ˳Ðò´æ´¢ÓÐijÉ̵ê1~12ÔµÄÏúÊ۶ΪÁËÔÚÇøÓòB1£ºB12¸÷µ¥Ôª¸ñÖдÓÉÏÏòÏÂ˳ÐòµÃµ½´Ó1Ôµ½¸÷ÔµÄÏúÊ۶Æä²Ù×÷¹ý³ÌÈçÏ£ºÏÈÔÚB1µ¥Ôª¸ñÖÐÊäÈ빫ʽ£¨C£©£¬È»ºó½«ÆäÖеĹ«Ê½Ïòϸ´ÖƵ½ÇøÓòB2£ºB12ÖС£

A¡¢=SUM£¨A1£ºA1£© B¡¢=SUM£¨A1£ºA12£© C¡¢=SUM£¨A1£ºA¡ç1£© D¡¢=SUM£¨A1£º¡çA1£©

25¡¢ÔÚÊý¾ÝÇåµ¥£¨ÓС°×Ü·Ö¡±×ֶΣ©²éÕÒ×Ü·Ö´óÓÚ240µÄ¼Ç¼£¬ÆäÓÐЧ·½·¨ÊÇ£¨A£© A¡¢ÔÚ¡°¼Ç¼µ¥¡±¶Ô»°¿òÖе¥»÷¡°Ìõ¼þ¡±°´Å¥£¬ÔÚ¡°×Ü·Ö¡±À¸ÊäÈë¡°>240¡±£¬ÔÙµ¥»÷¡°ÏÂÒ»Ìõ¡±°´Å¥

B¡¢°´+×éºÏ¼ü£¬ÔÚ³öÏֵĶԻ°¿òµÄ¡°×Ü·Ö¡±À¸ÊäÈë¡°>240¡±£¬ÔÙµ¥»÷¡°È·¶¨¡±°´Å¥

C¡¢ÔÚ¡°¼Ç¼µ¥¡±¶Ô»°¿òÖÐÁ¬Ðøµ¥»÷¡°ÏÂÒ»Ìõ¡±°´Å¥ D¡¢ÒÀ´Î²é¿´¼Ç¼¡°×Ü·Ö¡±×ֶεÄÖµ

27¡¢ÏÂÁÐ×ø±êÒýÓÃÖУ¬²»ÊÇ2ÐеÚBÁе¥Ôª×ø±êΪ£¨A£©

A¡¢R[2]C[2] B¡¢R2C2 C¡¢B2 D¡¢¡çB¡ç2 28¡¢ÏÂÁйØÓÚExcelµÄÐðÊöÖУ¬ÕýÈ·µÄÊÇ£¨B£©

A¡¢Excel½«¹¤×÷²¾µÄÿһÕŹ¤×÷±í·Ö±ð×÷Ϊһ¸öÎļþÀ´±£´æ B¡¢ExcelÔÊÐíÒ»¸ö¹¤×÷²¾Öаüº¬¶à¸ö¹¤×÷±í

C¡¢ExcelµÄͼ±í±ØÐëÓëÉú³É¸Ãͼ±íµÄÓйØÊý¾Ý´¦ÓÚͬһÕŹ¤×÷±íÉÏ D¡¢Excel¹¤×÷±íµÄÃû³ÆÓÉÎļþ¾ö¶¨

29¡¢ÔÚExcelÖУ¬²»ÄÜÓã¨D£©µÄ·½·¨½¨Á¢Í¼±í

A¡¢ÔÚ¹¤×÷±íÖвåÈë»òǶÈëͼ±í B¡¢Ìí¼Óͼ±í¹¤×÷±í C¡¢´Ó·ÇÏàÁÚÑ¡¶¨ÇøÓò½¨Á¢Í¼±í D¡¢½¨Á¢Êý¾Ý¿â

30¡¢ÏÂÁÐÓйØExcel¹¦ÄܵÄÐðÊöÖУ¬ÕýÈ·µÄÊÇ£¨C£©

A¡¢ÔÚExcelÖУ¬²»ÄÜ´¦ÀíͼÐÎ B¡¢ÔÚExcelÖУ¬²»ÄÜ´¦Àí±í¸ñ C¡¢ExcelµÄÊý¾Ý¿â¹ÜÀí¿ÉÖ§³ÖÊý¾Ý¼Ç¼µÄÔö¡¢É¾¡¢¸ÄµÈ²Ù×÷ D¡¢ÔÚÒ»¸ö¹¤×÷±íÖаüº¬¶à¸ö¹¤×÷²¾ £¨¶þ£©Ìî¿ÕÌâ

1¡¢Excel¹¤×÷±íµÄÐÐ×ø±ê·¶Î§ÊÇ £¨1~65536£©

2¡¢¶ÔÊý¾ÝÇåµ¥ÖеÄÊý¾Ý½øÐÐÅÅÐòʱ£¬¿É°´Ä³Ò»×ֶνøÐÐÅÅÐò£¬Ò²¿É°´¶à¸ö×ֶνøÐÐÅÅÐò£¬ÔÚ°´¶à¸ö×ֶνøÐÐÅÅÐòʱ³ÆÎª£¨¶àÖØÅÅÐò£©

16

ÁªÏµ¿Í·þ£º779662525#qq.com(#Ìæ»»Îª@)