Using Functions in Tables in iWork

Video Transcript

"Hey everybody! My name is Matt and I'm speaking to you on behalf of Expert Village. You can of course, add functions to your tables. I'm going to come down here and select an empty cell, which is A8. If I come up to the functions button here at the top, I can select a simple function. I'm going to just choose sum, and that's going to give me the sum of all the cells above A8. You can see the affected cells turn blue. If I come down here and select a cell, after putting a function there, I can manually input a formula. I'm going to change the A2 to an A4. As you can see, now only A4 through A7 are affected. Those are the only ones that turn blue and that's going to give me the sum of just A4 through A7 now. Another cool thing. I'm just going to select A3 through A6. If you come down here in the bottom left, you can see it says sum average, minimum and maximum account. That's going to give me all this information for the cells that I selected. If you don't want to come in and program a function or put a function into a cell. You can just select the cells that you want. I'm going to select cell A9. If I come up to function and come down to more functions, that's going to give me the insert function window. From here, I can look up functions and just automatically insert them into my formula. Over on the left they're categorized. As you can see, that adds it down here. Functions can get rather complex and they're beyond the scope of this tutorial. If you're familiar with spreadsheets, you should be right at home."