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

《Excel在会计日常工作中的应用》课程表 培训内容 第1讲 打开权限密码 打印带背景的表格 快速打印表格 设置可以打印的表格背景 设置自动保存 一次打开多个EXCEL文件 定义名称 区域内快速录入相同的内容 填充间隔 限制身份证号码录入长度 库龄分析 应收账款催款提醒 多条件排序 高级筛选之一：在数据表工作表内筛选 高级筛选之二：筛选不重复记录 恢复排序前状态 每隔一行添加空行 数据透视表创建 数据透视表多表合并 数据透视表格式调整 双坐标图表 文本文件的导入 在数据透视表中设置公式 自动筛选 编辑公式技巧 工资条打印 加载东东报表合并工具 日报表格式的保护 日报表汇总 现金日记账边线和字体颜色设置 现金日记账类别下拉列表设置 现金日记账中记账符号设置和作用 余额公式设置 费用计划差异表的结构和使用 合并资产负债表的制作 现金流量表的制作原理 小企业报表编制工具的期末结转 小企业报表编制工具的日常操作 以上内容 学费（元） 上课时间（初定） 10 每月第一个周六 上午8：30~9：00 第2讲 15 每月第一个周六 上午9：00~9：30 每月第一个周六 上午9：30~9：40 第3讲 第4讲 5 30 每月第一个周六 上午9：40~10：30 第5讲 第6讲 5 每月第一个周六 上午10：30~10：40 20 每月第一个周六 上午10：40~11：20 第7讲 10 每月第一个周六 上午11：20~11：40 第1~7讲 80 每月第一个周六 上午8：30~11：40 每讲上课前请签到。地址：安庆市迎江区红旗小区89栋二单元204室；电话：13855695986；QQ群：85941694

Test 2

第一部分：交际用语（共10小题；每小题1分，满分10分） C1. —Who’s that speaking?

—This is Tom ____________

A. speaks B. spoken C. speaking D. saying

A2. —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 rather cold in here. Do you mind if I close the window?

—____________

A. Yes, please. B. No, go ahead. C. Sure, please. D. I don’t 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?

—It’s 499 Yuan. ____________.

A. Oh, no. That’s OK! B. How do you like it?

C. 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 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 your 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. Sorry, I’m new here.

第二部分：阅读理解（共15小题；每小题2分，满分30分）

Passage 1

Sixteen-year-old Maria was 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 suddenly 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 couldn’t lift it up. The man behind her got very impatient. He, too, was waiting to check in his luggage.

“What’s wrong with this girl?” He said, “Why doesn’t 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 are 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 her luggage and stepped back. Everyone was looking at him with disapproval. (224 words)

D11. Maria’s story happened ________.

A. when she was leaving America B. on her way back to Santo Domingo C. before she left the USA D. when she arrived at the airport

C12. You believer that the work of the airline employee mentioned in the story is to _______ at the airport.

A. help carry people’s luggage B. ask people to pick up the luggage C. check people’s luggage D. take care of people’s luggage

C13. “Why are you so upset?” Maria said to the man. She wanted to tell him that he should not be _______.

A. surprised B. sad C. unhappy D. sorry D14. “Everyone was looking at him with disapproval.” This sentence means that the people around felt _______.

A. worried about Maria B. worried about the man

C. sorry for Maria’s manners D. sorry for the man’s manners

A 15. The author mentioned Maria’s age at the beginning of the story in order to show that _________.

A. she was young but behaved properly B. she would not have left home alone

C. everyone around her was wrong D. it was not good that nobody offered to help her

Passage 2

There 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 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 intermediate 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 complete 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 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 goals B. If we complete the short-term goals

C. If we have dreams of the future D. If we put forward some plans

D17. New short-term goals are built upon ____________.

A. a daily basis B. your achievement in a week

C. current activities D. the goals that have been completed C18. When we complete each step of our goals, ____________.

A. we will win final success B. we are overwhelmed C. we should build up confidence of success

D. we should have strong desire for setting new goals C19. What is the main idea of this passage? ____________

A Life is a dynamic thing. B. we should set up long-term goals C. 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 much without the achievement of solid short-term goals

B. 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 been completed.

Passage 3

Britain 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.

th

Last Thursday Britain and France celebrated the 100 anniversary（周年纪念）of the signing 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 their relationship has been ups and downs over the past century. Just last year, there were fierce disagreements over the Iraq war-which British Prime Minister Tony Blair supported despite French President Jacques Chirac speaking out against it. This discomfort is expressed in Blair and Chirac’s body language at international meetings. While the French leader often greets German Chancellor Gerhard Schroeder with a hug（拥抱）, Blair just 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 doesn’t stop 12 million Britons taking holidays in France each year. However, 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 comes because the British dislike France’s close relationship with Germany, or because the French are not happy with Britain’s 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. Here’s one: What’s the best thing about Britain’s relationship with France? The English Channel. (320 words)

D21. For centuries, the relationship between Britain and France is ____________.

A. friendly B. impolite C. brotherly D. a mixture of love and hate D22. The war in Iraq does ____________ to the relationship between France and Britain.

A. good B. harm

C. neither good nor harm D. both good and harm

A23. The British are not so friendly to ____________ and the French are not so friendly to ____________.

A. Germany; America B. America; Germany C. Germany; Germany D. America; America

D24. ____________ are more interested in having holidays in ____________.

A. American people…Britain B. British people … Germany C. French people … Britain D. British people … France C 25. What does the last sentence mean?

A. As long as the English Channel exists, no further disagreement will form between France and Britain.