30幾個考研復(fù)試英語面試常見問題

1、提出問題在面試快結(jié)束的時候，一般老師都會問，你有沒有什么要問的(do you have any questions to ask?)。一般不適合說“i dont have any question?！笨梢詥柨脊僖粌蓚€你關(guān)心的問題。are u ready go!問考官幾個問題：1、could you give some advice about how to make self better and how to balance the daily life and the study?2、could you recommend ,rekmend some books for i can ada

2、pt to the study more easily1英語面試準(zhǔn)備的材料自我介紹1.1good morning ,dear professors, i feel so glad to meet all of you here（個人簡要信息）i am yanjinbin,21 years old,i am graduating from mie this june,my major is biotechnology, now all my hard work has got a result since i have a chance to be interview by you.1.2（表明

3、自己的興趣）i am obsessed with the life and the science ,so i want to continue to explore it in the biology fields,and broaden my horizons hraizn，morever,some famous people graduating from here,such as the founder，he is a man of great charm, xxxxx，he is one of the chinese academy of science,both of them a

4、re the people who characterize the spirit of zhejiang unversity -seek the truth,and thats why i choose to pursue advanced studies in.,.well,the .is my favourite field,because it can make a big difference in our daily life,though we can not1.3性格適合搞研究(性格能力說明你適合搞研究)獨(dú)立 i am an independent man,when i arg

5、ue with others ,i will adhere to the truth under any condition善于分析 morever,i am good at analysis,i will become better every times i failed to finish the experiment,i will find the error and make an adjustment in times善于交際和團(tuán)隊工作my interactive personal skills and teamwork spirits will be appropriate fo

6、r the future study,在實(shí)驗(yàn)上的，my training in the experiment about .can polished my abilities,毅力most of important,my /.and carefulness qualify me for advanced study and the scientific researchnot only i like do researches,but also do some sports,in my lesuire time,1.4(喜歡運(yùn)動)i like to do some sports,for bui

7、lding my body and relaxing myself ,such as riding biycle, play badminton, watch movies and listen some light music, .seek the balance between the research and the life追星my admirable celebrity is the nba player,dwyane wade,who is one of the miami heat team,he helped the miami heat win the first nba f

8、inal champion in 2006,i was impressed by his huge courage and perseverance,i learn from him ,nothing can stop you achieving the goal you set,unless you give up,and we should try our best .引用名言as a saying goes moto:1、one fails forward success,2、never confuse a single defeat with a final defeat3、failu

9、re is only the opportunity to begain again more intelligently4、i have failed over and over and over again in my life,and thats why i succeed -miachel jordan2、對你影響最深的人：（適用于介紹自己的家庭）母親 父親： 3、舉個例子表明你喜歡這個專業(yè)，(laboratory for marine resources and molecular engineering)陳述1：陳述24、考研的原因：(take part in the postgr

10、aduate entrance exams)i think ,there are three reasons to explain why i choose to take part in the postgraduate entrance exams.first,i am eager for improving myself and broaden my horizons about the biotechnology fields,then,nowdays,wit hxxxxxxooooooo finished,there is a heated topic about decoding

11、our lives and benfit our human beings,thus, i want to keep up with the pace of the great research,last,i took part in the postgraduate entrance exam ,for the reason that i was fascinated fsineitid with xxxxoooooo and have the aspiration ,sprein to seek the truth,5、為什么選擇我們學(xué)校is a prosperious and compr

12、ehensive university, many famous people graduated from zhejiang university,such asxxxxxxxxxxx he is one of the chinese academy of science,the founderxxxxxxxxxxx，a man of great charm, and i want to follow their steps and make a great contribution to the society,then,i do love the atmosphere of xxxxxx

13、xxxxxxx, people are full of love ,friendliness frendlinis,and i want to improve myselvf by competing with each other6、介紹自己的家鄉(xiāng)i feel so glad to introduce my hometownmy hometown is a xxxxxxxxxxxxxx place,is known fori really want to invite u to visit my hometown,i assure u you that this visit can be t

14、ransformed into a beautiful memory7、介紹自己的大學(xué)i sincerely appreciate that my school provides us the opportunities and the platform,i love my teachers and classmates8、你的目標(biāo)，學(xué)習(xí)計劃，長期短期（）未來規(guī)劃學(xué)習(xí)規(guī)劃(研究生以后的方向)，人生規(guī)劃(短期、長期)介紹自己的大學(xué)，讀研期間的計劃whats your goal for future? what will you be in 5 years?what do you think yo

15、ur position will be in 5 years?whats your blueprint for your future?there must be many things to learn if i were enrolled into my ideal research field.i hope i can build up a systematic ,sistimtik view of life and science, especially in the fields of genetic engineering technique. sincerely, my wish

16、 is to get a complete comprehension of the mechanism of the life. on the other hand, i am dreaming of the participation of some relevant relvnt projects of my major, for this reason, i will get more experience in practice. and through this, i can get something that cannot be acquired from the textbo

17、oks. i believe after 2 years of learning, my dream will finally come true and whats more, i expect to continue my study for doctorate degree, if it is possible. in a word, i am looking forward to making up a solid foundation for future profession which is based on three years of study here.9、你是一個什么樣

18、的人，別人對你的評價是怎么樣的e. what kind of person are you?what do you think your colleagues might describe you?what do you think your boss might describe you?what do you think your friends might describe you?10、what is important to you? 什么對你是最重要的challenge, the feeling of accomplishment, and knowing that i have

19、made a contribution. 挑戰(zhàn)，完成的感覺，知道自己做了貢獻(xiàn)11、what are you greatest weakness? 你最大的弱點(diǎn)或者缺點(diǎn)i like to se e a job done quickly and perfectly, and im critical if it isnt. 我喜歡把事做快一點(diǎn)，完美一點(diǎn)，如果不，我會對此批評12、how would your friends or colleagues describe you？（你的朋友或同事怎樣形容你？） a： (稍等幾秒鐘再答，表示慎重考慮。) they say ：yanjinbin is an

20、 honest, friendly and determined person , who deeply cares for his friends. and respectful for teachers 13、what personality traits do you admire？(你欣賞哪種性格的人？) a：( i admire a person who is) honest, flexible and easy-going. (誠實(shí)、不死板而且容易相處的人。) some people who possess the can do spirit. (有實(shí)際行動的人。) 14、are

21、you a multi-tasked individual？(你是一位可以同時承擔(dān)數(shù)項(xiàng)工作的人嗎？) or do you work well under stress or pressure？(你能承受工作上的壓力嗎?) a：yes, i can ,the trait is needed in my current research and i know i can handle it well. 15、what make you think you would be a success in this position/scientific research？ (你如何知道你能勝任科學(xué)研究？

22、） my extensive training in microbiology and molecular engineering ,combined with my never give up personality should qualify me for it. i am sure i will be successful16、what is your strongest trait(s)？(你個性上最大的特點(diǎn)是什么？) 講四點(diǎn)就好了a：helpfulness and caring.（樂于助人和關(guān)心他人。） a：adaptability and sense of humor.（適應(yīng)能力

23、和幽默感。） a：cheerfulness and friendliness.（樂觀和友愛。） 17、how do you normally handle criticism？(你通常如何處理別人的批評？) silence is golden. just dont say anything; otherwise the situation on could become worse. i do, however, accept constructive criticism. (沉默是金。不必說什么，否則情況更糟，不過我會接受建設(shè)性的批評。) 18、如何處理矛盾爭執(zhí)when we cool of

24、f, we will discuss it later. (我會等大家冷靜下來再討論。)i will try to present my ideas in a more clear and civilized manner in order to get my points across. (我要以更清楚文明的方式，提出我的看法，使對方了解我的觀點(diǎn)。) 19、 what are your greatest strengths最大優(yōu)點(diǎn)強(qiáng)項(xiàng)是什么i can see what needs to be done and do it. and organize my work efficiently.,

25、im willing to make decisions. (能當(dāng)機(jī)立斷。) 20、how do you handle your failure？(你怎樣對待自己的失??？) a：none of us was born perfect. i am sure i will be given a second chance to correct my mistake. （我們大家生來都不是十全十美的，我相信我有第二個機(jī)會改正我的錯誤。) 21、q：what provide you with a sense of accomplishment. （什么會讓你有成就感？）a：finishing a pr

26、oject to the best of my ability. (盡我所能，完成一個項(xiàng)目。) 22、你自己最大的缺點(diǎn)弱點(diǎn)是什么1“i prefer to see a project through from start to finish rather than working on a single component and never seeing the finished product. i sometimes find it a bit frustrating to work without that overall uvr:l context.”“2“im a perfecti

27、onist. i need to improve on not being so hard on myself and making sure i get everything right. ”23、 what are your greatest weaknesses最大缺點(diǎn)? i tend to drive myself too hard. (我有時對自己要求過于嚴(yán)格。) i like to see a job done quickly. (我喜歡速戰(zhàn)速決。) 24、tell me something about yourself. 談?wù)勀阕约?也就是做個人減少，參考問題1 with my

28、qualifications and experience, i feel i am hardworking, responsible and diligent in the scientific research i undertake. my analytical (nlitik,-kl)abilities and interpersonal skills will be my advantages for future study25、what do you find frustrating in a work situation？(在工作中，什么事令你不高興？) a：sometimes

29、, the narrow-minded people make me frustrated. (胸襟狹窄的人，有時使我泄氣。) a：minds that are not receptive to new ideas. (不能接受新思想的那些取。) 26、how do you spend your leisure time?你怎么樣利用你的課余時間27、do you work well under pressure?你喜歡在壓力下工作a:working under pressure is exciting and challenging. i dont mind working under pr

30、essure.i work well under these circumstances. people can, i can.28、i hope to demonstrate my ability and talents in my field adequately. (我希望能充分展示我在這個行業(yè)的能力和智慧。) 29、give me a summary of 大學(xué)四年（總結(jié)自己的大學(xué)四年）30、q：if you had a lot of money to donate, where would you donate it to？why？(假如你有很多錢可以捐贈，你會捐給什么單位？為什么？

31、) a：i would donate it to the medical research because i want to do something to help others. (我會捐給醫(yī)藥研究，因?yàn)槲乙獮樗俗鳇c(diǎn)事。) a：i prefer to donate it to educational institutions. (我樂意捐給教育機(jī)構(gòu)。) q：could you project what you would like to be doing five years from now？(你能預(yù)料五年后你會做什么嗎？) 31、what are your goals?(你的長期短

32、期目標(biāo))“my immediate goal is to get a job in a growth-oriented company. my long-term goal will depend on where the company goes. i hope to eventually grow into a position of responsibility.”32、what do you want most from your work?你最希望從研究生涯中得到什么? i hope i can get a kind of learning, to get skills from m

33、y research. though i have studied in school for nearly 4 years, i have only learned knowledge,little experience on experimentsi hope that learn some new technology and the wisdom about how to do scientific research ,and become a professional in the xxxxxxxxxxxxxxxxx industry, indstri33、你為什么選擇你報考的專業(yè)

34、i am an innovative achiever. i feel that in a growth industry lik xxxxxxxxxxxxxxxxxx there is a need for some prominent prminnt representatives，who can meet and beat the competition. i feel that i have all the essential ingredients to contribute to microbiology,and if necessary, i am willing to take

35、 a step backwards as long as theris potential for forward momentum. mumentm all i need is a starting point.待修改3) 結(jié)束時可以用說：thats all about me. / well, thats who i am. thanks for your attention. your time your patience意外情況沒聽清，你應(yīng)該怎樣要求老師再說一遍(pardon?/ sorry, i cant follow you. / sorry, i lost you. can you

36、 repeat that question again?);需要時間思考、整理思路的時候，不要出現(xiàn)沉默，可以用一些hmm, err, well等語氣詞;不會回答某些問題時，千萬不要不懂裝懂，可以明確地告訴老師你不知道(sorry, but i have no idea about it。 為什么你適合做研究i think i am the best person for advanced study ,i realize the there are likely other candidates who have the ability for the research,but i bring

37、 an additional quality that makes me better for future research study,my passion for excellence and perseverance ,i am passionatedly committed to proudce something unique with my continous perseverancemy personality is easy going,so i can get along well with other people4會講話的人大都善于運(yùn)用個人的優(yōu)缺點(diǎn)把這篇大文章作好。下面

38、，我們列出幾條，你看自己有沒有，又怎么利用它巧妙地介紹自己： 對應(yīng)聘有利的優(yōu)點(diǎn)： -好學(xué)習(xí)、肯鉆研。 -腦子好使，記憶力強(qiáng)。 -辦事認(rèn)真，一絲不茍。 -有干勁，不惜力。 -好相處，跟誰都合得來。 -有比較豐富的閱歷。 -喜歡接受挑戰(zhàn)性的課題。 interviewer: why did you choose us?applicant: as the saying goes, well begun is half done. your company is a famous one in the industry and boasts a high reputation. i hope to ch

39、oose your company as the beginning of my career. i can not only learn new things, but set a solid foundation for my future career as well.-下面是贈送的excel操作練習(xí) 不需要的下載后可以編輯刪除（excel 2003部分）1. 公式和函數(shù)1. （1）打開當(dāng)前試題目錄下文件excel-10.xls；（2）利用函數(shù)計算每個人各階段總成績，并利用函數(shù)計算各階段的平均成績；（3）“平均成績”行數(shù)字格式都為帶一位小數(shù)（例如0.0）格式；（4）同名存盤。步驟：a)

40、文件在各階段總成績單元格內(nèi)，點(diǎn)插入，點(diǎn)函數(shù)，在對話框中選擇求和函數(shù)“sum”，在對話中number1內(nèi)點(diǎn)右側(cè)的按鈕，將出現(xiàn)另外一個對話框，在文件中選擇需要求和的單元格，然后點(diǎn)該對話框的右側(cè)按鈕，點(diǎn)確定（完成一個總成績求和后，利用填充柄完成其他的總成績求和，或者重復(fù)上面的順序）在平均成績單元格內(nèi)，點(diǎn)插入，點(diǎn)函數(shù)，選擇算術(shù)平均值函數(shù)average，出現(xiàn)對話框后，采用求和時的相同方法，完成操作選中平均成績行，點(diǎn)右鍵點(diǎn)設(shè)置單元格，點(diǎn)數(shù)字，在分類項(xiàng)下點(diǎn)數(shù)值，設(shè)小數(shù)位為1，b) 確定保存2. （1）打開當(dāng)前試題目錄下文件excel-13.xls；（2）根據(jù)工作表中給定數(shù)據(jù)，按“合計=交通費(fèi)+住宿費(fèi)+補(bǔ)助”

41、公式計算“合計”數(shù)，并計算交通費(fèi)、住宿費(fèi)和補(bǔ)助的合計數(shù)；（3）所有數(shù)字以單元格格式中貨幣類的“￥”貨幣符號、小數(shù)點(diǎn)后2位數(shù)表現(xiàn)（如：￥2,115.00格式）；（4）同名存盤。打開當(dāng)前試題目錄下文件excel-13.xls在合計下的一個單元格內(nèi)輸入“=交通費(fèi)（在該行的單元格，假如說是e3）+住宿費(fèi)（同上）+補(bǔ)助（同上）”，回車（其他的合計可以采用填充柄完成，或者重復(fù)上面的順序）利用求和函數(shù)，參考1中的方法完成交通費(fèi)、住宿費(fèi)和補(bǔ)助的合計選擇文件中的所有數(shù)字單元格，點(diǎn)右鍵，點(diǎn)設(shè)置單元格格式，點(diǎn)數(shù)字，點(diǎn)貨幣，選擇貨幣符號為“￥”，設(shè)置小數(shù)點(diǎn)后為2位，確定保存文件本題完成3. （1）打開當(dāng)前試題目錄下文

42、件excel-2.xls；（2）根據(jù)工作表中數(shù)據(jù)，計算“總成績”列的數(shù)據(jù)。總成績=一階段成績0.3+二階段成績0.3+三階段成績0.4；（3）“總成績”列數(shù)據(jù)格式為小數(shù)點(diǎn)后2位小數(shù)（例：6.20）；（4）同名存盤。打開當(dāng)前試題目錄下文件excel-2.xls在總成績下的一個單元格內(nèi)輸入“=一階段成績（在該行的單元格，假如說是e3）*0.3+住宿費(fèi)（同上）*0.3+補(bǔ)助（同上）*0.4”，回車（其他的合計可以采用填充柄完成，或者重復(fù)上面的順序）選中總成績列的數(shù)據(jù)單元格，點(diǎn)右鍵，點(diǎn)設(shè)置單元格格式，點(diǎn)數(shù)字，點(diǎn)數(shù)值，設(shè)置小數(shù)點(diǎn)后為2位，確定保存文件本題完成4. （1）打開當(dāng)前試題目錄下文件excel-

43、3.xls；（2）計算“審定費(fèi)”和“稅后款”，“審定費(fèi)=全書字?jǐn)?shù)10003，稅后款=審定費(fèi)-審定費(fèi)5%”；（3）利用菜單將“審定費(fèi)”和“稅后款”列格式設(shè)置為貨幣類的“￥”貨幣符號、小數(shù)點(diǎn)1位（例￥1,280.0）；（4）同名存盤。打開當(dāng)前試題目錄下文件excel-3.xls在審定費(fèi)下的一個單元格內(nèi)輸入“=全書字?jǐn)?shù)（在該行的單元格，假如說是e3）/1000*3”，回車（其他的審定費(fèi)可以采用填充柄完成，或者重復(fù)上面的順序）在稅后款下的一個單元格內(nèi)輸入“=審定費(fèi)（在該行的單元格，假如說是f3）-審定費(fèi)*5%”，回車（其他的稅后款可以采用填充柄完成，或者重復(fù)上面的順序）選中審定費(fèi)及稅后款列的數(shù)據(jù)單元格

44、，點(diǎn)右鍵，點(diǎn)設(shè)置單元格格式，點(diǎn)貨幣，選擇貨幣符號“￥”，設(shè)置小數(shù)點(diǎn)后為1位，確定保存文件本題完成5. （1）打開當(dāng)前試題目錄下文件excel-8.xls；（2）利用函數(shù)計算“總成績”，利用公式“平均成績=總成績3”來計算“平均成績”；（3）同名存盤。打開當(dāng)前試題目錄下文件excel-8.xls在總成績下的一個單元格，點(diǎn)插入，點(diǎn)函數(shù)，在對話框中選求和函數(shù)“sum”，在對話中number1內(nèi)點(diǎn)右側(cè)的按鈕，將出現(xiàn)另外一個對話框，在文件中選擇需要求和的單元格，然后點(diǎn)該對話框的右側(cè)按鈕，點(diǎn)確定（完成一個總成績求和后，利用填充柄完成其他的總成績求和，或者重復(fù)上面的順序在平均成績下的一個單元格內(nèi)，輸入“=平

45、均成績（在該行的單元格，假如說是b3）/3”，回車（其他平均成績可以采用填充柄完成，或者重復(fù)上面的順序）保存文件本題完成6. （1）打開當(dāng)前試題目錄下文件excel-1.xls；（2）利用公式計算每個項(xiàng)目的“合計”；（3）“合計”列數(shù)據(jù)的格式和其它數(shù)據(jù)的格式相同；（4）同名存盤。打開當(dāng)前試題目錄下文件excel-1.xls在合計下的一個單元格，點(diǎn)插入，點(diǎn)函數(shù)，在對話框中選求和函數(shù)“sum”，在對話中number1內(nèi)點(diǎn)右側(cè)的按鈕，將出現(xiàn)另外一個對話框，在文件中選擇需要求和的單元格，然后點(diǎn)該對話框的右側(cè)按鈕，點(diǎn)確定（完成一個總成績求和后，利用填充柄完成其他的總成績求和，或者重復(fù)上面的順序利用格式刷

46、將合計的列的數(shù)據(jù)格式刷成與其他數(shù)據(jù)格式相同的格式（使用格式刷的方法是，先選中合計列外的其他任意一個單元格，點(diǎn)格式刷，然后再點(diǎn)需要刷成該樣格式的單元格即可）保存文件本題完成7. （1）打開當(dāng)前試題目錄下文件excel-6.xls；（2）計算出“凈資產(chǎn)收益率”，凈資產(chǎn)收益率=凈利潤凈資產(chǎn)總額；（3）“凈資產(chǎn)收益率”行以保留三位小數(shù)的百分?jǐn)?shù)形式表現(xiàn)（如：32.310%）；（4）同名存盤。打開當(dāng)前試題目錄下文件excel-6.xls在凈資產(chǎn)收益率下的一個單元格，輸入“=凈利潤（在該行的單元格，假如說是b3）/凈資產(chǎn)總額”，回車（完成一個單元格后，可以利用填充柄完成其他的單元格的操作，或者重復(fù)上面的順序

47、）選中凈資產(chǎn)收益率列下的數(shù)據(jù)單元格，點(diǎn)右鍵，點(diǎn)設(shè)置單元格格式，點(diǎn)數(shù)字，單百分比，將小數(shù)位數(shù)設(shè)為3位，確定保存文件本題完成8. （1）打開當(dāng)前試題目錄下文件excel-7.xls；（2）分別利用函數(shù)計算出“總成績”、“平均成績”；（3）平均成績設(shè)置帶兩位小數(shù)格式（例如：78.00）；（4）同名存盤。打開當(dāng)前試題目錄下的excel-7.xls文件在總成績對應(yīng)的單元格內(nèi)，點(diǎn)插入，點(diǎn)函數(shù)，在對話框中選擇求和函數(shù)“sum”，在對話中number1內(nèi)點(diǎn)右側(cè)的按鈕，將出現(xiàn)另外一個對話框，在文件中選擇需要求和的單元格，然后點(diǎn)該對話框的右側(cè)按鈕，點(diǎn)確定（如果有多個總成績項(xiàng)，完成一個總成績求和后，利用填充柄完成其

48、他的總成績求和，或者重復(fù)上面的順序）在平均成績對應(yīng)的單元格內(nèi)，點(diǎn)插入，點(diǎn)函數(shù)，選擇算術(shù)平均值函數(shù)average，出現(xiàn)對話框后，采用求和時的相同方法，完成操作選中平均成績對應(yīng)的單元格，點(diǎn)右鍵，點(diǎn)設(shè)置單元格，點(diǎn)數(shù)字，點(diǎn)數(shù)值，設(shè)小數(shù)位為2，確定保存文件本題完成9. （1）打開當(dāng)前試題目錄下文件excel-16.xls；（2）計算出“全套優(yōu)惠價”，公式為：全套優(yōu)惠價裸機(jī)價+入網(wǎng)費(fèi)-送話費(fèi)；（3）所有數(shù)字都以單元格格式中貨幣類的“￥”貨幣符號、小數(shù)點(diǎn)后1位小數(shù)表現(xiàn)（如：￥1,450.00）；（4）同名存盤。打開當(dāng)前試題目錄下文件excel-16.xls在全套優(yōu)惠價對應(yīng)的單元格，輸入“=全套優(yōu)惠價裸機(jī)價（

49、在該行的單元格，假如說是b3）+入網(wǎng)費(fèi)（同上）-送話費(fèi)”，回車（如果有多個全套優(yōu)惠價項(xiàng)，可以利用填充柄完成，也可以重復(fù)上面的順序）選中所有的數(shù)字單元格，點(diǎn)右鍵，點(diǎn)設(shè)置單元格格式，點(diǎn)數(shù)字，點(diǎn)貨幣，選擇貨幣符號為“￥”，設(shè)小數(shù)位為2位，確定保存文件本題完成10. （1）打開當(dāng)前試題目錄下文件excel-71.xls；（2）利用函數(shù)計算獎金項(xiàng)的值，公式是“滿工作量為40，滿工作量的獎金為800元，工作量不足的獎金為600元”；（3）利用公式計算實(shí)發(fā)工資項(xiàng)的值，公式是“實(shí)發(fā)工資為基本工資加獎金，再減去住房基金和保險費(fèi)”；（4）同名存盤。打開當(dāng)前試題目錄下文件excel-71.xls選中獎金項(xiàng)下的一個單

50、元格，點(diǎn)插入，點(diǎn)函數(shù)，點(diǎn)if函數(shù)，在對話框中，第一個條件格式內(nèi)輸入“該行工作量項(xiàng)下的單元格（比如是e3）=40（即e3=40）”，在true內(nèi)輸入800，在false內(nèi)輸入600，確定（其余行可以采用填充柄完成，或重復(fù)上述的順序）選擇實(shí)發(fā)工資項(xiàng)下的一個單元格，輸入“=基本工資（在該行的單元格名）+獎金（同上）-住房基金（同上）-保險費(fèi)（同上）”，確認(rèn)（回車）（其余單元格采用填充柄完成，或重復(fù)上述順序）保存文件本題完成11. if函數(shù)的應(yīng)用：根據(jù)教師工作表教師職稱確定其職務(wù)津貼練習(xí)excel2003p140：excel2003電子表格的編輯操作2. 排序3. （1）打開當(dāng)前試題目錄下文件exce

51、l-24.xls；（2）在b4單元格內(nèi)鍵入數(shù)字“45637”；（3）表格所有數(shù)字格式為帶1位小數(shù)格式（如：23456.0）；（4）將sheet1的所有內(nèi)容復(fù)制到工作表sheet2的相應(yīng)單元格內(nèi)，并以“電器”為關(guān)鍵字，對四個季度所有數(shù)據(jù)遞減排序；（5）同名存盤。打開當(dāng)前試題目錄下文件excel-24.xls點(diǎn)b4單元格，輸入“45637”選中表格內(nèi)的所有數(shù)字格式，點(diǎn)右鍵，點(diǎn)設(shè)置單元格格式，點(diǎn)數(shù)字，設(shè)小數(shù)位為1，確定全選sheet1（即當(dāng)前的文件），點(diǎn)復(fù)制，點(diǎn)開sheet2，點(diǎn)當(dāng)前頁面的左上角的單元格，點(diǎn)粘貼點(diǎn)“電器”單元格，點(diǎn)表格，點(diǎn)排序，主要關(guān)鍵字下選擇電器，點(diǎn)降序，確定保存文件本題完成4.

52、（1）打開當(dāng)前試題目錄下文件excel-29.xls；（2）根據(jù)工作表中數(shù)據(jù)，在b4單元格內(nèi)鍵入數(shù)據(jù)“2580”；（3）表格數(shù)字?jǐn)?shù)據(jù)設(shè)置為“0,000.0”的格式；（4）以“1997年”為關(guān)鍵字，對不同規(guī)格所有相應(yīng)數(shù)據(jù)進(jìn)行遞減排序；（5）同名存盤。打開當(dāng)前試題目錄下文件excel-29.xls點(diǎn)b4單元格，輸入“2580”選中表格內(nèi)的所有數(shù)字格式，點(diǎn)右鍵，點(diǎn)設(shè)置單元格格式，點(diǎn)數(shù)值，設(shè)小數(shù)位為1，點(diǎn)使用千分分隔符為有效，確定點(diǎn)“1997年”單元格，點(diǎn)表格，點(diǎn)排序，主要關(guān)鍵字下選擇1997，點(diǎn)降序，確定保存文件本題完成5. （1）打開當(dāng)前試題目錄下文件excel-33.xls；（2）根據(jù)工作表中數(shù)

53、據(jù)，在e4單元格內(nèi)鍵入數(shù)據(jù)“商務(wù)出版社”；（3）將sheet1所有內(nèi)容復(fù)制到工作表sheet2的相應(yīng)位置，并以“單價”為關(guān)鍵字，遞減排序；（4）同名存盤。打開當(dāng)前試題目錄下文件excel-33.xls點(diǎn)e4單元格，輸入“商務(wù)出版社”全選sheet1（即當(dāng)前的文件），點(diǎn)復(fù)制，點(diǎn)開sheet2，點(diǎn)當(dāng)前頁面的左上角的單元格，點(diǎn)粘貼點(diǎn)“單價”單元格，點(diǎn)表格，點(diǎn)排序，主要關(guān)鍵字下選擇單價，點(diǎn)降序，確定保存文件本題完成6. （1）打開當(dāng)前試題目錄下文件excel-23.xls；（2）根據(jù)工作表中數(shù)據(jù)，在a4單元格內(nèi)鍵入數(shù)據(jù)“李四”；（3）“總成績”列數(shù)據(jù)都設(shè)置為帶一位小數(shù)格式；（4）將所有內(nèi)容復(fù)制到she

54、et2工作表中相應(yīng)單元格，并以“總成績”為關(guān)鍵字遞增排序；（5）同名存盤。打開當(dāng)前試題目錄下文件excel-23.xls點(diǎn)a4單元格，輸入“李四”選中總成績列的全部數(shù)據(jù)，點(diǎn)右鍵，點(diǎn)設(shè)置單元格格式，點(diǎn)數(shù)字，點(diǎn)數(shù)值，設(shè)小數(shù)位為1位，確定全選sheet1（即當(dāng)前的文件），點(diǎn)復(fù)制，點(diǎn)開sheet2，點(diǎn)當(dāng)前頁面的左上角的單元格，點(diǎn)粘貼點(diǎn)“總成績”單元格，點(diǎn)表格，點(diǎn)排序，主要關(guān)鍵字下選擇總成績，點(diǎn)升序，確定保存文件本題完成7. （1）打開當(dāng)前試題目錄下文件excel-36.xls；（2）根據(jù)工作表中數(shù)據(jù)，在a4單元格內(nèi)鍵入數(shù)據(jù)“獅子座”；（3）a4單元格數(shù)據(jù)格式與該列其它相應(yīng)數(shù)據(jù)格式保持一致；（4）將sh

55、eet1的所有內(nèi)容復(fù)制到sheet2中，并以“赤緯（度）”為關(guān)鍵字，遞減排序；（5）同名存盤。打開當(dāng)前試題目錄下文件excel-36.xls點(diǎn)a4單元格，輸入“獅子座”選中a4單元格所在列的其他單元格，點(diǎn)格式刷，點(diǎn)a4單元格全選sheet1（即當(dāng)前的文件），點(diǎn)復(fù)制，點(diǎn)開sheet2，點(diǎn)當(dāng)前頁面的左上角的單元格，點(diǎn)粘貼點(diǎn)“赤緯（度）”單元格，點(diǎn)表格，點(diǎn)排序，主要關(guān)鍵字下選擇赤緯（度），點(diǎn)降序，確定保存文件本題完成8. （1）打開當(dāng)前試題目錄下文件excel-21.xls；（2）根據(jù)工作表中數(shù)據(jù)，在b5單元格內(nèi)鍵入數(shù)據(jù)2719840；（3）b列、c列數(shù)字都以單元格格式中貨幣類的“￥”貨幣符號、小數(shù)

56、點(diǎn)后2位小數(shù)表現(xiàn)（如：￥3,200,000.00”）；（4）將所有內(nèi)容拷貝到sheet2中相應(yīng)位置，并按關(guān)鍵字“增長率”遞減排序；（5）同名存盤。打開當(dāng)前試題目錄下文件excel-21.xls點(diǎn)b5單元格，輸入“2719840”選中b、c列下的數(shù)字（單元格），點(diǎn)右鍵，點(diǎn)設(shè)置單元格格式，點(diǎn)數(shù)字，點(diǎn)貨幣，設(shè)貨幣符號為“￥”，設(shè)小數(shù)點(diǎn)位為2位，采用千分隔符，確定全選sheet1（即當(dāng)前的文件），點(diǎn)復(fù)制，點(diǎn)開sheet2，點(diǎn)當(dāng)前頁面的左上角的單元格，點(diǎn)粘貼點(diǎn)“增長率”單元格，點(diǎn)表格，點(diǎn)排序，主要關(guān)鍵字下選擇增長率，點(diǎn)降序，確定保存文件本題完成9. （1）打開當(dāng)前試題目錄下文件excel-30.xls；（2）根據(jù)工作表中數(shù)據(jù)，在c4單元格內(nèi)鍵入數(shù)據(jù)“3650”；（3）所有數(shù)字所在格式為0,000.0格式；（4）將sheet1的所有內(nèi)容復(fù)制到sheet2相應(yīng)單元格并以“木材”為關(guān)鍵字，遞減排序；（5）同名存盤。打開當(dāng)前試題目錄下文件excel-30.xls點(diǎn)c4單元格，輸入“3650”選中所有數(shù)字單元格，點(diǎn)右鍵，點(diǎn)設(shè)置單元格格式，點(diǎn)數(shù)字，點(diǎn)數(shù)值，設(shè)小數(shù)位為1位，采用千分隔符，確定全選sheet1（即當(dāng)前的文件），點(diǎn)復(fù)制，點(diǎn)開sheet2，點(diǎn)當(dāng)前頁面的左上角的單元格，點(diǎn)粘貼點(diǎn)“木材”單元格，點(diǎn)表