How to find the average in a table

How to find the average in a table?

Method steps for calculating the average in a table:

First we open the score table that requires the average, and calculate the average for each user based on this data

Position the mouse to the cell where you want to calculate the average

Click the "Insert Function" button

Excel average formula, the "Insert Function" interface pops up, select the category "Statistics", select the function "AVERAGE", and click the OK button;

Use the left mouse button to drag and select the cells for which the average value is required, and then press the OK button

In this way we will get the "average score" of the user

Place the cursor in the lower right corner of the average score cell, hold down the left mouse button, and drag it to the last user's "average score" cell. Release the left button, and all the average scores are calculated!

For more Excel-related technical articles, please visit the Excel Basic Tutorial column!

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