- < li class="tab-item active" style="width:114px;">Picture and text skills
In daily life and work, average and maximum values are widely used. How to quickly perform these calculations in spreadsheet software?
To calculate the average of a set of data, you can use the AVERAGE function. Just enter the formula "=AVERAGE (selected data range)" and you'll get the result.
In addition, you can also click "Start" - "Sum" - "Collapse Box" - "Average" through the menu bar of the software to quickly get the average.
To calculate the maximum or minimum value of a set of data, you can use the MAX or MIN function. For example, when calculating the maximum value, just enter "=MAX (selected data range)" and the result will be available in one second.
Similarly, the maximum and minimum values can also be quickly calculated through "Sum" - "Collapse Box".
The use of the MIN function is similar to the MAX function. By selecting the corresponding function, you can easily find the minimum value of the data.
These functions are very practical in daily work and are recommended to be mastered.
Articles are uploaded by users and are for non-commercial browsing only. Posted by: Lomu, please indicate the source: https://www.daogebangong.com/en/articles/detail/shu-ju-ru-men-qing-song-zhang-wo-Excel-de-jun-zhi-yu-ji-zhi-ji-suan-ji-qiao.html
评论列表(196条)
测试