How to calculate tabular data in word2013

Source: Internet
Author: User
Tags min

word2013 Calculate table data steps as follows:

word2013 sum operation:

Step One: Move the cursor to the cell where the result is placed.

Step Two: Click the formulas option in the data group on the Layout tab.

Step three: In the Formula dialog box that pops up, the "Sum above data" command (SUM (ABOVE)) is the default. If this is not the command, enter the command after "=", or click the SUM option on the Paste Function menu and enter "ABOVE" in parentheses. When you have finished typing, click OK.

Step four: In this way, all the data above the cell is computed.

word2013 averaging operation:

Step one: Similarly, first move the cursor to the cell where the result is placed, and then click the Formula option in the data group on the Layout tab to eject the Formula dialog box.

Step two: After "=", enter "AVERAGE (ABOVE)" (average of the above data), or click the AVERAGE option in the Paste Function menu and enter "ABOVE" in parentheses. When you have finished typing, click OK.

Step three: In this way, the average of all the data above the cell is calculated.

word2013 calculation of maximum value:

Step one: Ditto, click Formula to enter Max (ABOVE) in the Formula dialog box that pops up, or click the Max option on the Paste Function menu and enter ABOVE in parentheses. "\ \ \ \ \ \ \ \" When you have finished typing, click OK.

Step Two: This calculates the maximum value of all the data above the cell.

word2013 the minimum value operation:

Step one: Ditto, click the Formula option, enter min (ABOVE) after the "=" in the formula dialog box that pops up, or click the Min option in the Paste Function menu and enter "ABOVE" in parentheses. " When you have finished typing, click OK.

Step Two: This calculates the minimum value of all the data on the cell.

Related Article

E-Commerce Solutions

Leverage the same tools powering the Alibaba Ecosystem

Learn more >

Apsara Conference 2019

The Rise of Data Intelligence, September 25th - 27th, Hangzhou, China

Learn more >

Alibaba Cloud Free Trial

Learn and experience the power of Alibaba Cloud with a free trial worth $300-1200 USD

Learn more >

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.