Microsoft Excel Some Basic Functions And Formulas For Beginners


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


Microsoft Excel Sum Function
Microsoft excel sum function

Average Formula
This function of average, will calculate the average value from the given values. This function in excel sum of all the values then divide by the total number number of values.

Example:
=average(value1, value2,...)

Microsoft Excel Average Function
Microsoft excel average function

Count Formula:
This function counts all the numeric values (only numbers) in a row or column.

Example:
=count(value1, value2,...)

Microsoft Excel Count Function
Microsoft excel count function with numeric values

Microsoft Excel Count Function
Microsoft excel count function with alphanumeric and empty values

Counta Formula:
This function counts all the alphabetic and numeric values, which means alphanumeric values in a row or column.

Example:
=counta(value1, value2,...)

Microsoft Excel Counta Function
Microsoft excel counta function
Countblank Formula:
This function counts all the empty cells between or after or before the values in a range.

Example:
=countblank(value1, value2,...)

Microsoft Excel CountBlank Function
Microsoft excel countblank function

Min Formula:
This function find the lowest value in a range.

Example:
=min(value1, value2,...)

Max Formula:
This function find the largest value in a range.

Example:
=max(value1, value2,...)
Microsoft Excel Min And Max Function
Microsoft excel min and max function

© P4Pakao. All rights reserved. Distributed by ASThemesWorld