Basic Formulas in Calc.mp4 скачать в хорошем качестве

Basic Formulas in Calc.mp4

http://openofficevideo.com How to use formulas in Calc, beginners example Welcome to OpenOffice video. I am Maarten and today I am going to show you how to use formulas in Calc. We have here an empty spreadsheet and just to have something to work with, I am just going to enter a bit of data. 1,2,3,4,5,6,7,8,9,10. This goes very rapidly because every time I am finished with entering data I hit enter and the input line automatically shifts to the cell below. Now let's say we want to analyze this data set. We can do this in a number of ways. We can say, OK, I want the sum from the first one until the last one and that's it, so I close it. See how I entered this data, I just typed it in this time. But I can also use the mouse, I can type in sum, open bracket, I can now drag the cells I want to be summed, I just let go of the left mouse button and then I end the formula with closing bracket and press enter. There it is. You see this gives exactly the same result. It is also possible to make a sum of two different sets of data, let's say we enter an empty row here, we type in data, if we create a sum now of this area, you see how it inputs the data set. It has A2 cell reference until A6. What we can do is, we can type in that we want more and add the second data set and then we end the formula with a closing bracket, and there we have it. Another formula you will use often is "Average". Most of these formulas are pretty straightforward -you can just say I want the average of this -you can just type it in and it will show the syntax. Syntax is the term for the way it wants to insert the input. We get the average of the cells A8 until A12 and that is 8 since these values go 1 up each time. It is pretty logical that average is the middle value. Now let's have a look at what else we can use in OpenOffice. You click here on the Function wizard, there is a whole bunch of these-you can just scroll down, there is more and more and more. Now most of these formulas, you will never use unless you are a statistics professor. Nevertheless there are a lot of functions that are very useful. We have mathematical formulas, we have date and time formulas, finanical formulas, and usually the formula you want is somewhere in Calc. Alright, that was for the introduction to Formulas. I hope you find this useful. If you have any questions, or comments, please leave them in the comments. Until next time. Bye.