Question

What is a Function? Write down the steps to create a basic Function in Excel.

Answer 1

To create a basic function in Excel:

Select the cell where the answer will appear (F15, for example).

Type the equals sign (=), then enter the function name (SUM, for example). Creating a SUM function.

Enter the cells for the argument inside the parentheses. ...

Press Enter, and the result will appear.

Answer 2

Functions are predefined formulas and they are already incorporated in excel.

You need to perform the function in order to put any formula.

Select the function, insert the function button, choose from the drop down menu, and insert the function you want.

Then click ok and you will get the desired result.