What is Excel

All about Excel

What is excel > History > Functions > Macros > Extensions > Errors > Easter eggs

Excel functions

What are Excel functions?

Excel functions are defined as the set of formulas that incorporates the Excel application that has the objective to do predefined calculations with providing only the values to want calculate.

To understand more clear the concept Excel functions and formulas we will see the following example:

Suppose we want to calculate the highest power of 3 to 10, so we have two options:

Multiply in our spreadsheet 10 times the number 3, so that the cell in which we get the result we should write = 3 * 3 * 3 * 3 * 3 * 3 * 3 * 3 * 3 * 3

Use the "POWER" function which is incorporated on the Excel application, so that the cell in which we get the result we should write POWER (3, 10)

Comparing both options, the second method gives us the desired value in the shortest possible time and without mistakes, imagine that we now know the value of 2.56783 raised to 150, probably the first option would take a long time to enter all the information, besides running the risk of making mistakes when you type, however the second option should only write the following Excel function POWER (2.56783, 150), we have written just in 2 seconds and immediately the excel function have obtained the correct and reliable result.

Thanks to the Excel functions we can perform complex calculations without entering complex formulas and we can be misleading.

The functions which incorporate the excel application is classified into the following categories: