Kinds of Functions Used in Excel. Microsoft's Excel program, widely used in business, comes with many built-in functions that perform mathematical and logical operations on spreadsheet data.

Excel will calculate the PMT. The value will have a negative sign before it to indicate cash outflow. Step 4: In this example, the function will return a value of 11365.44.