:Tutorial for beginners in tables. Quick function to find the average and maximum value.-Table skills免费ppt模版下载-道格办公
投稿
  1. JustNewsHome
  2. Table skills
  3. Tutorial for beginners in tables. Quick function to find the average and maximum value.

Tutorial for beginners in tables. Quick function to find the average and maximum value.

Author: daogeziyuan • • Table skills • Views 728
  • Picture and text skills


Average and maximum values ​​are widely used in our daily life and work. How to calculate them quickly in a table?

 

图文对齐图.png


Use the AVERAGE function to quickly find the average of a set of data.


￭ Enter =AVERAGE(), select the data area, and the calculation is completed!

Click Start-Sum Collapse Box-Average in the menu bar to quickly calculate the value.

 

录制_2019_09_10_18_26_39_457.gif


How to calculate the maximum value?

￭ The maximum value uses the MAX function, and the minimum value uses the MIN function.

For example, to find the maximum value, enter =MAX(), select the data, and find it in one second.

You can also quickly find the maximum and minimum values ​​in the sum collapse box.

 

录制_2019_09_10_18_28_05_298.gif


MIN function is used similarly to MAX.

 

录制_2019_09_10_18_28_39_626.gif


These commonly used functions are very practical, so take note of them!



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/biao-ge-xin-shou-jiao-cheng-han-shu-kuai-su-qiu-ping-jun-shu-zui-zhi.html

Like (810)
Reward 支付宝扫一扫 支付宝扫一扫
Lomu FansClub Columnist
48 196
single-end

Related Suggestion