【正文】 點數(shù)字，點貨幣，選擇貨幣符號為“￥”，設(shè)小數(shù)位為2位，確定→保存文件→本題完成10. （1）；（2）利用函數(shù)計算獎金項的值，公式是“滿工作量為40，滿工作量的獎金為800元，工作量不足的獎金為600元”；（3）利用公式計算實發(fā)工資項的值，公式是“實發(fā)工資為基本工資加獎金，再減去住房基金和保險費”；（4）同名存盤?！cA4單元格，輸入“獅子座”→選中A4單元格所在列的其他單元格，點格式刷，點A4單元格→全選SHEET1（即當(dāng)前的文件），點復(fù)制，點開SHEET2，點當(dāng)前頁面的左上角的單元格，點粘貼→點“赤緯（度）”單元格，點表格，點排序，主要關(guān)鍵字下選擇赤緯（度），點降序，確定→保存文件→本題完成8. （1）；（2）根據(jù)工作表中數(shù)據(jù)，在B5單元格內(nèi)鍵入數(shù)據(jù)2719840；（3）B列、C列數(shù)字都以單元格格式中貨幣類的“￥”貨幣符號、小數(shù)點后2位小數(shù)表現(xiàn)（如：￥3,200,”）；（4）將所有內(nèi)容拷貝到SHEET2中相應(yīng)位置，并按關(guān)鍵字“增長率”遞減排序；（5）同名存盤。→在凈資產(chǎn)收益率下的一個單元格，輸入“=凈利潤（在該行的單元格，假如說是B3）/凈資產(chǎn)總額”，回車（完成一個單元格后，可以利用填充柄完成其他的單元格的操作，或者重復(fù)上面的順序）→選中凈資產(chǎn)收益率列下的數(shù)據(jù)單元格，點右鍵，點設(shè)置單元格格式，點數(shù)字，單百分比，將小數(shù)位數(shù)設(shè)為3位，確定→保存文件→本題完成8. （1）；（2）分別利用函數(shù)計算出“總成績”、“平均成績”；（3）平均成績設(shè)置帶兩位小數(shù)格式（例如：）；（4）同名存盤?？偝煽?一階段成績+二階段成績+三階段成績；（3）“總成績”列數(shù)據(jù)格式為小數(shù)點后2位小數(shù)（例：）；（4）同名存盤。2. 解釋發(fā)生以上變化的原因（可涉及對英語的重視程度增加；科技發(fā)展使新的學(xué)習(xí)產(chǎn)品不斷涌現(xiàn)）。3． 你的觀點。re determined to be an entrepreneur right now. Certainly, it should not be the best choice of the majority of the students. 九、作弊1當(dāng)今的校園里出現(xiàn)了各種各樣的作弊手段。A Letter to the University President about the Library Service on the CampusDear Mr. President,I am writing to express my concern over the library service on the campus.As a major in English, I find that most of the books in English in the library are outdated. So far, I have not e across a single book published after 1995. As a result, we fail to get the latest information of academic development both at home and abroad.In addition, the light in the reading room is far from bright, which does harm to our eyes. Worse still, there is no air conditioning and we are sweating heavily while reading.Last but not least, the newly developed electronic information system does not work well and needs further improvement. A great number of books should have been listed in the system.There is no denying that the library has helped us a lot. But it is in urgent need of improvement. When improved, the library is certain to provide much more help with our study.Thank you for your time. I am looking forward to your reply.Yours sincerely,Li Qiang七、大學(xué)生就業(yè)1. 大學(xué)生失業(yè)已經(jīng)成為嚴重的社會問題2. 大學(xué)生失業(yè)的原因3. 提出自己對待這個現(xiàn)象的看法和認為的解決途徑My Viewpoint on Unemployment of College GraduatesWith the policy of expanding recruitment of higher education and fierce petition of jobhunting market, the unemployment of college graduation is being the hot issue of the whole society. The college graduates constantly plain being rejected by some promising pany in the jobhunting market. Even most jobs provided in the jobhunting declaredly excluded the graduates, only weling the experienced employers. Even worse, entering for the post graduation examination is being an approach to escaping the problem of unemployment.Is that really difficult for college graduates to hunt job? In fact, the answer might be “no” . There are three reasons for unemployment of college graduates. The first one is the deficiency of practical vocational skills and academic knowledge. The second is the inappropriately evaluation of his own value in job market. The third is the actually fierce petition resulting from the policy of expanding recruitment of higher education.To successfully pete in the job market as a college graduate, you must work hard to master the academic and vocational skills during you college life. Of course, consciously training your practical skills by taking parttime job will be advisable.八、 Selfestablishing Business1． 一些人認為高校學(xué)生休學(xué)創(chuàng)業(yè)應(yīng)該鼓勵。請寫一封信給學(xué)校報社說明你對此的看法。12．套語1）It’s well known to us that ．．．2）As is known to us，．．．3）This is a topic that is being widely talked about．4）From the graph（table，chart）listed above，it can be seen that ．．．5）As a proverb says，“Where there is a will，there is a way．例如：As is well known to us，it is important for the students to know the world outside campus．The reason for this is obvious．Nowadays，the society is changing and developing rapidly，and the campus is no longer an“ivory towerAs college students，we must get in touch with the world outside the campus．Only in this way can we adapt ourselves to the society quickly after we graduate．再如：Does it pay to be honest？This is a topic that is being widely talked about and different people have different opinions on it．一、Psychological Problems among Students’ Mind1. 當(dāng)今，大學(xué)生心理健康問題值得重視；2. 分析大學(xué)生產(chǎn)生心理健康問題的原因（可從同學(xué)關(guān)系緊張；戀愛遭受挫折；貧困產(chǎn)生自卑；學(xué)習(xí)和就業(yè)壓力等方面加以分析）；3. 作為一名大學(xué)生，我認為…Psychological Problems of University StudentsNowadays, psychological problems are being more and more mon among university students, severely affecting their academic performance in the campus as well as their social performance in the future. It is high time the schools and the whole society paid their full attention to the psychological health of the university students.There are many reasons for this phenomenon. Some students are tortured by not getting along well with classmates or roommates, more than too often they tend to settle the misunderstandings over violence, or choose to hide their emotions, which always lead to more serious psychological problems. Being frustrated in love can make the students think of extreme ways of ending their misery, taking revenge or mitting suicide might happen in that case. Poverty can deprive a student’s confidence，making them feel inferior pared to their peers. And pressure from the study and the jobhunting petition are also contributors to all kinds of psychological problems.As a college student myself, I think we should try to be strong and reasonable enough to face the new challenges in our new life, and I sincerely remend the schools to offer more psychological instructions.二、The Prevalence of Western Holidays1中國傳統(tǒng)節(jié)日受到冷遇，西方節(jié)日卻日益升溫。11．表示結(jié)論1）In short，it can be said that ．．．2）It may be briefly summed up as follows．3）From what has been mentioned above，we can e to the conclusion that ．．．例如：From what has been mentioned above，we can e to the conclusion that examination is necessary，however， its method should be improved．注：例句1可用于任何一個段落的結(jié)論句；例句3則多用文章結(jié)論