¼ÆËã»ú¿Í¹ÛÌâ- ¸±±¾

63

64

65

66

67

68

69

·µ»Ø²ÎÊý×éÖзǿÕÖµµ¥Ôª¸ñÊýÄ¿µÄº¯ÊýÊÇ__B_____¡£ (A)COUNT

D (B)COUNTBLANK (C)COUNTIF (D)COUNTA

Excelһά´¹Ö±Êý×éÖÐÔªËØÓÃ____D___·Ö¿ª¡£ (A)\\ D (B)\\\\ (C), (D);

½«Êý×ÖÏòÉÏÉáÈëµ½×î½Ó½üµÄÆæÊýµÄº¯ÊýÊÇ___D____¡£ (A)ROUND D (B)TRUNC (C)EVEN (D)ODD

×Ô¶¨ÒåÐòÁпÉÒÔͨ¹ý___C___ À´½¨Á¢¡£ (A)Ö´ÐÐ\¿ªÊ¼¡ú¸ñʽ\²Ëµ¥ÃüÁî C (B)Ö´ÐÐ\Êý¾Ý¡úɸѡ\²Ëµ¥ÃüÁî

(C)Ö´ÐÐ\¿ªÊ¼¡úÅÅÐòºÍɸѡ¡ú×Ô¶¨ÒåÅÅÐò¡ú´ÎÐò¡ú×Ô¶¨ÒåÐòÁÐ\ÃüÁî (D)Ö´ÐÐ\Êý¾Ý¡ú´´½¨×é\²Ëµ¥ÃüÁî

ÔڼǼµ¥µÄÓÒÉϽÇÏÔʾ\ÆäÒâÒåÊÇ___C___¡£ (A)µ±Ç°¼Ç¼µ¥½öÔÊÐí30¸öÓû§·ÃÎÊ C (B)µ±Ç°¼Ç¼ÊǵÚ30ºÅ¼Ç¼ (C)µ±Ç°¼Ç¼ÊǵÚ3ºÅ¼Ç¼

(D)ÄúÊÇ·ÃÎʵ±Ç°¼Ç¼µ¥µÄµÚ3¸öÓû§

ÔÚÒ»¹¤×÷±íÖÐɸѡ³öijÏîµÄÕýÈ·²Ù×÷·½·¨ÊÇ__B____¡£

(A)Êó±êµ¥»÷Êý¾Ý±íÍâµÄÈÎÒ»µ¥Ôª¸ñ,Ö´ÐÐ\Êý¾Ý¡úɸѡ\²Ëµ¥ÃüÁî,Êó±êµ¥»÷Ïë²éÕÒÁеÄÏòϼýÍ·,´ÓÏÂÀ­²Ëµ¥ÖÐÑ¡ÔñɸѡÏî

(B)Êó±êµ¥»÷Êý¾Ý±íÖеÄÈÎÒ»µ¥Ôª¸ñ,Ö´ÐÐ\Êý¾Ý¡úɸѡ\²Ëµ¥ÃüÁî,Êó±êµ¥B »÷Ïë²éÕÒÁеÄÏòϼýÍ·,´ÓÏÂÀ­²Ëµ¥ÖÐÑ¡ÔñɸѡÏî

(C)Ö´ÐÐ\²éÕÒÓëÑ¡Ôñ¡ú²éÕÒ\²Ëµ¥ÃüÁî,ÔÚ\²éÕÒ\¶Ô»°¿òµÄ\²éÕÒÄÚÈÝ\¿òÊäÈëÒª²éÕÒµÄÏî,µ¥»÷[¹Ø±Õ]°´Å¥

(D)Ö´ÐÐ\²éÕÒÓëÑ¡Ôñ¡ú²éÕÒ\²Ëµ¥ÃüÁî,ÔÚ\²éÕÒ\¶Ô»°¿òµÄ\²éÕÒÄÚÈÝ\¿òÊäÈëÒª²éÕÒµÄÏî,µ¥»÷[²éÕÒÏÂÒ»¸ö]°´Å¥

Ò»¸ö¹¤×÷±í¸÷ÁÐÊý¾Ý¾ùº¬±êÌâ,Òª¶ÔËùÓÐÁÐÊý¾Ý½øÐÐÅÅÐò,Óû§Ó¦Ñ¡È¡µÄÅÅÐòÇøÓòÊÇ__A____¡£ (A)º¬±êÌâµÄËùÓÐÊý¾ÝÇø A

(B)º¬±êÌâÈÎÒ»ÁÐÊý¾Ý

(C)²»º¬±êÌâµÄËùÓÐÊý¾ÝÇø (D)²»º¬±êÌâÈÎÒ»ÁÐÊý¾Ý

ijµ¥Î»ÒªÍ³¼Æ¸÷¿ÆÊÒÈËÔ±¹¤×ÊÇé¿ö£¬°´¹¤×ʴӸߵ½µÍÅÅÐò£¬Èô¹¤×ÊÏàͬ£¬7ÒÔ¹¤Áä½µÐòÅÅÁУ¬ÔòÒÔÏÂ×ö·¨ÕýÈ·µÄÊÇ____A___¡£ A 0 (A)Ö÷Òª¹Ø¼ü×ÖΪ\¿ÆÊÒ\£¬´ÎÒª¹Ø¼ü×ÖΪ\¹¤×Ê\£¬µÚ¶þ¸ö´ÎÒª¹Ø¼ü×ÖΪ\¹¤

Áä\

9

71

72

73

74

75

76

77

(B)Ö÷Òª¹Ø¼ü×ÖΪ\¹¤×Ê\£¬´ÎÒª¹Ø¼ü×ÖΪ\¹¤Áä\£¬µÚ¶þ¸ö´ÎÒª¹Ø¼ü×ÖΪ\¿ÆÊÒ\

(C)Ö÷Òª¹Ø¼ü×ÖΪ\¹¤Áä\£¬´ÎÒª¹Ø¼ü×ÖΪ\¹¤×Ê\£¬µÚ¶þ¸ö´ÎÒª¹Ø¼ü×ÖΪ\¿ÆÊÒ\

(D)Ö÷Òª¹Ø¼ü×ÖΪ\¿ÆÊÒ\£¬´ÎÒª¹Ø¼ü×ÖΪ\¹¤Áä\£¬µÚ¶þ¸ö´ÎÒª¹Ø¼ü×ÖΪ\¹¤×Ê\

ʹÓÃExcelµÄÊý¾Ýɸѡ¹¦ÄÜ£¬Êǽ«___B___¡£

(A)Âú×ãÌõ¼þµÄ¼Ç¼ÏÔʾ³öÀ´£¬¶øÉ¾³ýµô²»Âú×ãÌõ¼þµÄÊý¾Ý B (B)²»Âú×ãÌõ¼þµÄ¼Ç¼ÔÝʱÒþ²ØÆðÀ´£¬Ö»ÏÔʾÂú×ãÌõ¼þµÄÊý¾Ý (C)²»Âú×ãÌõ¼þµÄÊý¾ÝÓÃÁíÍâÒ»¸ö¹¤×÷±íÀ´±£´æÆðÀ´ (D)½«Âú×ãÌõ¼þµÄÊý¾ÝÍ»³öÏÔʾ

¹ØÓÚExcelÇøÓò¶¨Òå²»ÕýÈ·µÄÂÛÊöÊÇ_C_____¡£ (A)ÇøÓò¿ÉÓɵ¥Ò»µ¥Ôª¸ñ×é³É

C (B)ÇøÓò¿ÉÓÉͬһÁÐÁ¬Ðø¶à¸öµ¥Ôª¸ñ×é³É (C)ÇøÓò¿ÉÓɲ»Á¬ÐøµÄµ¥Ôª¸ñ×é³É

(D)ÇøÓò¿ÉÓÉͬһÐÐÁ¬Ðø¶à¸öµ¥Ôª¸ñ×é³É

ʹÓüǼµ¥Ôö¼Ó¼Ç¼ʱ,µ±ÊäÍêÒ»¸ö¼Ç¼µÄÊý¾Ýºó,°´___D___±ã¿ÉÔٴγöÏÖÒ»¸ö¿Õ°×¼Ç¼µ¥ÒÔ±ã¼ÌÐøÔö¼Ó¼Ç¼¡£ (A)[¹Ø±Õ]°´Å¥ D

(B)[ÏÂÒ»Ìõ]°´Å¥ (C)[¡ü]¼ü

(D)[¡ý]¼ü»ò»Ø³µ¼ü»ò[н¨]°´Å¥

¹ØÓÚɸѡ£¬ÐðÊöÕýÈ·µÄÊÇ___B___¡£

(A)×Ô¶¯É¸Ñ¡¿ÉÒÔͬʱÏÔʾÊý¾ÝÇøÓòºÍɸѡ½á¹û B (B)¸ß¼¶É¸Ñ¡¿ÉÒÔ½øÐиü¸´ÔÓÌõ¼þµÄɸѡ

(C)¸ß¼¶É¸Ñ¡²»ÐèÒª½¨Á¢Ìõ¼þÇø£¬Ö»ÓÐÊý¾ÝÇøÓò¾Í¿ÉÒÔÁË (D)×Ô¶¯É¸Ñ¡¿ÉÒÔ½«É¸Ñ¡½á¹û·ÅÔÚÖ¸¶¨µÄÇøÓò¡£ ¹ØÓÚ·ÖÀà»ã×Ü£¬ÐðÊöÕýÈ·µÄÊÇ__A____¡£ (A)·ÖÀà»ã×ÜǰÊ×ÏÈÓ¦°´·ÖÀà×Ö¶ÎÖµ¶Ô¼Ç¼ÅÅÐò A (B)·ÖÀà»ã×Ü¿ÉÒÔ°´¶à¸ö×ֶηÖÀà (C)Ö»ÄܶÔÊýÖµÐÍ×ֶηÖÀà (D)»ã×Ü·½Ê½Ö»ÄÜÇóºÍ

Óйرí¸ñÅÅÐòµÄ˵·¨ÕýÈ·ÊÇ__D____¡£ (A)Ö»ÓÐÊý×ÖÀàÐÍ¿ÉÒÔ×÷ΪÅÅÐòµÄÒÀ¾Ý D (B)Ö»ÓÐÈÕÆÚÀàÐÍ¿ÉÒÔ×÷ΪÅÅÐòµÄÒÀ¾Ý (C)±Ê»­ºÍÆ´Òô²»ÄÜ×÷ΪÅÅÐòµÄÒÀ¾Ý (D)ÅÅÐò¹æÔòÓÐÉýÐòºÍ½µÐò

ΪÁËʵÏÖ¶à×ֶεķÖÀà»ã×Ü£¬ExcelÌṩµÄ¹¤¾ßÊÇ__D____¡£ (A)Êý¾ÝµØÍ¼ D (B)Êý¾ÝÁбí (C)Êý¾Ý·ÖÎö (D)Êý¾Ý͸ÊÓ±í

10

78

79

80

¹ØÓÚExcel±í¸ñ£¬ÏÂÃæËµ·¨²»ÕýÈ·µÄÊÇ__D____¡£ (A)±í¸ñµÄµÚÒ»ÐÐΪÁбêÌ⣨³Æ×Ö¶ÎÃû£© D (B)±í¸ñÖв»ÄÜÓпÕÁÐ

(C)±í¸ñÓëÆäËûÊý¾Ý¼äÖÁÉÙÁôÓпÕÐлò¿ÕÁÐ

(D)ΪÁËÇåÎú£¬±í¸ñ×ÜÊǰѵÚÒ»ÐÐ×÷ΪÁбêÌ⣬¶ø°ÑµÚ¶þÐпճöÀ´ ÔÚÒ»¸ö±í¸ñÖУ¬ÎªÁ˲鿴Âú×㲿·ÖÌõ¼þµÄÊý¾ÝÄÚÈÝ£¬×îÓÐЧµÄ·½·¨ÊÇ__C____¡£

(A)Ñ¡ÖÐÏàÓ¦µÄµ¥Ôª¸ñ C

(B)²ÉÓÃÊý¾Ý͸ÊÓ±í¹¤¾ß (C)²ÉÓÃÊý¾Ýɸѡ¹¤¾ß (D)ͨ¹ýºêÀ´ÊµÏÖ

Excelͼ±íÊǶ¯Ì¬µÄ£¬µ±ÔÚͼ±íÖÐÐÞ¸ÄÁËÊý¾ÝϵÁеÄֵʱ£¬Óëͼ±íÏà¹ØµÄ¹¤×÷±íÖеÄÊý¾Ý__C____¡£ (A)³öÏÖ´íÎóÖµ C

(B)²»±ä

(C)×Ô¶¯ÐÞ¸Ä

(D)ÓÃÌØÊâÑÕÉ«ÏÔʾ

11

²åÈëÒ»¸ö·ÖÀ¸·ûÄܹ»½«Ò³Ãæ·ÖΪÁ½F À¸

dotx¸ñʽΪÆôÓúêµÄÄ£°å¸ñʽ£¬¶øF

dotm¸ñʽÎÞ·¨ÆôÓúê

ÔÚÒ³ÃæÉèÖùý³ÌÖУ¬Èô×ó±ß¾àΪT 3cm£¬×°¶©ÏßΪ0.5cm,Ôò°æÐÄ×ó±ß¾àÀëÒ³Ãæ×ó±ßÑØµÄʵ¼Ê¾àÀëΪ3.5cm ÔÚÒ³ÃæÉèÖùý³ÌÖУ¬Èôϱ߾àΪF 2cm£¬Ò³½ÅÇøÎª0.5cm,Ôò°æÐĵײ¿¾àÀëÒ³Ãæµ×²¿µÄʵ¼Ê¾àÀëΪ2.5cm ÈçÐèʹÓõ¼º½´°¸ñ¶ÔÎĵµ½øÐбêÌâT µ¼º½£¬±ØÐëÔ¤ÏÈΪ±êÌâÎÄ×ÖÉ趨´ó¸Ù¼¶±ð¡£

T Èç¹ûɾ³ýÁËij¸ö·Ö½Ú·û£¬ÆäÇ°ÃæµÄ

12

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