| Mathematical Functions | ABS, SQRT, RAND, | Basic Operations |
| TRUNC, INT, ROUND, ROUNDUP, ROUNDDOWN, | Rounding Functions | |
| SUM, SUMIF, SUMPRODUCT, SUMSQ, | Conditional Sums | |
| QUOTIENT, MOD, | Integer Division | |
| Statistical Functions | AVERAGE, RANK, FREQUENCY, | Basic Operations |
| MAX, MIN, LARGE, SMALL, | Largest & Smallest Values | |
| COUNT, COUNTIF, COUNTA, COUNTBLANK, | Counting Cells | |
| Text Functions | UPPER, LOWER, PROPER, | Converting Between Upper & Lower Case |
| CONCATENATE, LEFT, RIGHT, MID, TRIM, | Cutting Up & Piecing Together Text Strings | |
| LEN, FIND, SEARCH, EXACT, ISBLANK, | String Information Functions | |
| TEXT, VALUE, CHAR, CODE, | Data Types & Numeric Codes | |
| Date & Time Functions | DATE, NOW, | Basic Operations |
| Lookup Functions | VLOOKUP, HLOOKUP, LOOKUP, CHOOSE, | Data Lookup |
| Logical Functions | IF, AND, OR, NOT, | Conditional Functions & Boolean Operators |