How to calculate the average of a column of data in excel

1. Open excel and enter some data.

#2. Then click ‘Insert’ on the menu bar, and click ‘Function’ on the open drop-down menu.

(Recommended learning:CSS introductory tutorial)

3. A window will pop up after clicking. Enter ave here to search, and click Second in search.

#4. Enter parameters A2:A5 below to calculate the average of these cells.

#4. Press the Enter key. After the formula is confirmed, the average is obtained.

Recommended related tutorials:excel tutorial

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