Some of the most used formulas in Excel are: SUM; sum any number of columns or rows. COUNT: counts the number of cells in an array. AVERAGE: takes the average of the input numbers. CONCATENATE: to combine data into one cell. MAX & MIN function.