The basic Excel formulas are SUM: Gives the total of the selected cell values, AVERAGE: Calculates the average of the selected cell values, COUNT: Counts the total number of cells containing a numeric value, SUBTOTAL: Gives the subtotal in a database. It can return average, sum, count, sum, max, min, and others per your choice, MODULUS: Returns the remainder when a number is divided by a divisor, POWER: Returns the result of a number carrying an exponent/power and CEILING: Rounds a number to its nearest significant multiple.