MS excel Functions

Studying different kinds of programs like
Ms-excel is a part on learning the
fundamentals of being an IT student. For
 me I hate excel because, when our
instructor taught us on how to use excel,
 Im absent that time so Ive`d miss the
discussion and the result.?...I did not
learned mush more in excel. But i would
like to share this info related on excel
functions.

Microsoft Excel - is primarily a spreadsheet program for making sense out of numbers.

Excel functions:

1. Average - get the average of the array of numbers.
2. Min - displaying the smallest number in an array of elements.
3. Max - "           "             "           "            "          "        "
4. If function - ex.=if(A1<75,"true","false")  /  syntax.=if(logical test,true,false)
5. Sum If function - ex.=sumif(E1:E6,"=165",F1;F6)  /  syntax.=sumif(range,criteria, sum range)
6. Sqrt function - display the square root of a number.  /  ex.=sqrt(A10)
7. Count function - count the total element within the range.  /  ex.=count(A1:A6)
8. Countif function - ex.=countif(E1:E6,165)  /  syntax.=countif(range,criteria)
9. Median - display the middle element in an array.
10. Hyperlink - syntax.=hyperlink(link_location,name).

NOTE: If some part of this blog entry related to MS word have a wrong parts..you can leave a comment or email me to clarify and change it.