How to calculate the average of a column of data in excel
- 王林Original
- 2020-03-10 17:04:2617005browse
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!
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
Previous article：How to set line spacing in excelNext article：How to set line spacing in excel