µ±Ç°Î»ÖãºÊ×Ò³ > ÁúÑÒ»á¼ÆÅàѵ2015µÚ¶þÈý¼¾µçË㻯¿¼ÊÔÕæÌâÃâ·Ñѧ¸£½¨»á¼ÆÖ®¼Ò
¸£½¨»á¼ÆÖ®¼Ò ¹Ù·½Î¨Ò»ÍøÖ·£ºwww.kjfj.net
Öеġ°ÅÅÐò¡±ÃüÁî
D£®Ñ¡¶¨ÒªÅÅÐòµÄÇøÓò£¬È»ºóµ¥»÷¡°Êý¾Ý¡±²Ëµ¥ Öеġ°ÅÅÐò¡±ÃüÁî
23.²»Äܽ«¹¤×÷±í±êÇ©1ÒÆµ½ÓëÆäÏàÁڵŤ×÷±í ±êÇ©2ÓÒÃæµÄ²Ù×÷ÊÇ( )¡£
A£®½«Êó±êÖ¸ÕëÖ¸Ïò¹¤×÷±í±êÇ©1£¬Ö±½Ó½«Æä Í϶¯µ½¹¤×÷±í±êÇ©2ÓÒÃæ
Bµ¥»÷¹¤×÷±í±êÇ©1£¬°´×¡Shift¼ü²¢½«ÆäÍÏ ¶¯µ½¹¤×÷±í±êÇ©2ÓÒÃæ
C£®µ¥»÷¹¤×÷±í±êÇ©1£¬°´×¡Alt¼ü²¢½«ÆäÍ϶¯ µ½¹¤×÷±í±êÇ©2ÓÒÃæ
D£®µ¥»÷¹¤×÷±í±êÇ©1£¬°´×¡Ctrl¼ü²¢½«ÆäÍÏ ¶¯µ½¹¤×÷±í±êÇ©2ÓÒÃæ
24.ÔÚExcelÈí¼þÖУ¬µ¥Ôª¸ñÊÇÊý¾Ý±íÖд洢Êý¾Ý µÄ( )¡£
A£®Ò»¸ö¿Õ¼ä B£®×îСµ¥Î» C£®Ò»¸öµ¥Î» D£®Ò»¸ö¹«Ê½
25.ÔÚExcelÖУ¬ÊäÈëÎÄ×ÖºóÔÚµ¥ÔªÄÚµÄȱʡÏÔʾ ·½Ê½ÊÇ( )¡£
A£®¾ÓÖÐ B£®×ó¶ÔÆë C£®ÓÒ¶ÔÆë D£®¾ÓÉÏ
26.ÔÚExcelÖУ¬ÐкÍÁеÄÿ¸ö½»²æµÄλÖóÆÎª ( )¡£
A£®µØÖ·±ê¼Ç B£®µ¥Ôª¸ñ C£®-¸ö´æ´¢µ¥Î» D£®µ¥Î»
27.ÔÚExcelÖУ¬ÒªÖØÐÂÐÞ¸ÄÒ»¸öµ¥ÔªµÄÄÚÈÝʱ£¬ ͨ³£Òª( )¡£
A£®Esc¼ü B£®Ë«»÷µ¥Ôª¸ñ C£®¹â±ê±ä¼ýÍ· D£®¹â±ê±äºÚ 28.ÔÚExcelÖУ¬ÔÚͬһÐÐÖУ¬¸´ÖÆÒ»¸öÏà¶ÔµØÖ· µÄ¹«Ê½£¬ÇëÎʸ´ÖƺóµÄ¹«Ê½ÖÐÊÇ( )¡£ A£®Ðкűä B£®Áкűä
C£®ÐÐÁкÅÈ«±ä D£®ÐÐÁкŲ»±ä
29.ÔÚExcelÈí¼þÖУ¬µ±´æÓÐÊý×ֵĵ¥ÔªÏÔʾ³öÒ» ´®ÐǺÅʱ£¬Õâ±íÃ÷( )¡£ A£®Êý×Ö´ó B£®Êý×ÖС
C£®ÁпíÕÁË D£®Áпí¿íÁË
30.ÔÚExcelÖУ¬ÈôÊäÈëµÄÄÚÈݳ¬³öÁ˵¥Ôª¸ñµÄ¿í ¶È£¬Ôò( )¡£
A£®³¬³ö²¿·ÖµÄÎÄ×Ö±»ÊÓΪÎÞЧ
»á¼Æ´ÓÒµ×ʸñ¿¼ÊÔ¸¨µ¼ ÈÈÏߣº400-088-9197 QQ£º2939936118
¸£½¨»á¼ÆÖ®¼Ò ¹Ù·½Î¨Ò»ÍøÖ·£ºwww.kjfj.net B£®³¬³ö²¿·ÖµÄÎÄ×Ö½«»áÒþ²ØÆðÀ´ C£®µ¥Ôª¸ñ×Ô¶¯¼Ó¿íÒÔ±£Ö¤ÎÄ×ÖµÄÊäÈë
D£®µ¥Ôª¸ñÄÚ×Ô¶¯»»Ðв¢Ôö¼Ó¸ß¶È£¬ÒÔ±£Ö¤ÎÄ
×ÖµÄÊäÈë
31.ÔÚExcel¹¤×÷±íµÄµ¥Ôª¸ñÖУ¬ÈçÏëÊäÈëÊý×Ö×Ö ·û´®100083£¨ÀýÈ磺ÓÊÕþ±àÂ룩ʱӦÊäÈë ( )¡£
A£®100083 B£®¡°100083\ C£®100083' D£®'1O0083
38.ÒªÔÚExcel¹¤×÷±íµÄµ¥Ôª¸ñÖÐÊäÈëÈÕÆÚ£¬ÄÄÒ» ¸öÐÎʽ²»·ûºÏÈÕÆÚ¸ñʽ( )¡£ A.¡°10/01/99¡± B.01-OCT-99 C£®1999/10/01 D£®36434
39.ÔÚExcel¹¤×÷±í×óÉϽǵÄÃû³Æ¿òÖУ¬ÊäÈë²»ÊÇ ÒýÓÃBÁеÚÎåÐе¥Ôª¸ñµÄÊÇ( )¡£ A£®SB B£®$B$5 C£®B5 D£®$Bo 40.ÔÚExcel¹¤×÷±íµÄµ¥Ôª¸ñA2ÖÐÊäÈë( )ʹ ÆäÏÔʾ0.2¡£
A£®36896 B£®1/5 C£®1/5 D£®0.2
41.ÏÂÁÐ˵·¨ÖÐÕýÈ·µÄÒ»ÌõÊÇ( )¡£
A£®ÔÚExcel¹¤×÷±íÖУ¬Í¬Ò»ÁÐÖеIJ»Í¬µ¥¸ñ µÄÊý¾Ý¸ñʽ¿ÉÒÔÉèÖóɲ»Í¬
B£®ÔÚExcel¹¤×÷±íÖУ¬Í¬Ò»ÁÐÖеĸ÷µ¥Ôª¸ñµÄ Êý¾Ý¸ñʽ±ØÐëÉèÖóÉÏàͬ
C£®ÔÚExcel¹¤×÷±íÖУ¬Ö»ÄÜÇå³ýµ¥Ôª¸ñÖеÄÄÚ ÈÝ£¬²»ÄÜÇå³ýµ¥Ôª¸ñµÄ¸ñʽ
D£®ÔÚExcel¹¤×÷±íÖУ¬µ¥Ôª¸ñÖеÄÊý¾ÝÖ»ÄÜ ×ó¶ÔÆë
42.ÔÚÒ»¸öExcel¹¤×÷±íµÄµ¥Ôª¸ñÖÐÊäÈ빫ʽʱ£¬ ¹«Ê½¿ªÍ·Ó¦¸ÃÊä( )¡£ A£®£¡ B£®SUM
C£®AVERAGE D£®=
43.ÏÂÁвÙ×÷ÖУ¬²»ÄÜʵÏÖÑ¡¶¨Ò»¸öExcel¹¤×÷±í ÇøÓòA1£ºD8µÄ²Ù×÷ÊÇ( )¡£
A£®µ¥»÷Alµ¥Ôª¸ñ£¬È»ºó°´×¡Shift¼ü£¬ÔÙµ¥»÷ D8µ¥Ôª¸ñ
B£®µ¥»÷Alµ¥Ôª¸ñ£¬È»ºó°´×¡CTRL¼ü£¬ÔÙµ¥ »÷D8µ¥Ôª¸ñ
»á¼Æ´ÓÒµ×ʸñ¿¼ÊÔ¸¨µ¼ ÈÈÏߣº400-088-9197 QQ£º2939936118
¸£½¨»á¼ÆÖ®¼Ò ¹Ù·½Î¨Ò»ÍøÖ·£ºwww.kjfj.net C£®µ¥»÷Alµ¥Ôª¸ñ£¬È»ºó°´×¡Êó±ê×ó¼ü²»·Å£¬ ÔÙÍÏÊó±ê¼ýÍ·ÖÁD8µ¥Ôª¸ñ
D£®°´×¡CTRL¼ü£¬ÔÙµ¥»÷AI£ºD8ÇøÓòµÄËùÓÐ µ¥Ôª¸ñ
44.ÏÂÁйØÓÚExcel 2013µÄ˵·¨ÖУ¬´íÎóµÄÒ»ÌõÊÇ ( )¡£
A£®¹¤×÷²¾Öеĸ÷¹¤×÷±íµÄ˳ÐòÊÇ¿ÉÒÔÓÃÍ϶¯ ¹¤×÷±í±êÇ©µÄ·½·¨À´¸Ä±ä
B£®µ¥»÷¡°¿ªÊ¼¡±Ñ¡À²Ëµ¥Öеġ°µ¥Ôª¸ñ¡±¡°²åÈ롱 ¡°²åÈ빤×÷±í¡±ÃüÁî¿ÉÒÔÔÚµ±Ç°¹¤×÷±í֮ǰ ²åÈëÒ»Õſհ×
C£®µ¥»÷¡°¿ªÊ¼¡±Ñ¡À²Ëµ¥Öеġ°µ¥Ôª¸ñ¡±¡°²åÈ롱
¡°²åÈ˹¤×÷±íÁС±ÃüÁî¿ÉÒÔÔÚÑ¡¶¨ÁеÄ×ó±ß ²åÈëÓëÑ¡¶¨µÄÁÐÊýÄ¿µÄ¿Õ°×ÁÐ D£®µ¥»÷¡°¿ªÊ¼¡±Ñ¡À²Ëµ¥Öеġ°µ¥Ôª¸ñ¡±¡°É¾³ý¡± ¡°É¾³ýµ¥Ôª¸ñ¡±ÃüÁîֻɾ³ýµ±Ç°¹¤×÷±íÖÐµÄ È«²¿Êý¾Ý
45.ÔÚExcel¹¤×÷±íµÄÿ¸öµ¥Ôª¸ñÖУ¬×î¶à¿ÉÊäÈë ( )×Ö·û¡£
A£®32 000 B£®2 400 C£®2 000 D£®256
46.ÔÚExcel 2003¹¤×÷±íA4µ¥Ôª¸ñÖУ¬ÈçÒª½«Ô À´µÄÈÕÆÚÐÍÊý¾ÝÇå³ý²¢¸Ä³ÉÄÜÊäÈëÊýÖµÐÍÊý ¾Ý£¬ÕýȷΪ( )¡£
A£®µ¥»÷A4µ¥Ôª¸ñ£¬Ñ¡Ôñ¡°±à¼¡±²Ëµ¥Ïµġ°Çå ³ý¡±Ïµġ°¸ñʽ¡±
B£®µ¥»÷A4µ¥Ôª¸ñ£¬Ñ¡Ôñ¡°±à¼¡±²Ëµ¥Ïµġ°É¾ ³ý¡±
C£®µ¥»÷A4µ¥Ôª¸ñ£¬Ñ¡Ôñ¡°±à¼¡±²Ëµ¥Ïµġ°Çå ³ý¡±Ïµġ°ÄÚÈÝ¡±
D£®µ¥»÷A4µ¥Ôª¸ñ£¬Ñ¡Ôñ¡°±à¼¡±²Ëµ¥Ïµġ°Çå ³ý¡±Ïµġ°È«²¿¡±
47.´´½¨Excel 2003¹¤×÷±íʱ£¬( )²Ù×÷¿ÉÒÔɾ ³ý¹¤×÷±íCÁС£
A£®µ¥»÷ÁкÅC£¬Ñ¡Ôñ¡°Îļþ¡±²Ëµ¥Ïµġ°É¾³ý¡± B£®µ¥»÷ÁкÅC£¬Ñ¡Ôñ¡°±à¼¡±²Ëµ¥Ïµġ°É¾³ý¡± C£®µ¥»÷ÁкÅC£¬Ñ¡Ôñ¹¤¾ßÌõÉϵġ°¼ôÇС±°´Å¥¡£ D£®µ¥»÷ÁкÅC£¬Ñ¡Ôñ¡°±à¼¡±²Ëµ¥Ïµġ°Çå³ý¡± ϵġ°È«²¿¡±
48.ÔÚExcel¹¤×÷±íÖУ¬ÏÂÁеÄÊäÈë( )ÊÇÕýÈ·
»á¼Æ´ÓÒµ×ʸñ¿¼ÊÔ¸¨µ¼ ÈÈÏߣº400-088-9197 QQ£º2939936118
¸£½¨»á¼ÆÖ®¼Ò ¹Ù·½Î¨Ò»ÍøÖ·£ºwww.kjfj.net µÄ¹«Ê½ÐÎʽ¡£ A£®A1* D2+100 B£®AI+A8
C£®SUM(AI:DI)
D£®=1. 57* Sheet2 1 82
49. Excel 97µç×Ó±í¸ñ´æ´¢Êý¾ÝµÄ×îСµ¥Î»ÊÇ ( )¡£
A£®¹¤×÷²¾ B£®¹¤×÷±íÃû C£®µ¥Ôª¸ñ D£®¹¤¼þÇøÓò 50.Óйع¤×÷±íÐðÊöÕýÈ·µÄÊÇ( )¡£ A£®¹¤×÷±íÊǼÆËãºÍ´æ´¢Êý¾ÝµÄ B£®¹¤×÷±íµÄÃû³ÆÔÚ¹¤×÷²¾µÄ¶¥²¿ C£®ÎÞ·¨¶Ô¹¤×÷±íµÄÃû³Æ½øÐÐÐÞ¸Ä
D£®¹¤×÷±íĬÈÏÃû³Æ±íʾΪ¡°Sheetl£¬Sheet2
¸£½¨»á¼ÆÖ®¼Ò£¨www.kjfj.net)ÍøÐ£×ܽá¶àÄê³É¹¦¸¨µ¼¾Ñ飬½áºÏ»á¼Æ´ÓÒµ×ʸñ¿¼ÊÔÃüÌâ¹æÂÉ¡¢Öص㡢Äѵ㣬ÈÚÈëÏȽøµÄ½ÌѧÀíÄî ¿Î³ÌÑϸñ°´¿¼ÊÔ´ó¸ÙºÍ²ÆÕþÌüÖ¸¶¨½Ì²ÄÊڿΣ¬ÓµÓжàÄêʵ¼Ê×öÕ˺ͽÌѧ¾
»á¼Æ´ÓÒµ×ʸñ¿¼ÊÔ¸¨µ¼ ÈÈÏߣº400-088-9197 QQ£º2939936118
¸£½¨»á¼ÆÖ®¼Ò ¹Ù·½Î¨Ò»ÍøÖ·£ºwww.kjfj.net
ÑéµÄÀÏʦ¾«ÐÄÊÚ¿ÎÊÓÆµ¿Î³Ì°à´ÎÓУ¬³¬Öµ°à£¬±£¹ý°à£¬ÊµÑé°à£¬ÎÞÖ½»¯¿¼ÊÔϵͳ£¬ÕæÊµ¿¼³¡µÈÍøÐ£Â¡ÖØÍÆ³ö±£¹ý°àÓÅ»ÝÌײÍÈý¿Æ¿Î³ÌÄÚÈݰüÀ¨:ÀíÂÛ¿¼ÊÔ¿Æ+ µçË㻯+ Èý¿ÆÎÞÖ½»¯¿¼ÊÔϵͳ+ ϰÌ⾫½²°à+ ¿¼Ç°ÑºÌâ+ µçË㻯˼ŵÁ·Ï°Æ½Ì¨+ ÕæÊµ¿¼³¡ÏµÍ³»¹¿ÉÔÙÃâ·Ñ»ñÈ¡¼ÛÖµ688ÔªµÄ×îС¶Áã»ù´¡»á¼ÆÊÖ¹¤ºÍ²ÆÎñÈí¼þ×öÕËËٳɰࡷ¿Î³Ì£¬ÅäÓÐÈ«Ì××öÕ˹¤¾ß(º¬»á¼ÆÆ¾Ö¤¡¢Ôʼƾ֤µÈ)£¡Ö»ÒªÄúÓÐÐÅÐÄÕÆÎÕÎÒÃÇÍøÐ£µÄѧϰ×ÊÁÏ£¬ÎÒÃǾÍÓÐÐÅÐı£Ö¤Äú¿ÉÒÔ˳Àûͨ¹ýÎÒÃǵĸ£½¨»á¼Æ¿¼ÊÔ£¬È¡µÃÄúÃÎÃÁÒÔÇóµÄ»á¼ÆÉϸÚÖ¤£¡
¸£½¨»á¼ÆÖ®¼Ò(kjfj.net)¡ï¡ï¸ßͨ¹ýÂÊ£¬Á¼ºÃµÄ¿Ú±®~~Ö»ÒªÄúÓÐÐÅÐÄÕÆÎÕÎÒÃÇÍøÐ£µÄѧϰ×ÊÁÏ£¬ÎÒÃǾÍÓÐÐÅÐı£Ö¤Äú¿ÉÒÔ˳Àûͨ¹ýÎÒÃǵĸ£½¨»á¼Æ¿¼ÊÔ£¬È¡µÃÄúÃÎÃÁÒÔÇóµÄ»á¼ÆÉϸÚÖ¤£¡
»á¼Æ´ÓÒµ×ʸñ¿¼ÊÔ¸¨µ¼ ÈÈÏߣº400-088-9197 QQ£º2939936118
¹²·ÖÏí92ƪÏà¹ØÎĵµ