Question

how many types of built in functions does Excel have write the use of each type of function

Answer 1

I don't know if I'm allowed to send you to other websites for reference but it is not possible for me to answer about all the excel functions here.

You can follow this official Microsoft documentation that lists all the Excel functions :-

https://support.office.com/en-us/article/excel-functions-alphabetical-b3944572-255d-4efb-bb96-c6d90033e188

Answer 2

excel provide a huge no. of functions some are :-

1) Text Functions :-

a) Functions to Remove Extra Characters
like from this function it will remove printable chatracter or duplicate space
b) Functions to Convert Between Upper & Lower Case
c) Functions to Convert Excel Data Types
d) Replacing / Substituting Parts of a Text String
... etc

2) Logical Functions

a) Boolean Operator Functions
b) Functions Returning Constant Values
c) Conditional Functions

3) information function

a) Error Information Functions
b) Numerical Information Functions
c) Function Returning a Constant Value
d) General Information Functions

4) Excel Date and Time Functions

a) Creating Dates & Times
b) Current Date & Time
c)Extracting The Components of a Time
d) Performing Calculations with Dates

☆☆ :)