Home >Topics >excel >How to calculate the average of a column of data in excel

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

王林
王林Original
2020-03-10 17:04:2616992browse

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

1. Open excel and enter some data.

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

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

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

(Recommended learning: CSS introductory tutorial)

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

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

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

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

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

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

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!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn