Enter function
You can enter functions directly into a cell or formula bar, or you can use the function insertion panel.
Enter a function directly into a cell or formula bar
1.Select the cell where you want to enter the function.
2.In the formula bar or cell, type the = sign.
3.Start typing the name of the function. A list of prompts will appear. Most function names should be entered in a language that matches the language of your computer system (for example, SUM). Exceptions are mathematical and trigonometric functions (e.g. SIN, LOG, EXP), which are always entered in Latin letters.
4.Select the desired function from the list.
5.Enter the arguments of the function in parentheses.
6.Press Enter to complete the entry.
Enter a function through the function insertion panel
1.Select the cell where you want to enter the function.
2.Open the function insertion panel using one of the methods:
•On the Insert tab, click the Function button.
•Click the 
Insert Function button in the formula bar or sidebar.
3.In the search bar in the panel, start typing the name of the function.
4.Select the desired function from the list.
5.Click the Insert button or press the Enter key to insert the selected function into the cell.
6.If needed, read the function's quick reference by clicking 
.
7.Enter the arguments of the function.
8.Press Enter to complete the entry.
Autosum
The Autosum operation allows you to quickly apply one of five popular functions: SUM, MIN, MAX, AVERAGE, COUNT. The system automatically recognizes the range of cells with numeric data and substitutes it into the function. Select the data to be calculated –To calculate the sum for a column, select an empty cell below it. The result will be pasted into that cell. –To calculate the sum for a row, select the empty cell to its right. –Select a column, row, or range of cells in its entirety. The result will be pasted into the nearest empty cell next to the range. Perform autosum 1.Select a cell, column, row, or range of cells with data. 2.Invoke the Autosum operation in one of the following ways: •On the Data tab, click the Autosum button. •Click the •Press the Alt+= (Option+=) keyboard shortcut. Autosum features –When you invoke an operation by pressing the –Only visible cells of the selected range are involved in the calculation. –The maximum number of arguments when using Autosum is 255. |
