## SOME BASIC FUNCTIONS

__TABLE 1__

Roll No. |
Name |
Age |
Marks |

1 |
Akshay |
17 |
82 |

2 |
Ankur |
16 |
56 |

3 |
Vivek |
15 |
99 |

4 |
Asha |
15 |
45 |

5 |
Mukesh |
18 |
65 |

6 |
Vikas |
17 |
71 |

7 |
Utkarsh |
16 |
25 |

8 |
Ritesh |
18 |
84 |

**SUM**

It is used for performing sum operation on the data. It can take ‘n’ number of arguments in the form of numbers.

- For using any function, you need to first use “=” sign & then write sum (you will see the options coming), select it

- Now select the column you want to perform operation on. (here it is Marks)

- Press Enter & you will get the desired output

OUTPUT

**AVERAGE**

Average Function is used to calculate averages.

Steps are same to evaluate any function. It can take ‘n’ number of arguments. It is calculated as follows.

The formula is “ =AVERAGE(D2:D9) “

D2:D9 is the range of which you want to calculate average of.

**COUNT**

Count function is used to calculate no. of entries in the table. It cannot count strings and blanks.

For example, you want to calculate the number of values in TABLE 1 in column D i.e.

Marks

OUTPUT

**COUNTA**

It is used to count string as well as numeric values.

The formula is “ =COUNTA(B2:B10), B2:B10 is the selected range.

As u can see it is counting strings as well as numeric values.

Likewise, we have COUNTBLANK. It is used to count blanks.

There is one blank in column B therefore it shows 1.

__OUTPUT__

**MAX**

It is used to get the maximum value out of all the values. The formula is “ =MAX(D2:D9)”, where the range D2:D9 is the selected range and the highest value from it is 99.

**MIN**

It is used to get the minimum value out of all the values. The formula is “ =MIN(D2:D9)”, where the range D2:D9 is the selected range and the highest value from it is 25.