Lesson 5 - Function

Parts of Function?

Now after knowing function, next we will learn how to use them. Inserting a function is very easy, because it’s a predefined so you just need to apply them as per requirement. Before inserting a function in a worksheet first learn about parts of function.

A function has a 3 parts –

• Function name –

A name of function which you are going to define instead of mathematical operation, like SUM, SUB, AVERAGE etc.



• Arguments –

Cell address or cell range which relation you need to calculate, like (A1, AA1, CCC3 etc.).



• Parentheses –

Parentheses is a bracket () to enclose the arguments separated with commas.




So on adding these three parts you will get a function like –

• SUM(A1,A2,A3) or SUM(A1:A10)

First function add the value of cell address A1, A2 and A3. Commas separate the cell address and helps to get a results. But when you need to add more than 3 or 4 cells then it’s a long method to type every cells address and separated it with comma.
Here “:” colon will help when you need to mention a cell range like in second function.

Similarly, you can applying more function in your worksheet like –
AVERAGE(), MAX(), MIN(), SUB(), MEDIAN() etc.

Next Lesson