1. Hold down the left mouse button and drag directly. The sum of data can be displayed in the border below the worksheet. If you want to switch to average, you can click the right mouse button under the table box and select average. When you pull a number in this way, the average value is displayed.

Of course, with so much data, it is impossible to drag it by hand. So we found the formula.

Now it is necessary to understand that the formula calculation uses position calculation. If any cell involved in the operation changes, the result will also change. Sometimes you can't tell, but that's it.

Let's enter the = sign first, and then choose the location. Because it is a sum, it is an addition between positions. Just press enter at last.

3. To average, you can directly divide the calculated sum by 7. Is it convenient, and if you change the score of one of the courses, the total score and average score will also change, which is completely intelligent.

4. Select these two cells and drop them down. Don't copy the format, find all the sums and averages at once. Is it convenient? You can set the average value in the cell format to keep 1 decimal places or integers. Now let's see if it's convenient.