Information and Communication Technology

5.4.39 Functions

Functions are typed in a cell in following format=Function name(argument) Argument may be in any one of the following format.

1. Numeric value
2. Cell address
3. Range ( Starting cell address : Ending cell address)
4. Range name
5. Cell addresses (Address1, address2, .....)

Functions are classified into several functions such as

1. Math & Trig function
2. Text function
3. Logical function
4. Statistics function
5. Lookup and reference function
6. Date & Time function
7. Financial function
8. Information function
9. Data base function