- SUM - SUM(range): Calculates the sum of a range of cells
- AVERAGE - AVERAGE(range): Calculates the average value of a range of cells
- COUNT - COUNT(range): Counts the number of cells in a range that contain numerical values
- MAX - MAX(range): Finds the highest value in a range of cells
- MIN - MIN(range): Finds the lowest value in a range of cells
- IF - IF(condition, valueiftrue, valueiffalse): Evaluates a condition and returns one value if it's true and another if it's false
- ROUND - ROUND(number, num_digits): Rounds a number to a specified number of digits
- VLOOKUP - VLOOKUP(lookupvalue, tablearray, colindexnum, range_lookup): Searches for a value in the first column of a table and returns a value in the same row in a specified column
- CONCATENATE - CONCATENATE(text1, text2, ...): Joins two or more text strings into one
- LEFT - LEFT(text, num_chars): Returns the leftmost characters from a text string
- RIGHT - RIGHT(text, num_chars): Returns the rightmost characters from a text string