It is important to learn and know about excel formulas, if we take no interest in excel formulas. So, it is unusable for us, in this excel online article we will learn some basic formulas. Excel is a form of spreadsheet. If we entered the data in a tabular form so this is known to be spreadsheet. In Microsoft Excel, there is some formulas which are predefined called functions, means Microsoft programmed the formulas, so we only call it and enter the values in it in a predefined manner, if we not use this predefined manner, so we will face the error. It is very important to use the formulas in excel, to use the functions must type equals to sign (=) before starts the formula. Lets star the some basic functions.

__Sum Formula:__

This function of sum will sum all values that will select.

Example:

=sum(number1, number2,.....) ; general format

=sum(A1:A10) ; column wise format

=sum(a1:z1); row wise format

__Average Formula__

__Count Formula:__

__Counta Formula:__

__Countblank Formula:__

__ountblank__(value1, value2,...)

__Min Formula:__

__Max Formula:__