Microsoft Excel – Inserting Function

Course - Fun With Excel

Inserting Function?

To use function you can directly applying it to your desired cells in a worksheet or you can insert it via help of function library. Follow these simple steps to insert function from libraries.

• Select the cell to insert the function on it.
• Go to the Formula tab and click on it.
• Here you will see a Function library section.
• Under this section you will see a function are categorized in a group.
• On click on drop down menu a list of function will open you can select any of your choice.

Function Categories –

There are lot many inbuilt or predefined function in an Excel. So it’s a good example to categorized them all in a group. So similar function are grouping under same group like, Financial function – Group of function which helps us to add the financial function. For example –

• ACCRINT
• ACCRINTM
• DURATOIN
• DSC etc.

Group of function which helps us to add some logical function. For example –

• AND
• FALSE
• IF
• OR
• NOT etc.

Group of function which helps us to add the time function. For example –

• DAYS
• DATE
• HOUR
• MINUTE
• SECOND
• MONTH
• NOW etc.

Group of function which helps us to add the mathematical operation and Trigonometry function. For example –

• SUM
• SUMIF
• ODD
• EVEN
• SUBTOTAL
• PRODUCT etc.

Group of function which helps us to add the reference function. For example –

• ADDRESS
• ROW
• COLUMN
• HYPERLINK
• VLOOKUP

Group of function which helps us add the mostly used function in worksheet.