Excel精英培训网

 找回密码
 注册

[原创] 学Excel,会English-20110112

热度 3已有 1187 次阅读2011-1-12 14:22 |个人分类:原创|

Pick up english by learnig Excel!
All materials are selected from authentic English Excel books!
Ten useful expresssions in daily course!
(中文部分是参考英文翻译过来的,如有不妥之处,烦请回帖斧正)

--------------------------------------------

1. I’m surprised to find that many experienced Excel users don’t take advantage of the AutoFill feature, which can save a lot of time.

我很惊奇很多Excel老用户都不会利用自动填充功能,其实它可以节省很多时间

2. Potential problems that may crop up when you use names.

当你使用名称时就可以出现各种潜在的问题。

 

3. By using a naming convention, your names will tell you more about themselves. For instance, you could prefix all your workbook-level names with wb and your worksheet-level names with ws. With this method, you’ll never confuse wbTotal with wsTotal.

对于名称的命名而言,你的名字应该更加容易辨别,例如你可以再工作薄级名称前加上wb以及在工作表级名称前加上ws,这样你就不会混淆wbTotalwsTotal这两个名称了。

 

4. Here’s the secret to understanding names: When you create a name, you’re actually creating a named formula. Unlike a normal formula, a named formula doesn’t exist in a cell. Rather, it exists in Excel’s memory.

这是对名称理解的即一个秘密,当你创建一个名称的时候,实际上你是创建了一个命名的公式,不同于常见的公式,命名的公式在单元格中不存在,事实上,他存在于Excel的内存中。

 

5. After you select the desired function, press Tab to insert the function

and its opening parenthesis into the cell.

当你选择想要的函数后,按Tab键就可以输入函数并且自动帮你是输入了左括号。

 

6. If you omit the closing parenthesis for a function, Excel adds it for you automatically. For example, if you type =SUM(A1:C12 and press Enter, Excel corrects the formula by adding the right parenthesis.

如果你忘记输入函数的右括号,Excel会自动帮你添加上右括号,例如,如果你输入=SUM(A1:C12 然后按回车键,Excel会自动为公式添加上右括号。

 

7. You may hear the term string used instead of text. You can use these terms interchangeably. Sometimes, they even appear together, as in text string.

你或许听到的是字符串而不是文本,这两个其实可以互换的,通常他们出现在一起,比如字符串文本。

 

8. I certainly don’t recommend using a cell in lieu of a word processor, but you really don’t have to lose much sleep worrying about filling up a cell with text.

当然我不推荐用单元格代替文字处理器,实际上你也不必为此失眠去担如何在单元格中填充文本。

 

9 Excel also has a CONCATENATE function, which takes up to 255 arguments. This function simply combines the arguments into a single string. You can use this function if you like, but using the & operator is usually simpler.

Excel中有Concatenate函数,这个函数可以有255个参数,它的作用就是将单个字符串连在一起,你可以使用这个函数,但是直接用 & 会更加简单。

 

10. If you want to find an actual question mark or asterisk character, type a tilde (~) before the question mark or asterisk.

查找函数search如果查找的是问号或者星号,在问号或星号前加上~

刚表态过的朋友 (0 人)

评论 (0 个评论)

小黑屋|手机版|Archiver|Excel精英培训 ( 豫ICP备11015029号 )

GMT+8, 2024-3-29 16:46 , Processed in 0.349785 second(s), 8 queries , Gzip On, Yac On.

Powered by Discuz! X3.4

Copyright © 2001-2020, Tencent Cloud.

返回顶部