What is a Function?

A function is a preset formula in Excel, that helps perform mathematical, statistical and logical operations. Once you are familiar with the function you want to use, all you have to do is enter an equal sign (=) in the cell, followed by the name of the function and the cell range it applies to.

Most Frequently Used Functions in Excel

The most frequently used functions in Excel are:

But there are hundreds of other preset formulas offered by Excel.