You can enter functions into your spreadhseet by either typing an equal sign (=) and the name of the function (such as =SUM) or you can click the function button ( 
) and select the desired function from a list.
| ABS | Returns the absolute value of a number |
| AVERAGE | Returns the average (mean) of a selected range of cells |
| CORREL | Returns the correlation coefficient between 2 data sets |
| COS | Returns the cosine of a number |
| FV | Returns the future value of an investment |
| INTERCEPT | Returns the intercept of the linear regression line |
| LCM | Returns the least common multiple |
| MAX | Returns the maximum value of a selected range of cells |
| MEDIAN | Returns the median of a selected range of cells |
| MIN | Returns the minimum value of a selected range of cells |
| MODE | Returns the most common value of a selected range of cells |
| NPER | Returns the number of periods for an investment |
| NPV | Returns the net present value of an investment based on a series of periodic cash flows and a discount rate |
| PMT | Returns the periodic payment for an annuity |
| PPMT | Returns the payment on the principal for an investment for a given period |
| PV | Returns the present value of an investment |
| SIN | Returns the sine of a given angle |
|
SLOPE |
Returns the slope of a linear regression line |
| SUM | Adds together a selected range of cells |
| TAN | Returns the tangent of a number |
| TREND | Returns values along a linear trend |