°à¼¶
ÐÕÃû
ѧºÅ
Íû³ÇÇøÖ°ÒµÖÐר2019ѧÄêµÚһѧÆÚÆÚÖп¼ÊÔ
¡¶¼ÆËã»úÓ¦Óûù´¡¡·ÀíÂÛ¿¼ÊÔÊÔÌâ
£¨ÊÊÓð༶£º¼ÆËã»ú57°à £©
ÌâºÅ Ò» ¶þ Èý ËÄ Îå ×Ü·Ö µÃ·Ö Ò»¡¢µ¥ÏîÑ¡ÔñÌ⣨2*15£¬¹²30·Ö£©
1.PowerPoint2010 ϵͳĬÈϵÄÊÓͼ·½Ê½ÊÇ£¨ £©
A£®´ó¸ÙÊÓͼ B£®»ÃµÆƬä¯ÀÀÊÓͼ C£®ÆÕͨÊÓͼ D£®»ÃµÆƬÊÓͼ
2. ÔÚEXCEL 2010ÖУ¬ÁпíºÍÐÐ¸ß £¨ £© ¡£
A£®¶¼¿ÉÒԸıä B.Ö»ÄܸıäÁпí C.Ö»ÄܸıäÐÐ¸ß D.¶¼²»Äܸıä 3. EXCEL 2010ËùÊôµÄÌ××°Èí¼þÊÇ£¨ £©
A£®LOTUS 2010 B. Windows 2010 C. Office 2010 D. Word 2010 4. ÔÚÑÝʾÎĸåÖУ¬¸ø»ÃµÆƬÖØÐÂÉèÖñ³¾°£¬ÈôÒª¸øËùÓлõÆƬʹÓÃÏàͬ±³¾°£¬ÔòÔÚ¡°±³¾°¡±¶Ô»°¿òÖÐÓ¦µ¥»÷£¨ £©°´Å¥¡£
A. È«²¿Ó¦Óà B. Ó¦Óà C. È¡Ïû D. ÖØÖñ³¾°
5£®EXCEL 2010¹¤×÷±¡ÎļþµÄĬÈÏÀ©Õ¹ÃûΪ£¨ £©
A£®doc B£®xls C£®ppt D£®mdb
6. ÏÂÁУ¨ £©²»ÊôÓÚ PowerPoint2010 ´´½¨µÄÑÝʾÎĸåµÄ¸ñʽÎļþ±£´æÀàÐÍ¡£
A£®PowerPoint·ÅÓ³ B£®RTF Îļþ C£®PowerPointÄ£°å D£®WORDÎĵµ
7. Ñ¡ÔñÈ«²¿»ÃµÆƬʱ£¬¿ÉÓÿì½Ý¼ü£¨ £©
A£®Shift+A B. Ctr+A C£®F3 D£®F4
8£®ÔÚEXCEL 2010ÖУ¬ÇóÒ»×éÊýÖµÖеÄƽ¾ùÖµº¯ÊýΪ£¨ £© A£®AVERAGE B£®MAX C£®MIN D£®SUM
9. ÔÚEXCEL 2010ÖУ¬µ¥Ôª¸ñB2µÄÁÐÏà¶ÔÐоø¶ÔµÄ»ìºÏÒýÓõØַΪ£¨ £© A¡¢$B$2
B¡¢$B2 C¡¢B$2
D¡¢B2
10. EXCEL 2010Ö÷½çÃæ´°¿ÚÖбà¼À¸Éϵġ°fx¡±°´Å¥ÓÃÀ´Ïòµ¥Ôª¸ñ²åÈ루 £© A¡¢ÎÄ×Ö B¡¢Êý×Ö C¡¢¹«Ê½ D¡¢º¯Êý
11. Excel 2010ϵͳÖУ¬ÏÂÁÐÐðÊöÕýÈ·µÄÊÇ£¨ £© A. Ö»ÄÜ´ò¿ªÒ»¸öÎļþ B. ×î¶àÄÜ´ò¿ª4¸öÎļþ C. ÄÜ´ò¿ª¶à¸öÎļþ£¬µ«²»ÄÜͬʱ½«ËüÃÇ´ò¿ª D. ÄÜ´ò¿ª¶à¸öÎļþ£¬²¢ÄÜͬʱ½«ËüÃÇ´ò¿ª 12.»æÖÆԲʱ£¬ÐèÒª°´Ï£¨ £©¼üÔÙÍ϶¯Êó±ê¡£ A£®Shift B. Ctrl C£®F3 D£®F4
13. EXCEL 2010ÖУ¬Èç¹ûB2¡¢B3¡¢B4¡¢B5µ¥Ôª¸ñµÄÄÚÈÝ·Ö±ðÊÇ4¡¢2¡¢5¡¢=B2*B3-B4£¬ÔòB2¡¢B3¡¢B4¡¢B5µ¥Ôª¸ñʵ¼ÊÏÔʾµÄÄÚÈÝ·Ö±ðÊÇ£¨ £© A. 4 2 5 2 B. 2 3 4 5 C. 5 4 3 2 D.4 2 5 3 14. ÔÚEXCEL 2010ÖУ¬ÒÔϹ«Ê½ÖÐÕýÈ·µÄÊÇ£¨ £© A. =A1+B1 B. =¡¯¼ÆËã»ú¡¯&¡¯Ó¦ÓᯠC. =¡°¼ÆËã»ú¡±&¡°Ó¦Óá± D. =(¼ÆËã»ú)&(Ó¦ÓÃ) 15.PowerPointÖУ¬ÏÂÁÐ˵·¨ÖдíÎóµÄÊÇ£¨ £©
A.¿ÉÒÔ¶¯Ì¬ÏÔʾÎı¾ºÍ¶ÔÏó B.¿ÉÒÔ¸ü¸Ä¶¯»¶ÔÏóµÄ³öÏÖ˳Ðò C.ͼ±íÖеÄÔªËز»¿ÉÒÔÉèÖö¯»Ð§¹û D.¿ÉÒÔÉèÖûõÆƬÇл»Ð§¹û ¶þ¡¢¶àÏîÑ¡ÔñÌ⣨3*5£¬¹²15·Ö£©
1.ÒªÔÚѧÉú³É¼¨±íÖÐɸѡ³öÓïÎijɼ¨ÔÚ85·ÖÒÔÉϵÄͬѧ,¿Éͨ¹ý£¨ £© A. ×Ô¶¯É¸Ñ¡ B. ×Ô¶¨Òåɸѡ C. ¸ß¼¶É¸Ñ¡
D. Ìõ¼þ¸ñʽ
2.ÒÔÏÂ˵·¨ÕýÈ·µÄÊÇ£¨ £©
A. ÔÚWordÖУ¬ÊÓͼĬÈϵÄÊÓͼΪÆÕͨÊÓͼ B. ÔÚExcelÖУ¬ÊÓͼĬÈϵÄÊÓͼΪÆÕͨÊÓͼ C. ÔÚPowerPointÖУ¬ÊÓͼĬÈϵÄÊÓͼΪÆÕͨÊÓͼ
D. ÒÔÏ´ð°¸Ö»ÓÐA¡¢BÕýÈ·
3.ÒÔÏÂÑ¡ÏîÖÐ,ÖÐÎÄ°æʽ·½Ê½°üÀ¨ÒÔϼ¸ÖÖ£¨ £© A. Æ´ÒôÖ¸ÄÏ B. ´øȦ×Ö·û C. Ë«ÐкÏÒ»
D. ×ݺá»ìÅÅ
4.ÔÚExcel 2010ÖУ¬¡°Delete¡±ºÍ¡°È«²¿Çå³ý¡±ÃüÁîµÄÇø±ðÔÚÓÚ£¨ £© A. Delete ɾ³ýµ¥Ôª¸ñµÄÄÚÈÝ£¬¸ñʽºÍÅú×¢
B. Delete ½öÄÜɾ³ýµ¥Ôª¸ñµÄÄÚÈÝ
C. Çå³ýÃüÁî¿Éɾ³ýµ¥Ôª¸ñµÄÄÚÈÝ£¬¸ñʽ»òÅú×¢
1
D. Çå³ýÃüÁî½öÄÜɾ³ýµ¥Ôª¸ñµÄÄÚÈÝ
5.ÔÚExcel 2010ÖÐ,¹¤×÷±í¡°ÏúÊ۶ÖеÄB2:H308Öаüº¬ËùÓеÄÏúÊÛÊý¾Ý£¬ÔÚ¹¤×÷±í¡°»ã×Ü¡±ÖÐÐèÒª¼ÆËã»úÏúÊÛ×ܶ¿É²ÉÓÃÄÄЩ·½·¨£¨ £© A. ÔÚ¹¤×÷±í¡°»ã×Ü¡±ÖУ¬ÊäÈë¡°=ÏúÊ۶(B2:H308)¡±
B. ÔÚ¹¤×÷±í¡°»ã×Ü¡±ÖУ¬ÊäÈë¡°=SUMÏúÊ۶(B2:H308)¡±
C. ÔÚ¹¤×÷±í¡°ÏúÊ۶ÖУ¬Ñ¡ÖÐB2:H308ÇøÓò£¬²¢ÔÚÃû³Æ¿òÊäÈë¡°sales ¡±ÔÚ¹¤×÷±í¡°»ã×Ü¡±ÖУ¬ÊäÈë¡°=sales ¡±
D. ÔÚ¹¤×÷±í¡°ÏúÊ۶ÖУ¬Ñ¡ÖÐB2:H308ÇøÓò£¬²¢ÔÚÃû³Æ¿òÊäÈë¡°sales ¡±ÔÚ¹¤×÷±í¡°»ã×Ü¡±ÖУ¬ÊäÈë¡°=SUM(sales)¡± Èý¡¢ÅжÏÌ⣨2*5£¬¹²10·Ö£©
1.Microsoft Office Excel 2010ÊÇMicrosoft¹«Ë¾ÍƳöµÄOfficeϵÁа칫Èí¼þÖеĵç×Ó±í¸ñ´¦ÀíÈí¼þ£¬Êǰ칫×Ô¶¯»¯¼¯³ÉÈí¼þ°üµÄÖØÒª×é³É²¿·Ö¡££¨ £© 2.£®PowerPoint 2010¾ßÓж¯»¹¦ÄÜ£¬¿Éʹ»ÃµÆƬÖеĸ÷ÖÖ¶ÔÏóÒÔ³äÂú¶¯¸ÐµÄÐÎʽ չʾÔÚÆÁÄ»ÉÏ¡££¨ £©
3.±à¼À¸ÓÃÓڱ༵±Ç°µ¥Ôª¸ñµÄÄÚÈÝ¡£Èç¹û¸Ãµ¥Ôª¸ñÖк¬Óй«Ê½£¬Ôò¹«Ê½µÄÔËËã½á¹û»áÏÔʾÔÚµ¥Ôª¸ñÖУ¬¹«Ê½±¾Éí»áÏÔʾÔÚ±à¼À¸ÖС££¨ £©
4£®ÔÚPowerPoint 2010µÄ¡°»ÃµÆƬä¯ÀÀ¡±ÊÓͼÖпÉÒÔ¸øÒ»ÕŻõÆƬ»ò¼¸ÕŻõÆƬÖеÄËùÓжÔÏóÌí¼ÓÏàͬµÄ¶¯»Ð§¹û¡££¨ £©
5.Ñ¡ÔñÁ½¸ö²»ÏàÁÚµÄÇøÓòµÄÒ»ÖÖ·½·¨ÊÇ£ºÏÈÑ¡ÔñÒ»¸öÇøÓò£¬ÔÙ°´×¡Shift¼üÑ¡ÔñÁíÒ»¸öÇøÓò¡££¨ £©
ËÄ¡¢²Ù×÷Ì⣨5*5£¬¹²25·Ö£©
1.ÓÐÒ»¸öEXCELÊý¾Ý±í£¬ÇøÓòC3-C52ÊÇѧÉú°à¼¶£¬ÇøÓòE3-E52ÊǸßÊý³É¼¨, ÇøÓòF3-F52ÊÇÓ¢Óï³É¼¨£¬ÇøÓòK3-K52ÊÇѧÉú×Ü·Ö£¬¸ù¾ÝÉÏÊöÒÑÖªÌõ¼þÓú¯ÊýÇóÏÂÁÐÎÊÌ⣺ ¢Ù10ÎïÁ÷1°àÈËÊý£¨Ð´³öÍêÕûº¯Êýʽ×Ó£©
¢Ú10·2°àÓ¢Óï×Ü·Ö£¨Ð´³öÍêÕûº¯Êýʽ×Ó£©
¢ÛÓ¢Óï×î¸ß·Ö£¨Ð´³öÍêÕûº¯Êýʽ×Ó£©
¢ÜÒÔ×Ü·Ö½øÐÐÅÅÃû£¬½µÐòÅÅÁУ¨Ð´³öÍêÕûº¯Êýʽ×Ó£©
¢Ý¸ßÊý×îµÍ·Ö£¨Ð´³öÍêÕûº¯Êýʽ×Ó£©
Îå¡¢ÀíÂÛÌ⣨4*5£¬¹²20·Ö£©
1.ÈçÏÂͼËùʾ£º½âÊͺ¯Êýʽ²¢Ð´³öº¯Êýʽ½á¹û
=COUNTIF(A1:C4,¡±>=1000¡±) =_____
=COUNTIF(A1:C4,¡±>=100¡±)-COUNTIF(A1:C4,¡±>2000¡±)=_______
2. ÈçÏÂͼËùʾ£º½âÊͺ¯Êýʽ²¢Ð´³öº¯Êýʽ½á¹û
=SUM(6,8)= _______ =SUM(A1,C1)= _______ =SUM(A1:C1)= _______
3.д³öÏÂÁк¯Êýʽ½á¹û
¢Ù=LEN(¡°abcdefg¡±)= _______
¢Ú=CONCATENATE(¡°ab¡±,¡°cd¡±,¡°ef¡±)= _______ ¢Û=LEFT(¡°abcdefg¡±,3)= _______ ¢Ü=RIGHT(¡°abcdefg¡±,3)= _______ ¢Ý=MID(¡°abcdefg¡±,2,3)= ______
2