In this blog, We have discussed the different functions of Excel and many more...

What is Functions?
  • A function is a predefined formula that performs calculations using specific values in a particular order. 
  • Functions can be used to perform simple or complex calculations.
  • Excel includes many common functions that can be used to quickly find the sum, average, count, maximum value, and minimum value for a range of cells.
There are different types of functions. detailed description below

Date-Time Functions
Date-Time Functions

Mathematical Functions
Mathematical Functions

Mathematical Functions

Statistical Functions
Statistical Functions
Database Functions
Database Functions

for example, Add below criteria from the above database
IP1           (that means second column)
>60

Financial Functions

Financial Functions

Remarks of database functions

1 FV(D7, D4, D5) FV menans future value 

2 NPER(D7, D5, D6) NPER means a number of periods for an investment based on periodic 

3 PMT(J5, 12, J4) PMT means Returns the periodic payment for an annuity with constant interest rates 

4 PV(J5, 12, D5) PV means Returns the present value of an investment 

5 RATE(12, D5, D6) Rate means Returns the constant interest rate per period of an annuity


Here, the output shows the value of 100000 rs. and the rate is 5% in excel worksheet.
------------------------------------------------------------------------------------------------------------

How does the IF() function in Excel work?

In Excel, the IF() function performs a logical test. It returns a value if the test evaluates to true and another value if the test result is false. It returns the value depending on whether the condition is valid for the entire selected range. 

How do we use the SUMIF() function in Excel?

The SUMIF() function adds the cell values specified by a given condition or criteria. Given below is an example of the sumif function.

How do you freeze panes in Excel?

Freeze panes keep the rows and columns visible while scrolling through a worksheet. To freeze panes, select the View tab and go to Freeze Panes.

For example: If you are looking to freeze the first two columns of a dataset, select the 3rd column, and click ‘Freeze Panes’. 

How do you create a hyperlink in Excel?

Hyperlinks are used to navigate between worksheets and files/websites. 

To create a hyperlink, the shortcut used is Ctrl+K.

How can we merge multiple cells text strings in a cell?

To merge text strings present in multiple cells into one cell, you can use the CONCATENATE(). Shown below is an example of the concatenate function. 

For example:  =concatenate( "a1", " ", "b1")

How can you split a column into 2 or more columns?

You can split a column into 2 or more columns by following the below steps:

1. Select the cell that you want to split. Then, navigate to the Data tab, after that, select Text to Columns.

2. Select the delimiter.

3. Choose the column data format and select the destination you want to display the split.


4. The final output will look like below where the text is split into multiple columns.

For example:  write Sunil Patel in first column first row
then used this functions name display in two column  like

Sunil in first column
Patel in second column

How many report formats are available in Excel?

There are three report formats available in Excel; they are:

  1. Compact Form
  2. Outline Form
  3. Tabular Form
--------------------------------------------------------------------------------------------------------------------------
Or follow my blog from the below link


Also, Join my Telegram channel with the below link

Also, join my Whatsapp group with the below link