How to calculate spreadsheet average

Calculation method: First open the excel table, select the specified cell; then click "fx" on the "Edit Bar", select the "average" function in the pop-up window; then enter the "Value 1" input box Enter the parameters that need to be calculated as the average; finally click the "OK" button.

The operating environment of this tutorial: windows7 system, WPS Office2019 version, Dell G3 computer.

Click to open the EXcel spreadsheet file on the desktop, and determine the cell position where the average value is located, that is, move the cursor to the cell where you want to calculate the average value.

Click the Insert Function button above the edit bar, which is the fx button.

At this time, a dialog box appears. If it is displayed on the AVERAGE function, it will be just right. This is to calculate the average. Just press the OK button.

#A dialog box for function parameters will appear, which is the numerical range for calculating the average. Just click the OK button.

At this time, the average value will appear in the cell you specified at the beginning.

Related learning recommendations: excel tutorial

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