È«¹úÖ°³Æ¼ÆËã»ú¿¼ÊÔÌâ¿â¡ª¡ªExcel2007Ä£¿é
Excel2007Ä£¿é µÚ1Ì×ÊÔÌâ
1.½«µ±Ç°¹¤×÷²¾ÎļþµÄ´ò¿ªÈ¨ÏÞÃÜÂëÖØÐÂÉèÖÃΪ¡°999abc¡±£¬ÐÞ¸ÄȨÏÞÃÜÂë²»±ä£¬²¢ÔÚ±£´æµÄͬʱÉú³É±¸·ÝÎļþ¡£
2.½«\¹¤×÷²¾ÖеÄ\¸ßÊý\¹¤×÷±íÖØÃüÃûΪ\¸ßµÈÊýѧ\ºó,ÉèÖÃ\Îļþ\²Ëµ¥µ×²¿²»ÏÔÊ¾Ôø¾´ò¿ª¹ýµÄÎļþÃû³Æ¡£
3.ÔÚµ±Ç°¹¤×÷±íÖÐÉ趨C2:F13µ¥Ôª¸ñÇøÓòÖдóÓÚ80µÄÉèÖÃΪÂÌÌî³äÉ«ÉîÂÌÉ«Îı¾¡£
4.ÐÞ¸Ä×Ô¶¯¸üÕý´Ê¿âÖдæÔÚµÄ\ÖÐÐÇ\´ÊÌõ,ʹµÃ½«À´ÔÚ¼üÈë\ÖÐÐÇ\ºóÄܹ»Ì滻Ϊ\ÖÐÐÇÈí¼þ¿Æ¼¼ÓÐÏÞ¹«Ë¾\¡£
5.B1µ¥Ôª¸ñÒѾÉèÖÃΪÈÕÆÚ¸ñʽ£¬ÇëÊäÈ뺯Êý£¬ÏÔʾ½ñÌìµÄÈÕÆÚ¡£ 6.½«¸ø¶¨µÄÕÛÏßͼÖС°Ç®¶þ¡±µÄÊý¾ÝÏÔʾÊý¾Ý±êÇ©£¬²¢·ÅÖÃÔÚÊý¾ÝµãÏ·½¡£ 7.±£´æµ±Ç°µÄ¹¤×÷Çø¡£
8.½«µ±Ç°¹¤×÷±íµÄ×ܳɼ¨ºÍƽ¾ù³É¼¨ËùÔÚµÄÁ½ÁÐɾ³ý¡£ 9.ÔÚµ±Ç°¹¤×÷²¾ÖÐ,ÉèÖÃÏÔʾËùÓÐÅú×¢¡£
10.µ¼ÈëÎÒµÄÊý¾ÝÔ´ÖеÄÎı¾Îļþ\³É¼¨±í.txt\£¨ÆäËüĬÈÏ£©¡£
11.¸ù¾Ý¹¤×÷±íÖеĶÌÓï,ÔÚµ±Ç°µ¥Ôª¸ñÊäÈ빫ʽ,ʹµÃ¶ÌÓïÁ¬½Ó³É¾ä×Ó:\birthday to you\¡£
12.ÉèÖõ±Ç°µ¥Ôª¸ñµÄÎı¾ËõС×ÖÌåÌî³ä¡£
13.ÀûÓõ¥Ôª¸ñʽÃû³Æ¿ò´Óµ±Ç°¹¤×÷±íÖ±½ÓÑ¡¶¨Sheet4¹¤×÷±íÖÐÃû³ÆÎª\±±¾©\µÄµ¥Ôª¸ñÇøÓò¡£
14.ɾ³ý¼ôÌù°åÖеġ°ÖÐÐÇÈí¼þ¿Æ¼¼ÓÐÏÞ¹«Ë¾¿Í·þС»ª»¶ÓÄ㡱ÏîÄ¿¡£ 15.°Ñµ±Ç°¹¤×÷±íÒ³ÃæÉèÖÃΪºáÏò,Ö½ÕÅ´óСΪ\¡£
16.ÉèÖÃÔÚ´òÓ¡µ±Ç°¹¤×÷±íʱ´òÓ¡³öÍø¸ñÏß¡££¨²»Ê¹ÓôòÓ¡Ô¤ÀÀ¹¦ÄÜ£©¡£ 17.¹²Ïíµ±Ç°¹¤×÷²¾,²¢ÉèÖÃÿ20Ìì±£´æÐÞ¶©¼Ç¼¡£
18.ÔÚµ±Ç°µ¥Ôª¸ñÖмÆËãÕųÉÏéÈ«ÄêµÄרҵ¿ÎµÄ×ܳɼ¨£¨ÉÏѧÆÚ+ÏÂѧÆÚ£©¡£ 19.ÉèÖôòÓ¡µ±Ç°¹¤×÷²¾ËùÓй¤×÷±í,¸÷2·Ý¡£
20.½«\ÎÒµÄÎĵµ\Îļþ¼ÐÖеÄExcelÎļþ\³É¼¨±í.xlsx\ÒÔ¶ÔÏóÐÎʽǶÈëµ½ÒÔµ±
ǰµ¥Ôª¸ñΪÆðµãµÄÇøÓòÖÐ,²¢Á´½Óµ½Îļþ
21.ÒÔÑ¡ÖÐÇøÓòµÄµÚÒ»¸öµ¥Ôª¸ñÖÐÊý×ÖΪÆðʼֵ,²½³¤Îª5,ÖÕֵΪ30,ÏòÏÂÌî³äµÈ²îÊýÁС£
22.Æô¶¯Excel,²¢Í¬Ê±´´½¨Ò»¸ö¿Õ°×¹¤×÷²¾¡£
23.½«Ñ¡Öе¥Ôª¸ñµÄÃû³ÆÃüÃûΪ\±êÌâ\£¨Êǵ±Ç°Êý¾ÝµÄ±êÌ⣺ÎÒ¹ú²¿·ÖÊ¡ÊнÌÓýѧԺ±¾×¨¿ÆÑ§ÉúÊý£©¡£
24.ÔÚ¹¤×÷±íSheet2ÓëSheet3Ö®¼ä²åÈëÒ»ÕÅй¤×÷±í,²¢½«¹¤×÷±íSheet1ÖеÄÄÚÈݸ´ÖƵ½Sheet5ÖеÄÏàÍ¬ÇøÓòÄÚ¡£
25.Çó³öÖ°³ÆÊÇ¡°½ÌÊÚ¡±µÄ½ÌʦµÄ×÷Òµ´ÎÊýÖ®ºÍ£¬½«½á¹û±£´æÔÚJ15µ¥Ôª¸ñÖС£ 26.ÀûÓÃExcel°ïÖúµÄËÑË÷,¿ìËÙ²éÕÒÓйØ\ÏÔʾ»òÒþ²ØÍ¼±íÍø¸ñÏß\µÄ°ïÖúÐÅÏ¢,²¢ÏêϸÏÔʾ¡£
27.½«¸ø¶¨Í¼±íµÄ·ÖÀà¼ä¾àÉèÖÃΪ150%¡£
28.ÔÚÒÑÓеÄ×Ô¶¨ÒåÐòÁС°´º¡¢Å¯¡¢»¨¡±µÄ×îºóÔÙÌí¼ÓÒ»¸öÖµ\¿ª¡±¡£ 29.Ç뽫µ±Ç°¹¤×÷±í±í1Êý¾ÝºÍ±í2Êý¾Ý,½øÐкϲ¢¼ÆËã,²¢´æ·Åµ½Í³¼Æ±í¡£ 30.½«µ±Ç°¹¤×÷²¾ÉèÖõı£»¤\½á¹¹\ºÍ\´°¿Ú\¸ÄΪֻ±£»¤\´°¿Ú\ÔÃÜÂëΪ123,ÐÂÃÜÂëÉèÖÃΪ456¡£
31.ÔÚµ±Ç°Ñ¡Öе¥Ôª¸ñ×ó²à²åÈëÒ»ÁÐ,¸ñʽÓ뵱ǰÁÐÏàͬ¡£ 32.ÔÚµ±Ç°¹¤×÷±íÖÐ,½«´°¿Úƽ¾ù²ð·ÖΪ4¸ö´°¸ñ¡£
33.ÔÚµ±Ç°¹¤×÷±íÖÐ,½«B3:E6µ¥Ôª¸ñµÄÊý×Ö¸ñʽ¸ÄΪ2λСÊý£¬Ê¹ÓÃǧ·Öλ·Ö¸ô·û¡£
34.ÔÚµ±Ç°¹¤×÷±íÖÐ,ͨ¹ý¶Ô»°¿ò°ÑF6µ¥Ôª¸ñµÄÑÕÉ«ÉèÖÃΪºìÉ«£¨±ê׼ɫµÚ2ÁУ©,×ÖÌå¼Ó´Ö¡£
35.ÔÚµ±Ç°ExcelÖÐ,´ò¿ª\ÎÒµÄÎĵµ\ÖеÄ:³É¼¨±í.xlsx,²¢Óø±±¾·½Ê½´ò¿ª¡£ 36.н¨Ò»¸öÎļþ¡°³É¼¨±í¡±ÎªÄ£°åµÄ¹¤×÷²¾£¬²¢±£´æµ½Ä¬ÈÏλÖã¬ÎļþÃûҲĬÈÏ¡£
37.ÔÚµ±Ç°¹¤×÷±íÖÐÀûÓù¤¾ßÀ¸Ãæ°å¶Ô³É¼¨1°´µÝ¼õ˳Ðò½øÐÐÅÅÐò¡£ 38.ÇëÊäÈ뺯Êý£¬ÔÚµ±Ç°µ¥Ôª¸ñÖУ¬¼ÆËãB4µ½B12µ¥Ôª¸ñÊý¾ÝµÄºÍ¡£ 39.Ϊ¸ø¶¨µÄͼ±íµÄÀîËÄÊý¾ÝϵÁÐ,Ìí¼ÓÖÜÆÚΪ3µÄÒÆ¶¯Æ½¾ùÐÍÇ÷ÊÆÏß¡£ 40.ÔÚµ±Ç°¹¤×÷±íH16µ¥Ôª¸ñÖÐ,ÀûÓú¯Êýͳ¼ÆB2:H14ÇøÓòÖÐÊý×ÖÏîµÄ¸öÊý¡£
Excel2007Ä£¿é µÚ2Ì×ÊÔÌâ
1.Çå³ýµ±Ç°¹¤×÷±íµÄËùÓйæÔò¡£
2.ɾ³ýµ±Ç°¹¤×÷²¾ÖÐÃûΪ\µÄ¹¤×÷±í¡£
3.ÉèÔ±¹¤¹¤×ÊÓÉ»ù±¾¹¤×Ê¡¢¸Úλ½òÌùºÍ¼¨Ð§¹¤×Ê×é³É,ÔÚµ±Ç°¹¤×÷±íI3µ¥Ôª¸ñÖÐÓù«Ê½ºÍÏà¶ÔÒýÓ÷½·¨£¨²»Óú¯Êý£©¼ÆËã\ÐìÊ÷Çì\µÄ\×ܹ¤×Ê\¡£ÔÚµ±Ç°¹¤×÷±íÖÐÒÑÓлù±¾¹¤×Ê,¸Úλ½òÌùÔÚsheet2µÄC3µ¥Ôª¸ñÖÐ,¼¨Ð§¹¤×ÊÔÚSheet3µÄF3µ¥Ôª¸ñÖУ¨¹«Ê½ÖеĵØÖ·²»ÓÃÊó±êµ¥»÷µ¥Ôª¸ñµÄ·½·¨Ñ¡¶¨£©¡£ 4.Ñ¡¶¨µ±Ç°¹¤×÷±íÖеÄA2:A4µ¥Ôª¸ñÇøÓò,D4µ¥Ôª¸ñÒÔ¼°µÚ7ÐС£ 5.ÔÚBÁÐ×ó²à²åÈëÁ½ÁиñʽÓëÆäÏàͬ¡£
6.½«µ±Ç°Word´°¿ÚÄÚÑ¡Öбí¸ñ¸´ÖƵ½Excel´°¿ÚSheet1¹¤×÷±íÖÐÒÔA1µ¥Ôª¸ñΪ×óÉϽǵĵ¥Ôª¸ñÇøÓòÖÐ(²»ÒªÅ²¶¯´°¿ÚλÖÃ,´°¿ÚÇл»ÇëÓÃÊó±êµ¥»÷¡£¸´ÖÆÕ³ÌùÇëʹÓÿì½Ý¼üµÄ·½Ê½)
7.ͬʱѡȡ¹¤×÷±íµÄA2,C5,E7µ¥Ôª¸ñ¡£
8.ÇëÊäÈ뺯Êý£¬ÔÚH4µ¥Ôª¸ñÖУ¬¼ÆËãB4ÓëE4µ¥Ôª¸ñÊý¾ÝµÄºÍ¡£ 9.ÉèÖÃÖð·Ý´òÓ¡µ±Ç°¹¤×÷±í10·Ý¡£
10.ÊäÈ뺯Êý£¬ÔÚµ±Ç°¹¤×÷±íH16µ¥Ôª¸ñÖУ¬Í³¼ÆB2:H14ÇøÓòÖÐÊý×ÖÏîµÄ¸öÊý£¬ÔÚH17µ¥Ôª¸ñÖУ¬Í³¼ÆB2:H14ÇøÓòÖзǿÕÖµµÄ¸öÊý¡£
11.ÔÚµ±³É¼¨±íÖУ¬É¾³ýÓÐÖØ¸´Êý¾ÝµÄ¼Ç¼£¬È»ºóÔÙɾ³ý¡°³É¼¨3¡±ÖÐÓÐÖØ¸´Êý¾ÝµÄ¼Ç¼¡£
12.ÀûÓÃExcelÄÚÖá°´û¿î·ÖÆÚ¸¶¿î¡±Ä£°å,н¨Ò»¸ö¹¤×÷²¾¡£
13.µ±Ç°µ¥Ôª¸ñÖеÄÈÕÆÚΪ2011ÄêµÄµÚÒ»¸öÐÇÆÚÁùµÄÈÕÆÚ£¬ÇëÔÚA3:A11ÇøÓòÌî³äÆäºóµÄ9¸öÐÇÆÚÁùµÄÈÕÆÚ£¨½ûÖ¹È˹¤¼ÆËãÈÕÆÚ£©¡£ 14.ÔÚµ±Ç°µ¥Ôª¸ñÖÐ,Óú¯ÊýºÍ¹«Ê½¼ÆËã1Ô·ݵÄÔÂÏúÊÛ¶î¡£ 15.B1µ¥Ôª¸ñÒѾÉèÖÃΪʱ¼ä¸ñʽ£¬ÇëÊäÈ뺯Êý£¬ÏÔʾÏÖÔÚµÄʱ¼ä¡£ 16.ÀûÓüôÌû°åÈÎÎñ´°¸ñ,½«\¼ôÌù°å\ÖеÄÄÚÈÝÈ«²¿Çå³ý¡£
17.Ó¦Óñà¼Í¬×鹤×÷±íµÄ·½·¨,½«µ±Ç°¹¤×÷²¾\¸ßÒ»³É¼¨µ¥\ºÍ\¸ß¶þ³É¼¨µ¥\ÖеıêÌâÐÐÎÄ×ÖÉèÖÃΪ\»ªÎÄÐп¬\¡£
18.°Ñµ±Ç°¹¤×÷±íÒ³ÃæÉÏϱ߾àÉèÖÃΪ3,ҳü±ß¾àÉèÖÃΪ2.5¡£ 19.¹¤×÷²¾ÏÔʾÔÚÒÑ´ò¿ªµÄÁ½¸ö´°¿ÚÖÐ,ÇëÒÔˮƽ·½Ê½²¢ÅűȽϡ£ 20.½«Í¼±íÖÐÀîËĵÄÊý¾Ýɾ³ý¡£
21.ÔÚµ±Ç°µ¥Ôª¸ñ¼ÆËã³öÄêÁäÔÚ30Ëê»ò30ËêÒÔÉϵÄÖ°¹¤µÄ¹¤×ÊÖ®ºÍ¡£ 22.ÔÚµ±Ç°Í¼±íÉÏ·½ÉèÖÃͼ±í±êÌâΪ:ÏúÊÛ¶îͳ¼Æ¡£
23.ͨ¹ý״̬À¸Çл»µ½·ÖÒ³Ô¤ÀÀ,°Ñµ±Ç°µÚÒ»Ò³µÄÐзÖÒ³·ûÒÆ¶¯µ½µÚ15Ðкó,ÁзÖÒ³·ûÒÆ¶¯µ½µÚGÁÐÓҲࡣ 24.ɾ³ýÊý¾ÝÇåµ¥ÖÐ\ÕÅÀ×\µÄ¼Ç¼¡£
25.ͨ¹ý´òÓ¡Ô¤ÀÀ¹¦ÄÜÉèÖúáÏò´òÓ¡¡°¹ÍÔ±¡±¹¤×÷±í¡£
26.ͨ¹ý¹¤¾ßÃæ°å½«µ±Ç°¹¤×÷±íµÄ±êÌâÉèÖÃΪÁ¥Êé,¼Óµ¥Ï»®Ïß¡£ 27.ÒÔÖ»¶Á·½Ê½´ò¿ª\ÎÒµÄÎĵµ\Îļþ¼ÐÖеÄ\³É¼¨±í.xlsx\¹¤×÷²¾¡£ 28.ÔÚµ±Ç°¹¤×÷±íÖÐ,°ÑÒÑÑ¡µ¥Ôª¸ñÇøÓòËùÉèÖõĵ×ÎÆÑÕÉ«ºÍͼ°¸È¡Ïû¡£ 29.¶ÔSheet1¹¤×÷±íÉèÖñ£»¤,±£»¤ÃÜÂëΪ123,ÔÊÐíÓû§Ñ¡¶¨µ¥Ôª¸ñ¡¢²åÈëÁкÍÐС£
30.ÔÚµ±Ç°¹¤×÷±íÖÐ,°ÑÒÑÑ¡µ¥Ôª¸ñÇøÓò±³¾°É«ÉèÖÃΪˮÂÌÉ«£¬Ç¿µ÷ÎÄ×ÖÑÕÉ«5£¬µÉ«80%(ÑÕÉ«ÁбíµÚ2ÐеÚ9ÁÐ)£¬Í¼°¸ÑùʽΪ6.25%»ÒÉ«£¨µÚ1ÐеÚ6ÁУ©£¬Í¼°¸ÑÕɫΪÀ¶É«£¬Ç¿µ÷ÎÄ×ÖÑÕÉ«1£¨µÚ1ÐеÚ5ÁУ©¡£ 31.È¡Ïûµ±Ç°Îĵµ¼ÓÃÜ,ʹÆä½øÈëʱ,²»ÔÙʹÓôò¿ªÈ¨ÏÞÃÜÂë¡£
32.¶Ôµ±Ç°Ñ¡¶¨Ñ§ºÅÇøÓò,ÉèÖÃÖ»ÔÊÐíÊäÈë5λ×Ö·û³¤¶È,ºöÂÔ¿ÕÖµ£¨²»ÒªÔÚ¹¤×÷±íÖÐÊäÈëÈκÎÖµ£©¡£
33.½«B2µ¥Ôª¸ñÖеÄÄÚÈݸ´ÖƵ½Sheet3ÖеÄA4µ¥Ôª¸ñÖС£ 34.ÔÚµ±Ç°¹¤×÷±íA2µ¥Ôª¸ñÖÐÊäÈëÈÕÆÚ:2015Äê5ÔÂ1ÈÕ,²¢È·ÈÏ¡£ 35.½«µ±Ç°Ñ¡ÖеÄÐòÁÐÌî³ä·½Ê½ÐÞ¸ÄΪ:ÒÔ¸´ÖƵ¥Ôª¸ñµÄ·½Ê½Ìî³ä¡£ 36.ʹÓÃÊó±êÍ϶¯¼¼Êõɾ³ýµ±Ç°¹¤×÷±íBÁÐÖеÄÄÚÈÝ¡£
37.ͨ¹ýÓйضԻ°¿òµÄ°ïÖú°´Å¥,ÏÔʾ¹ØÓÚ\ÒÔ¸±±¾·½Ê½´ò¿ªÎļþ\µÄ°ïÖúÐÅÏ¢¡£ 38.Êý¾ÝÇåµ¥ÖеÄ\²¿ÃÅ\ÒѾÅÅÐò,ÒªÇ󣺰´\²¿ÃÅ\¶Ô\¹¤×Ê\»ã×ÜÇóºÍ,»ã×ܽá¹ûÏÔʾÔÚÊý¾ÝÏ·½¡£
39.ÓÃ×Ô¶¯ÇóºÍ¹«Ê½¼ÆËãÿÃûͬѧµÄ×ܳɼ¨¡£ 40.ÉèÖø´ÖÆÊ±×Ô¶¯ÏÔʾ¼ôÌù°å´°¸ñ¡£
Ïà¹ØÍÆ¼ö£º