EXCEL formula is an equation used for numerical calculation in EXCEL worksheet. Formula input starts with "=". Simple formulas include addition, subtraction, multiplication and division.

The usage method is as follows:

Calculate the average value.

In the average column: = (C7+D7+E7+F7+G7+H7)/6;

Press Enter to calculate the average score of the first one;

Similarly, we use the auto-fill function, position the mouse in the lower right corner of the cell, and drop down to calculate the average score below;