The 5 basic Excel formulas are SUM, AVERAGE, MAX, MIN, and COUNT. The SUM formula is used to add up numbers, AVERAGE to find the average of a range of numbers, MAX and MIN to find the largest and smallest numbers in a range, and COUNT to count the number of cells that contain data in a range.