【正文】 →點A4單元格，輸入“獅子座”→選中A4單元格所在列的其他單元格，點格式刷，點A4單元格→全選SHEET1（即當前的文件），點復制，點開SHEET2，點當前頁面的左上角的單元格，點粘貼→點“赤緯（度）”單元格，點表格，點排序，主要關(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中相應位置，并按關(guān)鍵字“增長率”遞減排序；（5）同名存盤?！cE4單元格，輸入“商務出版社”→全選SHEET1（即當前的文件），點復制，點開SHEET2，點當前頁面的左上角的單元格，點粘貼→點“單價”單元格，點表格，點排序，主要關(guān)鍵字下選擇單價，點降序，確定→保存文件→本題完成6. （1）；（2）根據(jù)工作表中數(shù)據(jù)，在A4單元格內(nèi)鍵入數(shù)據(jù)“李四”；（3）“總成績”列數(shù)據(jù)都設(shè)置為帶一位小數(shù)格式；（4）將所有內(nèi)容復制到SHEET2工作表中相應單元格，并以“總成績”為關(guān)鍵字遞增排序；（5）同名存盤?！cB4單元格，輸入“45637”→選中表格內(nèi)的所有數(shù)字格式，點右鍵，點設(shè)置單元格格式，點數(shù)字，設(shè)小數(shù)位為1，確定→全選SHEET1（即當前的文件），點復制，點開SHEET2，點當前頁面的左上角的單元格，點粘貼→點“電器”單元格，點表格，點排序，主要關(guān)鍵字下選擇電器，點降序，確定→保存文件→本題完成4. （1）；（2）根據(jù)工作表中數(shù)據(jù)，在B4單元格內(nèi)鍵入數(shù)據(jù)“2580”；（3）表格數(shù)字數(shù)據(jù)設(shè)置為“0,”的格式；（4）以“1997年”為關(guān)鍵字，對不同規(guī)格所有相應數(shù)據(jù)進行遞減排序；（5）同名存盤。→在全套優(yōu)惠價對應的單元格，輸入“=全套優(yōu)惠價裸機價（在該行的單元格，假如說是B3）+入網(wǎng)費（同上）送話費”，回車（如果有多個全套優(yōu)惠價項，可以利用填充柄完成，也可以重復上面的順序）→選中所有的數(shù)字單元格，點右鍵，點設(shè)置單元格格式，點數(shù)字，點貨幣，選擇貨幣符號為“￥”，設(shè)小數(shù)位為2位，確定→保存文件→本題完成10. （1）；（2）利用函數(shù)計算獎金項的值，公式是“滿工作量為40，滿工作量的獎金為800元，工作量不足的獎金為600元”；（3）利用公式計算實發(fā)工資項的值，公式是“實發(fā)工資為基本工資加獎金，再減去住房基金和保險費”；（4）同名存盤?！趦糍Y產(chǎn)收益率下的一個單元格，輸入“=凈利潤（在該行的單元格，假如說是B3）/凈資產(chǎn)總額”，回車（完成一個單元格后，可以利用填充柄完成其他的單元格的操作，或者重復上面的順序）→選中凈資產(chǎn)收益率列下的數(shù)據(jù)單元格，點右鍵，點設(shè)置單元格格式，點數(shù)字，單百分比，將小數(shù)位數(shù)設(shè)為3位，確定→保存文件→本題完成8. （1）；（2）分別利用函數(shù)計算出“總成績”、“平均成績”；（3）平均成績設(shè)置帶兩位小數(shù)格式（例如：）；（4）同名存盤?！诤嫌嬒碌囊粋€單元格，點插入，點函數(shù)，在對話框中選求和函數(shù)“SUM”，在對話中Number1內(nèi)點右側(cè)的按鈕，將出現(xiàn)另外一個對話框，在文件中選擇需要求和的單元格，然后點該對話框的右側(cè)按鈕，點確定（完成一個總成績求和后，利用填充柄完成其他的總成績求和，或者重復上面的順序→利用格式刷將合計的列的數(shù)據(jù)格式刷成與其他數(shù)據(jù)格式相同的格式（使用格式刷的方法是，先選中合計列外的其他任意一個單元格，點格式刷，然后再點需要刷成該樣格式的單元格即可）→保存文件→本題完成7. （1）；（2）計算出“凈資產(chǎn)收益率”，凈資產(chǎn)收益率=凈利潤247。3”來計算“平均成績”；（3）同名存盤。10003，稅后款=審定費審定費5%”；（3）利用菜單將“審定費”和“稅后款”列格式設(shè)置為貨幣類的“￥”貨幣符號、小數(shù)點1位（例￥1,）；（4）同名存盤?？偝煽?一階段成績+二階段成績+三階段成績；（3）“總成績”列數(shù)據(jù)格式為小數(shù)點后2位小數(shù)（例：）；（4）同名存盤。步驟：a) 文件→在各階段總成績單元格內(nèi)，點插入，點函數(shù)，在對話框中選擇求和函數(shù)“SUM”，在對話中Number1內(nèi)點右側(cè)的按鈕，將出現(xiàn)另外一個對話框，在文件中選擇需要求和的單元格，然后點該對話框的右側(cè)按鈕，點確定（完成一個總成績求和后，利用填充柄完成其他的總成績求和，或者重復上面的順序）→在平均成績單元格內(nèi)，點插入，點函數(shù)，選擇算術(shù)平均值函數(shù)AVERAGE，出現(xiàn)對話框后，采用求和時的相同方法，完成操作→選中平均成績行，點右鍵點設(shè)置單元格，點數(shù)字，在分類項下點數(shù)值，設(shè)小數(shù)位為1，b) 確定→保存2. （1）；（2）根據(jù)工作表中給定數(shù)據(jù)，按“合計=交通費+住宿費+補助”公式計算“合計”數(shù)，并計算交通費、住宿費和補助的合計數(shù)；（3）所有數(shù)字以單元格格式中貨幣類的“￥”貨幣符號、小數(shù)點后2位數(shù)表現(xiàn)（如：￥2,）；（4）同名存盤。3. 你認為貸款的學生如何對待還貸問題。Annual Expenses on Learning EnglishThe pie charts show us the proportion parison of English materials purchase made by the college students in X city in the early 90s and in 2003. In 2003 there are more new choices for the students to spend money on, like Internet (10%), CD\VCD(30%), and tapes(20%). In the early 90s there were only tapes (35%) and reference books(67%). At the same time, the other graph shows that the average outgoings on English materials have increased from 60 yuan in the early 90s to 170 yuan in 2003. From these two graphs, we have learned that there are more choices of materials in learning English and students spend more money on English learning.Some reasons can explain this trend. First, many students realize the importance of learning English. English is widely used all over the world. It has bee an important international language. Second, since China entered WTO, learning English has bee more popular. It is difficult to find a decent job without fluent English municating skills. Third, as science and technology have been developing so fast, these latest English learning facilities have already been proved far more useful and effective than the books.In my opinion, this growing trend might be different in the future. Nowadays most pupils begin to learn English. One day in the future college students don’t need to spend so much in learning English. Their English will be as fluent as those native speakers.貸款1. 現(xiàn)今，在高校通過助學貸款完成學業(yè)的學生越來越多。2. 解釋發(fā)生以上變化的原因（可涉及對英語的重視程度增加；科技發(fā)展使新的學習產(chǎn)品不斷涌現(xiàn)）。s nice to find a hot discussion about English learning appeared in your newspaper, and I39。2. 因特網(wǎng)給人們生活帶來的影響（好的方面，不好的方面）3. 你的觀點Surfing on the InternetNowadays, Internet is being very popular in all walks of life. On the one hand, statistics show that the number of people who apply to have access to Internet doubles every six months. On the other hand, Internet is employed in business, government agencies, and educational sections.Internet brings us a both advantages and disadvantages. The advantages are as the following. Firstly, we can municate with our friends more rapidly and quickly. Secondly, Internet brings us fun. For example, many websites open chat rooms where we can talk with different people and make new friends. Finally, many businessmen are taking so called business seriously on the net.The Internet also has its disadvantages, just as a coin has two sides. In the first place, some people may linger too long on the net while neglecting their work or study. In the second place, some columns on the net may have a negative influence on the youth electronic merce.In my opinion, Internet bees an integral part of our lives, but it is certainly not everything. Living in the 21st century, we need to make good use of the new toolInternet, but it is just a tool, not life itself. We should not depend on it too much, nor should we ignore it deliberately.十三、Englishlearning1) 全民學英語是一件好事，應該鼓勵； 2) 國家、學校、出版業(yè)和個人都應該做出自己的貢獻；3) 英語學習應當以提高日?？谡Z、閱讀以及實用寫作能力為主。 financial burden.However, problems may also arise. Firstly, some students spend too much time doing part time jobs while neglecting their studies. Secondly, when taking parttime jobs, the students may be distracted from their studies by the colorful lives in the society. Thirdly, some students may be cheated or hurt by their employers, because they don39。3． 你的觀點。Attend Your Classes RegularlyNowadays it is a very mon phenomenon for some university students to belate for or even be absent from their classes. And still there are some students who slip out of the classroom before the class is over. Class attendance has bee a thorny problem to both the students and the teachers.In fact, it is very important for the students to attend their classes regularly. First,it will ensure you to catch up with