Using the Function button

You can enter any of the standard functions directly into the formula bar using the keyboard, however you can select a function for applying to a cell, or a series of cells, very quickly by using the Function button, which is located in the toolbar.

282
To specify a function, select the cell where you wish the result to be shown. Then press the Function button in the toolbar.

For certain functions that apply to ranges of cells, Office2 will try to intelligently select the range of cells that it thinks you wish to apply the function to. If this selection is correct, press the Done button on the keyboard. If it is not correct, tap on the formula bar and manually change the cell range that you wish to associate with the function and press the Done key.

Some other functions require you to enter parameters. If you use the Function button to enter these functions, Office2 will enter placeholders for the parameters, which you can then replace with actual parameter values.

For a list of available functions, click here.

 ?