½ÌʦÐÂÈý¼¶¿¼ÊÔ²Ù×÷Ìâ´ð°¸·ÖÎöexcel²¿·Ö(23)
¡¡¡¡2£®ÀûÓÃÊý¾Ý͸ÊÓ±í¹¦ÄÜ£¬Í³¼Æ¸÷¸öµØÇøµÄÿ¸öÏÕÖֵı£·ÑÊÕÈëÖ®ºÍ¡£
¡¡¡¡3£®ÒªÇóÊý¾Ý͸ÊÓ±í¹¦ÄÜÉú³ÉµÄ±£·Ñ»ã×ܱíÔÚÐµĹ¤×÷±íÉÏ£¬²¢Ì×Óá°ÐòÁÐl¡±¸ñʽÉèÖá£
²Ù×÷²½Ö裺
¡¡¡¡(1)²Î¿¼µÚ50Ìâ¡£
¡¡¡¡(2)Ñ¡¶¨Êý¾ÝÇåµ¥ÖÐÈÎÒ»µ¥Ôª¸ñ£¬µ¥»÷²Ëµ¥[Êý¾Ý]Ò»[Êý¾Ý͸ÊÓ±íºÍͼ±í±¨¸æ]£¬µ¥»÷[ÏÂÒ»²½]¡¢[ÏÂÒ»²½]£¬µ¥»÷[°æʽ]£®½«¡°µØÇø¡±ÍÏÈë[ÐÐ]Çø£¬½«¡°ÏÕÖÖ¡±ÍÏÈë[ÁÐ]Çø£¬½«¡°±£·ÑÊÕÈ롱ÍÏÈë[Êý¾Ý]Çø£¬µ¥»÷[È·¶¨]£¬µ¥»÷[Íê³É]¡£
¡¡¡¡(3)Ñ¡¶¨Al£ºE8µ¥Ôª¸ñÇøÓò£¬µ¥»÷²Ëµ¥[¸ñʽ]Ò»[×Ô¶¯Ì×Óøñʽ]£¬Ñ¡[ÐòÁÐ1]£¬µ¥»÷[È·¶¨]°´Å¥¡£
µÚ52Ìâ
¡¡¡¡1£®¼ÆËãÿλѧÉúËÄÃſεÄƽ¾ù·Ö£¬ÌîÈëFÁУ»¼ÆËãÈ«°à¸÷ÃſεÄƽ¾ù·Ö¡£
¡¡¡¡2£®Çå³ý³É¼¨±íÖзÖÊýµÇ¼ÇÇø(B3£ºE13)ÔÓеÄÊý¾ÝÏÔʾ¸ñʽ¡£
¡¡¡¡3£®°´ÒÔÏÂÒªÇóÉèÖ÷ÖÊýÏÔʾ¸ñʽ£º·ÖÊý´óÓÚ»òµÈÓÚ85·Ö£¬Ôò·ÖÊýÒÔÂÌÉ«¡¢´ÖÌå×ÖÐÎÏÔʾ£»·ÖÊýСÓÚ60·Ö£¬ÔòÒÔºìÉ«´ÖÌå×ÖÐΡ¢Ç³»ÆÉ«µ×ÎÆÏÔʾ£»ÆäËû·ÖÊýÔòÒÔ³£¹æ×ÖÐκÍÑÕÉ«ÏÔʾ¡£
²Ù×÷²½Ö裺
¡¡¡¡(1)Ñ¡¶¨F2µ¥Ôª¸ñ£¬ÊäÈ롰ƽ¾ù·Ö¡±£¬°´Enter¼ü£¬µ¥»÷[±à¼¹«Ê½]°´Å¥[=]£¬µ¥»÷±à¼À¸×ó±ßµÄº¯ÊýÁбíÏÂÀ¼ýÍ·Ñ¡[AVERAGE]£¬µ¥»÷[È·¶¨]£»Êó±êÖ¸ÕëÖ¸ÏòF3µ¥Ôª¸ñÓÒϽdzɡ°+¡±ÐκóÍÏ·ÅÖÁF13µ¥Ôª¸ñÖ¹£»Ñ¡¶¨B14µ¥Ôª¸ñ£¬µ¥»÷[±à¼¹«Ê½]°´Å¥[=]£¬µ¥»÷±à¼À¸×ó±ßµÄº¯ÊýÁбíÏÂÀ¼ýÍ·Ñ¡[AvERAGE]£¬µ¥»÷[È·¶¨]£»µ¥»÷²Ëµ¥[¸ñʽ]Ò»[µ¥Ôª¸ñ]£¬Ñ¡[Êý×Ö]Ñ¡Ï£¬ÔÚ[·ÖÀà]¿òÖÐÑ¡[ÊýÖµ]£¬[СÊýλÊý]Ϊ[2]£¬µ¥»÷[È·¶¨]£»Êó±êÖ¸ÕëÖ¸ÏòB14µ¥Ôª¸ñÓÒϽdzɡ°+¡±ÐκóÍÏ·ÅÖÁE14µ¥Ôª¸ñÖ¹¡£
¡¡¡¡(2)Ñ¡¶¨B3£ºE13£¬µ¥»÷²Ëµ¥[±à¼]Ò»[Çå³ý]Ò»[¸ñʽ]¡£
¡¡¡¡(3)Ñ¡¶¨B3£ºE13µ¥Ôª¸ñÇøÓò£¬µ¥»÷²Ëµ¥[¸ñʽ]Ò»[Ìõ¼þ¸ñʽ]£¬Ìõ¼þ£º¡°µ¥Ôª¸ñÊýÖµl´óÓÚ»òµÈÓÚI 85¡±£¬µ¥»÷[¸ñʽ]°´Å¥£¬Ñ¡[×ÖÌå]Ñ¡Ï£¬[×ÖÐÍ]Ñ¡[¼Ó´Ö]£¬[ÑÕÉ«]Ñ¡¡°ÂÌÉ«¡±£¬µ¥»÷[È·¶¨]¡¢[È·¶¨]¡£°´×¡ctrl¼üÓÃÊó±êÑ¡¶¨B3£ºE13µ¥Ôª¸ñÇøÓòÖÐËùÓÐ85·ÖÒÔϵĵ¥Ôª¸ñ£®µ¥»÷²Ëµ¥[¸ñʽ]Ò»[Ìõ¼þ¸ñʽ]£¬Ìõ¼þ£º¡°µ¥Ôª¸ñÊýÖµlСÓÚl 60¡±£¬µ¥»÷[¸ñʽ]°´Å¥£¬Ñ¡[×ÖÌå]Ñ¡Ï£¬[×ÖÐÍ]Ñ¡[¼Ó´Ö]£¬[ÑÕÉ«]Ñ¡¡°ºìÉ«¡±£¬Ñ¡[ͼ°¸]Ñ¡Ï£¬ÔÚ[µ¥Ôª¸ñµ×ÎÆÑÕÉ«ÖÐ]Ñ¡¡°Ç³»Æ¡±É«£¬µ¥»÷[È·¶¨]¡¢[È·¶¨]°´Å¥¡£