在excell中,如何进行字符组合?

____teacher standing in front of our classroom is ____excellent teacher of our school.

在EXCELL中,A1=2013-2-10,B1=2013-2-15,C1=2013-3-5(意思是单元格内均为日期）,要求在D1单元格内显示最晚的日期,公式怎么写,请问高手?

在ExcelL 如何在一堆数中把[0][1][2]..等.里面的数字加上1变成[1],[2] ,[3]等.
各个[0]数不在同一列

用excell统计一列中0~9个数据出现的次数升序排列单一0~（次数相同按先出现排前）
数字
1
2
3
1
3 排列 2 1 3

单句改错
1、Hellen is the oniy of the girls Iknow who speak excellent English.__________
2.They both have made a decision returning to their hometown.__________
3."Do you like the material?" "Yes,it is felt very soft."_________
4.As is known to us all that the earth moves aroundthe sun.________
5.I feel it an honour to ask to speak here._________
6.In the accident three people lost their life.___
7.That is necessary for us to read Engligh every morning.________
8.When we arrived at the airport the plane took off._____________
9.The beggar put some old newspapers over him to keep the cold off._________
10.The ballpen is written quite smoothly._________

英语翻译
Computer games do have their advantages .They are excellent for training hand and eye coordination(协调).Surgeons(外科医生) who played computer games as children are often more skilled.Computer games can also be great for teaching students.The students are open to learning while playing.They can study for longer than a teacher would be able to teach.Students can also learn about their own speed and not feel pressured to match classmates.And with computers you can practice a task as many times as you like.The more you do this,the better you will get,until you can do it perfectly.
　　But like anything else in life,things should be balanced.Too much time on the computer can hurt your eyes.Regular breaks are needed.If students cannot stop playing computer games,they won’t do as well in other areas in their life—not just schoolwork,but in developing important social skills such as how to talk with people and how to work with others as part of a team.And if they are no longer taking regular exercise,their health will become worse.
　　Computer games have their place,but people must also remember it is important to have a balanced lifestyle.

怎样用excell统计一列中所有不同数据出现的次数并降序排列?
例竖列数据为1,1,2,3,3,3统计结果显示为3：3次,1：2次,2：1次.

急需一篇140字的英语作文,
“travel is largely overrated;one can be excellent scholar without getting outdoors”please explain your view on the above statement,to what extend do you think travel is imortant in education

我想用EXCELL实现一个输入.如B13输入的数字小于5,B14等于300.如B13大于等于5,小于10,B14等于200.
如果B13大于等于10,B14等于0.B14这个函数怎么写?
麻烦知道的帮忙下.

如何提取EXCELL单元格中的公式
ABC列为数值,D列为计算公式,E列为D列的计算结果
如A1=(1),B1=(2),C1=(3),D1=(=A1+B1*A3)(括号内为单元格内容,D1为文本),有没有办法把D1的公式提取出来让E1直接使用呢?

为什么EXCELL表格里,用公式得出的数209.44,其长度为16
第一个单元格数为72108.8,第二个为7376.21,第三个为79275.57,第四个单元格为公式（第一个+第二个-第三个）等于209.44.但我在第五个单元格输入209.44．用EXCAT公式校验为FALSE,用LEN公式测其长度为16.然后保留多为小数变成了209.4400000000000930000,为什么会出现0.0000000000009300呢?

如何在excell中使用countif函数,统计出同一列中相同数字重复的次数.
A B C D
11
12
13
15
12
11
14
15
我想在B列中统计出A列数字重复的次数,如何用COUNTIF设置函数.

英语词形变换 1. Each of my students has the [1] of being an excellent student. (capable)
1. Each of my students has the [1]of being an excellent student. (capable)
2. The singer gave an [2]performance, but it was not outstanding. (accept)
3. My parents will be [3]with me if I failed the exam. (disappoint)
4. The audience [4]liked the play because they applauded for two minutes at the end. (evident)
5. The picture quality is bad because the TV signal isn't [5] enough. (power)
6. [6]must be instilled in children when they are young, (honest)
7. Will they have the [7] to make the correct choice? (wise)
8. Little Bill found it hard to memorize the [8] laws his teacher taught. (physics)
9. It was so [9]of him to stamp out of the restaurant just because people didn't agree with what he said. (child)
10. Young people can no longer look forward with any [10]to a career or even a job. (certain)
11. He had a special [11] to put ideas to work quickly.(able)
12. Airplanes [12] people to travel great distances rapidly. (able)
13. Mr. Hobbs was annoyed at his son's [13] of mind in doing everything. (absent)
14. They finally reached an agreement that was [14] to both sides. (accept)
15. Quite a number of social [15] take up too much of his time. (active)
16. They need [16]help to get the work done as scheduled. (add)
17. Whenever Philip stayed out late, his mother would get [17](anxiety)
18. You should not judge a person by his [18] (appear)
19. Wandering in London parks at night, you can find quite a number of [19]sleeping on the benches. (beg)
20. When you are learning a foreign language, it is [20] to practice as much as possible. (benefit)
21. Dr. Smith is a well-known [21] in this country. (biology)
22. Her eyes [22] with pleasure when she saw the bunch of flowers on the table. (bright)
23. The road [23] at the shopping centre of the city. (broad)
24. It's true that travel [24] one's mind. (broad)
25. He looks [25] with that expression. (child)
26. He often acts [26] , although he is a father with a son 15 years old. (child)
27. He was born in China, spent his [27] in England, and now he is an American citizen. (child)
28. He is already 20 years old but still behaves [28] . (child)
29. How cheerful the room looks with so many [29] posters! (color)
30. It is believed that [30] between the heads of these countries can reduce the chances of war in the world. (communicate)

EXCELL中怎么算天数（要一年按360天计算的）
每月按30天算也是用days360函数还是别的?

请问,excell中,使用哪个函数能实现下面的计算?
如图,

第三列的数字等于第二列的数字减去上一行的数字,例如：464=35105-34641；443=36379-35936

关于英语中“好”的词的语气
请帮我把后面的单词按语气,由弱到强排个顺序：
splendid、wonderful、excellent、perfect、heavenly
另外,perfect f*cking good的语气是不是比great更强?

求助excell中的判定函数问题
两列数据A、B,判定条件有4种,如下图,C列输出该怎么列

excell里面排序如何让1a、1b自动排在1之后呢
excell里面有很多编号,1,1a,1b,1c,2,3,4,4a,4b等等.我用排序之后就变成1,2,3,4,1a,1b,1c,4a,4b了.我要弄成1,1a,1b,1c,2,3,4,4a,4b.急

Excell 高手,帮忙解析下,下列两个Excell函数.
=VLOOKUP(C32,Stundensätze!$A$4:$C$70,3)
=IF(H33="",1000/H33*1.512)
=IF(J78="","",+(J78-J75)/J75)

Excell单元格中的分式如何对分子分母进行同步放大或缩小
举例:如在一个单元格中的数值为:1.2/1.1,现在想在另外一个单元格中对"1.2/1.1"的分子分母同时乘以0.9再减去0.1,即:(1.2*0.9-0.1)/(1.1*0.9-0.1),分别保留分子分母的运算值不变,应该是"0.98/0.89",如何进行?公式如何编辑?不要计算出分式的结果,要保留"0.98/0.89"这个格式的结果.

EXCELL提成额怎样计算
1、某企业根据各销售部门的销售额及销售费用确定奖金提成比例及提取额，若销售额大于300000元且销售费用占销售额的比例不超过1%，则奖金提取比例为15%，否则为10%。用函数求出D列的提成比例，并用公式计算相应的提成额。
销售奖金提取比例
销售额 销售费用 奖金提成比例 奖金提成额
部门A 234325 3425
部门B 432465 5430
部门C 546742 5908
部门D 568736 4503
部门E 765833 5347
部门F 345873 3246
部门G 289050 1256
部门H 423578 5428

Excell中不同时间间隔的数据画在同一张图上
事情是这样的,比如三个孩子都在学象棋,每个人参加的比赛不一定全部相同,有的比赛全参加了,有的只有两个人参加等.现在想把三人的成绩用EXCELL画在一张折线图上以利对比.关键是参加比赛的时间不一样,除了手工一项一项列表之外,有没有更简单的操作方法.
附件是一个简单示从例以辅助说明问题,事实情况上,会有几十人参加,少的四十场比赛,多的可能会有一百场比赛,手工做极其繁琐.
第二、四、六列是每场比赛后的成绩
我发在ExcellHome中了个把月也没有人能够解答

Liu Qian is really an ___ magician.A.great B.famous C.excellent D.popular

EXCELL中如何将A列起始时间和B列结束时间的时间段分别计算到每个时间段中.
比如：x05
开车时间x05停车时间x05 峰期x05 平期x05 谷期
x05x0519:00-23:00 x0511:00-19:00x0519:-07:00
7:00-11:00
13:35:00 x0521:10:00x05x05x05
23:10:00 08:25:00
12:00 18:00
根据前面时间段对应后面的峰、平、谷期分别计算到相应的时期内,
如入开始时间是12:00,结束时间是18:00,就把它计算在平期那个单元格中.
比如13:35是平期,21:10又是谷期,这个时间段有个跨越.

求海伦公式的excell或WPS电子表格的公式模板,用于计算不规则的小块土地面积
亲戚买了一台农业机械,让我帮忙买一个激光测距仪（GPS的那种个人感觉很不准）,但是不规则面积功能,分成三角形上只能使用勾股定律,局限性不好.我想可以把不规则的多边形分成多个三角形来算面积,比较方便的就是测量三角形的三条边,为方便用海伦公式快速计算,所以求助工具

公式,最好可以加上平方米换算为亩的单位