Microsoft excel functions
A function is an inbuilt formula.
This command is used in ms excel to insert formulas for calculation or analysis. It also has a shortcut on the standard toolbar.
A formula always starts with an equal sign is (=).
This signs tells excel that the succeeding value comprises of a formula.
Excel calculates a formula from the left to right according to a specific order from each operater.
We have these functions categories in ms Excel:
1.Financial
2.Date and time
3.Mathematical
4.Stastiscal.
5.look up and reference
6.Database
7.Text
8.Logical
9.Information
Procedure for inserting a function
Click on insert.
Click on function.
Click OK.
Choose the appropriate function from the dialog box.
Click OK
Indicate the range.
0 comments