 So now in Excel what we're dealing with is this idea of functions and you might remember this symbol from math class This f of x very very daunting and you might remember its counterparts say for example G of x and h of x scary Well, what do they mean again? This f this f right here this refers to what's known as my function name and And that's just my way of referring to this particular function instead of it being f or g They're all unique to each other and they all have different tasks. This guy right here This is known as my parameters because again, I might want to do something like f of four Now what happens when I do f of four, you know, it's whatever it's designed But say for example f was that I take whatever my parameter was and I add two to it So f 10 for example would be 12 Again, that doesn't sound pretty useful in special use since we're dealing with Excel and in Excel We still see the same structure, but we see it in more practical Form we see something like the Sum function and the sum function. That's my function name right there and then I have the parentheses Have these to indicate where my parameter starts and where my parameter ends So now again, if I were to type in say a one colon a for What this is referred to? Right here is what is known as a cell Range And again, it just means that I'm gonna take this parameter this a one to a four Take all the numbers that are inside of those cells and add them together So let's actually kind of put that into a more practical Application side of things. Let's say for example, I have five six seven eight inside of a one to a four Now again, if we take a look at that formula Sum a one to a four now the first thing I have to do is I have to start with the equal sign Equal sign again in Excel is telling Excel this stuff that I'm about to type in This is something I need you to evaluate. I need you to calculate this out And as I start to type this out, you see that Excel already has a auto complete function for me So I can start to take this and as you can imagine If I put in my parentheses, I can start to go a one a One Colon a for notice it highlights it all for me as soon as I close my parentheses and I hit enter What I get is 26 If I change any one of these numbers It will change it as well And so we have a few of those as you can imagine again if I hit equals and this time I go a V notice what happens I get a Aid a V dev a average average a average if average ifs. Well, just click on average Again, you can see it gives me a little brief description returns the average arithmetic mean of its operators Well, again, I said that this was like auto complete So what that means is I can double click on this and it's gonna automatically put the rest out there for me Which is really nice. Now what I can actually do is I can click hold and drag a one to A4 and that's gonna display or it's gonna highlight all of them And if I close out my parentheses, I can now find out the average of all of these