电大2012年度大学英语B-week8-9+答案+《Excel在会计日常工作中的应用》课程表(共20页).doc

《电大2012年度大学英语B-week8-9+答案+《Excel在会计日常工作中的应用》课程表(共20页).doc》由会员分享，可在线阅读，更多相关《电大2012年度大学英语B-week8-9+答案+《Excel在会计日常工作中的应用》课程表(共20页).doc（20页珍藏版）》请在淘文阁 - 分享文档赚钱的网站上搜索。

1、精选优质文档-倾情为你奉上Excel在会计日常工作中的应用课程表培训内容学费（元）上课时间（初定）第1讲打开权限密码打印带背景的表格快速打印表格设置可以打印的表格背景设置自动保存一次打开多个EXCEL文件10每月第一个周六上午8：309：00第2讲定义名称区域内快速录入相同的内容填充间隔限制身份证号码录入长度15每月第一个周六上午9：009：30第3讲库龄分析应收账款催款提醒5每月第一个周六上午9：309：40第4讲多条件排序高级筛选之一：在数据表工作表内筛选高级筛选之二：筛选不重复记录恢复排序前状态每隔一行添加空行数据透视表创建数据透视表多表合并数据透视表格式调整双坐标图表文本文件的导入在数

2、据透视表中设置公式自动筛选30每月第一个周六上午9：4010：30第5讲编辑公式技巧5每月第一个周六上午10：3010：40第6讲工资条打印加载东东报表合并工具日报表格式的保护日报表汇总现金日记账边线和字体颜色设置现金日记账类别下拉列表设置现金日记账中记账符号设置和作用余额公式设置20每月第一个周六上午10：4011：20第7讲费用计划差异表的结构和使用合并资产负债表的制作现金流量表的制作原理小企业报表编制工具的期末结转小企业报表编制工具的日常操作10每月第一个周六上午11：2011：40第17讲以上内容80每月第一个周六上午8：3011：40每讲上课前请签到。地址：安庆市迎江区红旗小区89栋

3、二单元204室；电话：；QQ群：Test 2第一部分：交际用语（共10小题；每小题1分，满分10分）C1.Whos that speaking?This is Tom _A. speaksB. spokenC. speakingD. sayingA2.Im sorry. I lost the key. _A. Well, its OK.B. No, its all right.C. You are welcome.D. You are wrong.B3. Its rather cold in here. Do you mind if I close the window? _A. Yes, p

4、lease.B. No, go ahead.C. Sure, please.D. I dont like it.C4. _He teaches physics in a school.A. What does your father want to do?B. Who is your father?C. What is your father?D. Where is your father now?D 5. Excuse me, how much is the jacket?Its 499 Yuan. _.A. Oh, no. Thats OK!B. How do you like it?C.

5、 Which do you prefer?D. Would you like to try it on?B6. _Well, they got there last Wednesday. So about a week.A. When did your parents arrive at Paris?B. How long have your parents been in Paris?C. Did your parents arrive at Paris last Wednesday?D. When will your parents go to Paris?C7. How often do

6、 you go dancing?_A. I will go dancing tomorrow.B. Yesterday.C. Every other day.D. Ive been dancing for a year.B8. You know, I have three kids now._A. Well, Ive grown a mustache.B. Thats terrific!C. Say, youve really changed your hair.D. Well, I gave up drinking.C9. How about going to dinner at the M

7、exican restaurant tonight?_A. Forget it.B. Sorry, I like Mexican food.C. Thats great!D. Glad you like it.D 10. Madam, do all the buses go downtown?_A. Wow, you got the idea.B. No, never mind.C. Pretty well, I guess.D. Sorry, Im new here.第二部分：阅读理解（共15小题；每小题2分，满分30分）Passage 1Sixteen-year-old Maria was

8、 waiting in line at the airport in Santo Domingo. She was leaving her native country to join her sister in the United States. She spoke English very well. Though she was very happy she could go abroad, she was feeling sad at leaving her family and fiends. As she was thinking all about this, she sudd

9、enly heard the airline employee asking her to pick up her luggage and put it on the scales（称）. Maria pulled and pulled. The bag was too heavy and she just couldnt lift it up. The man behind her got very impatient. He, too, was waiting to check in his luggage.“Whats wrong with this girl?” He said, “W

10、hy doesnt she hurry up?” He moved forward and placed his bag on the counter, hoping to check in fist. He was in a hurry to get a good seat.Maria was very angry, but she was very polite. And in her best English she said, “Why are you so upset? There are enough seats for everyone on the plane. If you

11、are in such a hurry, why cant you give me a hand with my luggage?”The man was surprised to hear Maria speak English. He quickly picked up her luggage and stepped back. Everyone was looking at him with disapproval. (224 words)D11. Marias story happened _.A. when she was leaving AmericaB. on her way b

12、ack to Santo DomingoC. before she left the USAD. when she arrived at the airportC12. You believer that the work of the airline employee mentioned in the story is to _ at the airport.A. help carry peoples luggageB. ask people to pick up the luggageC. check peoples luggageD. take care of peoples lugga

13、geC13. “Why are you so upset?” Maria said to the man. She wanted to tell him that he should not be _.A. surprisedB. sadC. unhappyD. sorryD14. “Everyone was looking at him with disapproval.” This sentence means that the people around felt _.A. worried about MariaB. worried about the manC. sorry for M

14、arias mannersD. sorry for the mans mannersA 15. The author mentioned Marias age at the beginning of the story in order to show that _.A. she was young but behaved properlyB. she would not have left home aloneC. everyone around her was wrongD. it was not good that nobody offered to help herPassage 2T

15、here are three kinds of goals: short-term, medium-range and long-term goals.Short-term goals are those that usually deal with current activities, which we can apply on a daily basis. Such goals can be achieved in a week or less, or two weeks, or possibly, months. It should be remembered that just as

16、 a building is no stronger than its foundation, long-term goals cannot amount to very much without the achievement of solid short-term goals. Upon completing our short-term goals, we should date the occasion and then add new short-term goals that will build on those that have been completed.The inte

17、rmediate goals build on the foundation of the short-term goals. They might deal with just one term of school or the entire school year, or they could even extend for several years. Any time you move a step at a time, you should never allow yourself to become discouraged or overwhelmed. As you comple

18、te each step, you will enforce the belief in your ability to grow and succeed. And as your list of completion dates grow, your motivation and desire will increase.Long-term goals may be related to our dreams of the future. They might cover five years or more. Life is not a static thing. We should ne

19、ver allow a long-term goal to limit us or our course of action.(221 words)B16. Our long-term goals mean a lot _.A. If we cannot reach solid short-term goalsB. If we complete the short-term goalsC. If we have dreams of the futureD. If we put forward some plansD17. New short-term goals are built upon

20、_.A. a daily basisB. your achievement in a weekC. current activitiesD. the goals that have been completedC18. When we complete each step of our goals, _.A. we will win final successB. we are overwhelmedC. we should build up confidence of successD. we should have strong desire for setting new goalsC1

21、9. What is the main idea of this passage? _A Life is a dynamic thing.B. we should set up long-term goalsC. Different kinds of goals in life.D. The limitation of long-term goals.C 20. Which of the following statements is wrong according to the passage? _A. The long-term goals cannot amount to very mu

22、ch without the achievement of solid short-term goalsB. The intermediate goals build on the foundation of the short-term goals.C. Life is a static thing, thus we should never allow a long-term goal to limit us or our course of action.D. We should often add new short-term goals to those which have bee

23、n completed.Passage 3Britain and France are separated by the English Channel, a body of water that can be crossed in as few as 20 minutes. But the cultures of the two countries sometimes seem to be miles apart.Last Thursday Britain and France celebrated the 100th anniversary（周年纪念）of the signing of a

24、 friendship agreement called the Entente Cordiality. The agreement marked a new beginning for the countries following centuries of wars and love-hate partnership.But their relationship has been ups and downs over the past century. Just last year, there were fierce disagreements over the Iraq war-whi

25、ch British Prime Minister Tony Blair supported despite French President Jacques Chirac speaking out against it. This discomfort is expressed in Blair and Chiracs body language at international meetings. While the French leader often greets German Chancellor Gerhard Schroeder with a hug（拥抱）, Blair ju

26、st receives a handshake. However, some political experts say the war in Iraq could in fact have helped ties.The history of divisions may well be because of the very different ways in which the two sides see the world. But this doesnt stop 12 million Britons taking holidays in France each year. Howev

27、er, only 3 million French come in the opposite direction. Surveys（调查）show that most French people feel closer to the Germans than they do to the British. And the research carried out in Britain has found that only a third of the population believes the French can be trusted. Perhaps this bad feeling

28、 comes because the British dislike Frances close relationship with Germany, or because the French are not happy with Britains close links with the US.Whatever the answer is, as both sides celebrate 100 years of “doubtful friendship”, they are at least able to make jokes about each other. Heres one:

29、Whats the best thing about Britains relationship with France? The English Channel. (320 words)D21. For centuries, the relationship between Britain and France is _.A. friendlyB. impoliteC. brotherlyD. a mixture of love and hateD22. The war in Iraq does _ to the relationship between France and Britain

30、.A. goodB. harmC. neither good nor harmD. both good and harmA23. The British are not so friendly to _ and the French are not so friendly to _.A. Germany; AmericaB. America; GermanyC. Germany; GermanyD. America; AmericaD24. _ are more interested in having holidays in _.A. American peopleBritainB. Bri

31、tish people GermanyC. French people BritainD. British people FranceC 25. What does the last sentence mean?A. As long as the English Channel exists, no further disagreement will form between France and Britain.B. The English Channel can prevent anything unfriendly happening in both France and Britain

32、.C. France and Britain are near neighbors, and this will help balance the relationship between them.D. The English Channel is the largest enemy between France and Britain.第三部分：词汇与结构（共20小题；每小题1分，满分20分）A26. I dont know the park, but its _ to be quite beautiful.A. saidB. toldC. spokenD. talkedB27. Mike

33、 is better than Peter _ swimming.A. forB. atC. onD. inA28. The baby is hungry, but theres _ milk in the bottle.A. littleB. a littleC. fewD. a fewD29. Nancy is _ girl.A. a eighteen-year-old B. an eighteen-years-oldC. a eighteen-years-oldD. an eighteen-year-oldA 30. Harry, who had failed in the final

34、exam, had a great worry _ his mind.A. onB. inC. withD. atin ones mind在某人的脑海中on ones mind使人担心, 惦念C31. Do you know the man _ under the apple tree?A. layB. lainC. lyingD. layingC32. Is the library _ now?No, its _.A. open; closeB. opening; losingC. open; closedD. opened; closedD33. When shall we meet ag

35、ain?_ it any day you like. Its all the same to me.A. DoB. GetC. MeetD. MakeD34. _ girl dressed _ black is her sister Rose.A. A; inB. A; onC. The; onD. The; inC 35. Although he did not know London well, he made his way _ to the airport.A. easy enoughB. enoughC. easily enoughD. enough easilyD36. Two t

36、housand dollars _ enough for the car.A. beingB. wereC. areD. isB37. They have learned about _ in recent years.A. several hundreds English wordsB. hundreds of English wordsC. hundred of English wordsD. several hundred English wordB38. With his work completed, the manager stepped back to his seat, fee

37、ling pleased _ he was a man of action.A. whichB. thatC. whatD. whetherC39. _? Shes our history teacher.A. Whats sheB. Where does the woman workC. Who is sheD. How is the womanB 40. Todays weather is _ worse than yesterdays.A. veryB. muchC. very muchD. much tooB41. It is said that _ boys in your scho

38、ol like playing football in their spare time, though others prefer basketball.A. quite a lotB. quite a fewC. quite a bitD. quite a littleD42. Whats his mother like?_.A. Shes very happyB. Shes at homeC. She likes watching TVD. Shes tall and thinD43. The new order means _ overtime.A. worksB. workedC.

39、to workD. workingD44. She has two best friends. _ of them is in the country.A. AllB. BothC. No oneD. NeitherC 45. I was giving a talk to a large group of people, the same talk I _ to half a dozen other groups before.A. was givingB. am givingC. had givenD. have given第四部分：完形填空（共10小题；每小题1分，满分10分）Many s

40、tudents find the experience of attending university lectures to be a confusing and frustrating experience. The lecturer speaks for one or two hours, perhaps 46 the talk with slides, writing up important information on the blackboard, 47 reading material and giving out assignment. The new student see

41、s the other students continuously writing on notebooks and 48 what to write. Very often the student leaves the lecture with notes which do not catch the main points and 49 become hard even for the students to understand.Most institutions provide courses which assist new students to develop the skill

42、s they need to be 50 listeners and not-takers. If these are unavailable, there are many useful study-skills guides which 51 learners to practice these skills independently. In all cases it is important to 52 the problem before actually starting your studies.It is important to acknowledge that most s

43、tudents have difficulty 53 acquiring the language skills required in college study. One way of 54 these difficulties is to attend the language and study-skills classes which most institutions provide throughout the academic year. Another basic strategy is to find a study partner 55 it is possible to

44、 identify difficulties, exchange ideas and provide support.B46. A. extendingB. illustratingC. performingD. conductingC47.A. attributingB. contributingC. distributingD. explainingC48. A. suspectsB. understandsC. wondersD. convincesD49. A. whatB. thoseC. asD. whichA 50. A. effectiveB. passiveC. relativeD. expressiveA51. A. enableB. stimulateC. advocateD. preventC52. A. evaluateB. acquaintC. tackleD. formulateA53. A. inB. onC. ofD. withD54. A preventingB. withstandingC. sustainingD. overcomingC 55. A. in thatB. for whichC.