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