电大度大学英语b-week8-9+答案+《excel在会计日常工作中的应用》课程表复习过程

《电大度大学英语b-week8-9+答案+《excel在会计日常工作中的应用》课程表复习过程》由会员分享，可在线阅读，更多相关《电大度大学英语b-week8-9+答案+《excel在会计日常工作中的应用》课程表复习过程（26页珍藏版）》请在装配图网上搜索。

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

2、9： 4010：30数据透视表格式调整双坐标图表文本文件的导入在数据透视表中设置公式自动筛选第 5 讲编辑公式技巧5每月第一个周六上午 10：3010：40第 6 讲工资条打印加载东东报表合并工具日报表格式的保护日报表汇总20每月第一个周六现金日记账边线和字体颜色设置上午 10：4011：20现金日记账类别下拉列表设置现金日记账中记账符号设置和作用余额公式设置第 7 讲费用计划差异表的结构和使用合并资产负债表的制作每月第一个周六现金流量表的制作原理10上午 11：2011：40小企业报表编制工具的期末结转小企业报表编制工具的日常操作第17讲以上内容80每月第一个周六上午 8： 3011：40每

3、讲上课前请签到。 地址：安庆市迎江区红旗小区 89 栋二单元204 室；电话：13855695986；QQ 群：85941694精品文档精品文档Test 2第一部分：交际用语（共10 小题；每小题1 分，满分10 分）C1. Who s that speaking? This is Tom _A. speaksB. spokenC. speakingD. sayingA2. I m sorry. I lost the key. _A. Well, it s OK.B. No, it s all right.C. You are welcome.D. You are wrong.B3.It s

4、rather cold in here. Do you mind if I close the window? _A. Yes, please.B. No, go ahead.D. I don t like it.C4._ He teaches physics in a school.A. What does your father want to do? C. What is your father?D 5.Excuse me, how much is the jacket? It s 499 Yuan. _.A. Oh, no. Tha t s OK!C. Which do you pre

5、fer?B6._C. Sure, please.B. Who is your father?D. Where is your father now?B. How do you like it?D. Would you like to try it on? 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 Pari

6、s last Wednesday?D. When will your parents go to Paris?C7.How often do you go dancing? _A. I will go dancing tomorrow.B. Yesterday.C. Every other day.D. I ve been dancing for a year.B8.You know, I have three kids now. _A. Well,I ve grown a mustache.B. That s terrific!C. Say, you ve really changed yo

7、ur hair.D. Well, I gave up drinking.C9.How about going to dinner at the Mexican restaurant tonight? _A. Forget it.B. Sorry, I like Mexican food.C. That s 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.

8、 Sorry,I m new here.第二部分：阅读理解（共15 小题；每小题2 分，满分30 分）Passage 1Sixteen-year-old Maria was waiting in line at the airport in Santo Domingo.She was leavingher nativecountryto joinher sisterin the UnitedStates.She spokeEnglish very well. Though she was very happy she could go abroad, she was feelingsad at

9、 leavingher familyand fiends.As she was thinkingallabout this,she suddenlyheard the airlineemployee askingher to pickup her luggage and put iton the scales（称） . Maria pulled and pulled. The bag was too heavy and she just couldn t liftit up. The man behind her got very impatient. He, too, was waiting

10、 to check in his luggage.“ What s wrong with this girl?” He said,“ Why doesn t she hurry up?” Hemoved forward and placed his bag on the counter, hoping to check in fist. He wasin a hurry to get a good seat.Maria was very angry,but she was very polite.And in her best Englishshe said,“Why are you so u

11、pset? There are enough seats for everyone on the plane. If youare in such a hurry, why can t you give me a hand with my luggage?”The man was surprised to hear Maria speak English. He quickly picked up herluggageand stepped back.Everyone was lookingat him withdisapproval.(224 words)D11. Maria s story

12、 happened _.A. when she was leaving America B. on her way back 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 isto _ at the airport.A. help carry peoples luggageB. ask people to pick up the lu

13、ggageC. check people s luggageD. take care of people s luggageC13.“ Why are you so upset?” Maria said to the man. She wanted to tell him thathe should not be _.A. surprisedB. sadC. unhappyD. sorryD14. “ Everyone was lookingat him withdisapproval.” Thissentencemeans thatthepeople around felt _.A. wor

14、ried about MariaB. worried about the manC. sorry for Maria s mannersD.sorryfortheman smannersA 15. The author mentioned Maria s age at the beginning of the story in order toshow that _.A. she was young but behaved properlyB. she would not have left home aloneC. everyone around her was wrongD. it was

15、 not good that nobody offered to help her精品文档精品文档Passage 2There are threekindsof goals:short-term,medium-range and long-termgoals.Short-term goals are those that usually deal with current activities, whichwe can apply on a daily basis. Such goals can be achieved in a week or less, or twoweeks, or po

16、ssibly, months. It should be remembered that just as a building is nostronger than its foundation, long-term goals cannot amount to very much withoutthe 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

17、 build onthose that have been completed.The intermediate goals build on the foundation of the short-term goals. Theymight deal with just one term of school or the entire school year, or they couldeven extendforseveralyears.Any time you move a stepat a time,you shouldneverallowyourselfto become disco

18、uragedor overwhelmed.As you completeeach step,youwill 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

19、not a static thing. We should never 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 sh

20、ort-term goals are built upon _.A. a daily basisB. your achievement in a weekC. current activitiesD. the goalsthathave 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 des

21、ire for setting new goalsC19.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.Thelimitationoflong-term goals.C 20.Which ofthefollowingstatementsiswrongaccordingtothepassage?_A. The long-term goals cannot amount

22、 to very much 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 shouldoftenadd new short-termgoalsto those which h

23、ave been completed.精品文档精品文档Passage 3Britain andFrance are separated bythe EnglishChannel, a body of water thatcan 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 100thanniversary（周年纪念）of the si

24、gning of a friendship agreement called the Entente Cordiality. The agreement marked a new beginning for the countries following centuries of wars and love-hate partnership.But theirrelationshiphas been ups and downs over the pastcentury.Justlastyear,therewere fiercedisagreementsover the Iraqwar-whic

25、hBritishPrime MinisterTony Blair supported despite French President Jacques Chirac speaking out againstit.ThisdiscomfortisexpressedinBlairandChirac sbodylanguageatinternational meetings. While the French leader often greets German ChancellorGerhard Schroeder witha hug（拥抱） , Blairjustreceivesa handsh

26、ake.However, somepolitical experts say the war in Iraq could in fact have helped ties.The historyof divisionsmay wellbe because of the very differentways in whichthe two sides see the world.But thisdoesn t stop 12 millionBritonstakingholidaysin France each year.However, only3 millionFrench come in t

27、he oppositedirection.Surveys （调查） show that most French people feel closer to the Germans than theydo to the British. And the research carried out in Britain has found that only athirdof the populationbelievesthe French can be trusted.Perhaps thisbad feelingcomes because the British dislike France s

28、 close relationship with Germany, orbecause the French are not happy with Britain s close links with the US.Whatevertheansweris,as bothsidescelebrate100 yearsof“ doubtfulfriendship” , they are at least able to make jokes about each other. Here s one:What s the best thing about Britain s relationship

29、 with France? The EnglishChannel. (320 words)D21.For centuries,the relationshipbetween Britainand France is _.A. friendly B. impoliteC. brotherlyD. a mixtureof loveand hateD22.The war in Iraq does _ to the relationship between France andBritain.A. goodB. harmC. neither good nor harmD. both good and

30、harmA23.The British are not so friendly to _ and the French are not sofriendly to _.A. Germany; AmericaB. America; GermanyC. Germany; GermanyD. America; AmericaD24._ are more interested in having holidays in _.A. American peopleBritainB. British peopleGermanyC. French peopleBritainD. British peopleF

31、ranceC 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.C.Franceand Britain arenearneighbors,and thiswillhelpb

32、alancetherelationship between them.D. The English Channel is the largest enemy between France and Britain.第三部分：词汇与结构（共20 小题；每小题1 分，满分20 分）A26.I don t know the park, but it s _ to be quite beautiful.A. saidB. toldC. spokenD. talkedB27.Mike is better than Peter _ swimming.A. forB. atC. onD. inA28.The

33、baby is hungry, but there s _ milk in the bottle.A. littleB. a littleC. fewD. a fewD29.Nancy is _ girl.A. a eighteen-year-oldB. an eighteen-years-oldC. a eighteen-years-oldD. an eighteen-year-oldA 30.Harry,who had failedin the finalexam, had a greatworry _ hismind.A. onB. inC. withD. atin ones mind在

34、某人的脑海中on ones mind使人担心 , 惦念C31.Do you know the man _ under the apple tree?A. layB. lainC. lyingD. layingC32.Is the library _ now? No, it s _.A. open; closeB. opening; losingC. open; closedD. opened; closedD33.When shall we meet again? _ it any day you like. It s all the same to me.A. DoB. GetC. Meet

35、D. MakeD34._ girl dressed _ black is her sister Rose.A. A; inB. A; onC. The; onD. The;inC 35.Although he didnot know London well, he made hisway _ tothe airport.A. easy enoughB. enoughC. easily enoughD. enough easilyD36.Two thousand dollars _ enough for the car.A. beingB. wereC. areD. isB37.They hav

36、e 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, feelingpleased _ he was a man of action.A. whichB. thatC. whatD. whether精品文档litt

37、le D42.精品文档C39. _? She s our history teacher.A. What s sheB. Where does the woman workC. Who is sheD. How is the womanB 40.Today s weather is _ worse than yesterday s.A. veryB. muchC. very muchD. much tooB41.It is said that _ boys in your school like playing football in theirspare time, though other

38、s prefer basketball.A. quite a lotB. quite a fewC. quite a bitD.quitea What s his mother like? _.A. She s very happyB. She s at homeC. She likes watching TVD. She s tall and thinD43.The new order means _ overtime.A. worksB. workedC. to workD. workingD44. She has two best friends. _ of them is in the

39、 country.A. AllB. BothC. No oneD. NeitherC 45.Iwas givinga talktoa largegroupofpeople, thesame talkI _ tohalfa dozen other groups before.A. was givingB. am givingC. had givenD.havegiven第四部分：完形填空（共10 小题；每小题1 分，满分 10 分）Many students find the experience of attending university lectures to be aconfusing

40、 and frustrating experience. The lecturer speaks for one or two hours,perhaps46 the talk with slides, writing up important information on theblackboard,47readingmaterialand givingoutassignment.The new studentseesthe otherstudentscontinuouslywritingon notebooksand48whattowrite.Veryoften the student l

41、eaves the lecture with notes which do not catch the main pointsand49become hard even for the students to understand.Most institutions provide courses which assist new students to develop theskillstheyneed to be 50listenersand not-takers.Iftheseare unavailable,therearemany usefulstudy-skillsguideswhi

42、ch51learnersto practicetheseskills independently. In all cases it is important to52the problem beforeactually starting your studies.Itisimportanttoacknowledgethatmoststudentshavedifficulty53acquiring the language skills required in college study. One way of54thesedifficultiesistoattendthelanguageand

43、study-skillsclasseswhichmostinstitutionsprovidethroughouttheacademicyear.Another basicstrategyistofinda studypartner55itispossibletoidentifydifficulties,exchange ideasandprovide support.B46.A. extendingB. illustratingC. performingD.conductingC47.A. attributingB. contributingC. distributingD.精品文档精品文档

44、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. sustain

45、ingD.overcomingC 55.A. in thatB. for whichC. with whomD. suchas第五部分：英翻汉（满分15 分）56. Apples here like water and sunshine.56. 这里的苹果喜欢水和阳光。57.Tomwas such a hardworkingstudentthathe soon came out firstin the class.57. 汤姆是一个学习十分用功的学生，以至于不久他就成了班里学习最好的学生。58. Ted and William have lived under the same roof fo

46、r five years.58. 泰德和威廉已经在同一个屋檐下生活了五年了。59. You needn t go there anymore. He already knows about it.59. 你不必去了，他已经知道那件事了。60. As is known to all, China is a developing country.60. 众所周知，中国是一个发展中国家。第六部分：写作（满分15 分）要求在30 分钟内，根据下面所给的题目和中文提纲用英语写出一篇不少于80 词的短文。Water and Life1随着工业化（industrialization）的推进，地球上的淡水（f

47、resh water）越来越少。2生命没水就要消亡（disappear ），因此人类要珍惜（treasure）淡水。3我们如何节约用水。Water and LifeWhile we are enjoyingthe richfruitsof modern industrialization,we are losingsomething precious on this planet. Fresh water, among others, is dwindling down day by day, owing to the large-scale industrialization everywh

48、ere in the world.精品文档精品文档Just as sunshine is a necessity to life, so is fresh water. Without fresh water, our human society would come to a stop.As fresh water is such an important resource to the human society, we need to treasure it as we treasure our life, but how?First, our government should hav

49、e a good plan for the use of fresh water and develop industries that consume less water. Second, waste water must be recycled. Finally everyone of us should do his bit to save water.练习卷Paper ThreeI. 交际用语（共5 题）1. -How do you do ?-_.A. Very well.B. How do you do?C. I m a doctor.D. Nice to have known y

50、ou.2. -Are you feeling better today, Jack?-_A. There must be something wrong.B. Just have a good rest.C. Yes, thank you, doctor. But I still dont feel good.D. Don t worry about me.3. -Oh, Betty, we will be having a buffet party next Saturday, and we d like you to join us.- _. Susan. What s the occas

51、ion? What time do you want me to come?A. I d love toB. No wayC. By no meansD. I m afraid not.4. - Could you be so kind as to turn down that rock“ n” roll? I m preparing for tomorrowexam.-_A. It s none of your business.B. What are you doing?精品文档精品文档C. Sure. Sorry to disturb you.D. No, I don t think s

52、o.5. - How are you, Bob?- _. Ted.A. How are you?B. I m fine. Thank you.C. How do you do?D. Nice to meet you.II. 阅读理解（共 10 题）Passage One:In England, people often talk about the weather because they can experience four seasons in one day. In the morning the weather is warm just like in spring. An hour

53、 later black clouds come and then it rains hard. The weather gets a little cold. In the late afternoon the sky will be sunny, the sun will begin to shine, and it will be summer at this time of a dayIn England, people can also have summer in winter, or have winter in summer. So in winter they can swim sometimes, and in summer sometimes th