How to automatically calculate average in Excel

Here is a score sheet with the scores for each subject. The average score is required.

① Position the cursor in the cell below [Average Score], and then click the [Insert Function] button, as shown in the red area in the picture.

②In the pop-up [Insert Function], we select the function [AVERAGE], and then click OK.

③The [Function Parameters] window will pop up immediately. At this time, we can use the left mouse button to drag and select the cells that need to be averaged, or we can hold down the key on the keyboard. [Ctrl + left mouse button] to select multiple cells, and then press OK.

At this time, the average value is automatically displayed in the cell below [Average Score].

Okay, the average has been calculated, so our current question is how to automatically display the average score of each student in the average cell.

We only need to place the cursor at the lower right of the average score cell of the first student. At this time, the mouse will turn into a [black cross], hold down the left mouse button, and then move the mouse Drag it to the cell of the last student's [Average Score], release the left button, OK, so all the average scores of the students are calculated.

The above is the detailed content of How to automatically calculate average in Excel. For more information, please follow other related articles on the PHP Chinese website!