| ADDRESS | The cell reference given a row and column number. |
| AREAS | The number of areas in a cell range or reference. |
| CHOOSE | The value from a list of values, based on an index number. |
| COLUMN | The column number of the cell reference. |
| COLUMNS | The number of columns in a cell range or reference. |
| GETPIVOTDATA | The data obtained from a pivot table. |
| HLOOKUP | The value in a row that matches a value in the top row of a table. |
| HYPERLINK | The hyperlink linked to a cell, document or webpage. |
| INDEX | The value from a table, based on an index number. |
| INDIRECT | The text string of the contents of a given cell reference. |
| LOOKUP | The value in a row (or column) that matches a value in a column (or row). |
| MATCH | The position of a value in an array or list. |
| OFFSET | The cell value which is an offset from a given cell reference. |
| ROW | The row number of the cell reference. |
| ROWS | The number of rows in a cell range or reference. |
| RTD | The real time data from a program that supports COM. |
| TRANSPOSE | The array with its orientation changed. |
| VLOOKUP | The value in a column that matches a value in the first column of a table. |
