Worksheet functions are the calculations built into Microsoft Excel for you. Each function calculates a different type of value. For example, you can use functions to calculate sums, averages, loan payments, and slopes of lines. Microsoft Excel includes hundreds of functions for financial, statistical, mathematical, trigonometric, and other types of calculations.
Using these functions saves you the time and effort of knowing, calculating, and recalculating many different mathematical equations. Functions can tell you whether a condition is true or false, whether one number is greater than another, or whether two words are exactly the same. Functions also help you to sort through data by identifying and calculating minimum, maximum, average, percentile, and rankings of values.