What is Entering Functions in excel

Entering Functions 

You can enter functions manually if you know the function name and what data to supply for the arguments in a function. In most cases, you will probably type only simple functions that require one argument, such as a range of data. For more complex functions that require multiple arguments, you can use the Paste Function. 

Try This 

1. Select the cell where you want the function to appear, and type an equal sign (=) to start the function.  

2. Type the function name (such as AVERAGE) and a left parenthesis. 

3. Select the range of cells for the argument and press Enter on the keyboard. Excel automatically adds the closing parenthesis and enters the functioN.

Inserting with the Paste Function

The Paste Function displays a list of functions from which you can choose the function you want, based on a description that appears when you select a function. The Paste Function also assists you in building the function and explains the purpose of each argument. Use the Paste Function if you want to enter a complex function that requires multiple arguments or if you are unsure of the syntax required for a specific function.

Try This

1. Select the cell where you want to enter the function; then click the fx button on the Formula Bar

 

2. Select the type of function you want from the Category list. If you are unsure of the category, select Most Recently Used or All.

3. Select the specific function that you want from the function name list box. Read the description in the lower part of the dialog box to verify that this is the function you want; then click OK..

4. A pop-up window, called Function Arguments appears under the formula bar. Enter the arguments in each argument text box. You can type the cell references or numbers, click directly on the cell you wish to reference, or highlight multiple cells to reference a group.  

 5. Click OK to complete the function and insert it in the cell.