2009年8月19日星期三
在openoffice的calc中使用函数sum()
1. To enter a sum function first double click on the cell where you want to put the formula.
2. Next, start the formula by typing in the equal (=) sign.
3. then, to start the sum function type in the word "sum"
4. A tooltip like this may appear. It should guide you on the proper format of the function you are typing.
5. After the word "sum" type in the open parenthesis character. This should indicate that we are ready to enter the values or cell references.
6. Now, we will select the values that will be added.
7. To do this click and hold the left mouse button on one of the cells that you want for the sum function.
8. Now, move your mouse through the other cells you want added. Notice that a red outline covers them to guide you on which cells are selected.
9. Once you have selected all the cells you need, just release the mouse button.
10. Great! Notice that the formula has automatically typed in the cell references you selected.
11. Finally, type in a close parenthesis to finish the formula. Just press enter after.
12. Good! The formula has now added the values of the cells. You can see the result here.
13. Now, if you click once on the cell again...
14. ...you will see the formula we made is now in the formula bar.
15. Congratulations! You have learned how to enter the sum function.
2. Next, start the formula by typing in the equal (=) sign.
3. then, to start the sum function type in the word "sum"
4. A tooltip like this may appear. It should guide you on the proper format of the function you are typing.
5. After the word "sum" type in the open parenthesis character. This should indicate that we are ready to enter the values or cell references.
6. Now, we will select the values that will be added.
7. To do this click and hold the left mouse button on one of the cells that you want for the sum function.
8. Now, move your mouse through the other cells you want added. Notice that a red outline covers them to guide you on which cells are selected.
9. Once you have selected all the cells you need, just release the mouse button.
10. Great! Notice that the formula has automatically typed in the cell references you selected.
11. Finally, type in a close parenthesis to finish the formula. Just press enter after.
12. Good! The formula has now added the values of the cells. You can see the result here.
13. Now, if you click once on the cell again...
14. ...you will see the formula we made is now in the formula bar.
15. Congratulations! You have learned how to enter the sum function.
// 发贴者：放牛娃的春天 @ 八月 19, 2009 
订阅 博文 [Atom]