Home >Topics >excel >How to calculate the table average

How to calculate the table average

藏色散人
藏色散人Original
2021-05-27 15:02:4441977browse

How to calculate the average of the table: First open an Excel file; then enter the averaging function "AVERAGE" in cell A6; then enter the range of the average in the function formula; finally press the enter key You can calculate the average of the data in column A.

How to calculate the table average

The operating environment of this article: Windows7 system, DELL G3 computer, Microsoft Office Excel2010

How to calculate the average value of the table?

As shown in the figure, we need to calculate the average of the data in column A;

How to calculate the table average

Enter the average function in cell A6. The AVERAGE function is Calculate the average function in the EXCEL table;

How to calculate the table average

Enter the average range in the function formula, that is, A1:A5, and then press the enter key to calculate column A. The average value of the data.

How to calculate the table average

Recommended study: "Excel Tutorial"

The above is the detailed content of How to calculate the table average. 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