| Complete List | - | Database - These are used to analyse, count, add and filter data stored in lists or databases. |
| Complete List | - | Date and Time - These are used for entering and calculating dates and times. |
| Complete List | - | Engineering - These are used to handle complex numbers, conversions and measurements. |
| Complete List | - | External - These are used to retrieve data from external sources. |
| Complete List | - | Financial - These are used for depreciation, accrued interest, annuities, rates of return and future values. |
| Complete List | - | Information - These are used to identify the contents of cells and determine any errors or blanks. |
| Complete List | - | Logical - These are used to perform conditional analysis and apply logical conjectures to your data. |
| Complete List | - | Lookup and Reference - These are used to locate references and specific values within tables of data. |
| Complete List | - | Maths and Trigonometry - These are used for rounding, ranking, analysing trends and to calculate probabilities and logarithms. |
| Complete List | - | Statistical - These are used for standard deviation, distributions, square roots, average, median. |
| Complete List | - | Text - These are used for entering, searching, replacing and manipulating text strings. |