Do you know how to perform statistical operations on tabular data inserted in a document? It teaches you to perform quick calculations in a document in one minute.

For example, let's say we want to figure out the total sales of small businesses in Q1 for all regions.

First of all, insert a total column on the right of the table,

select the data cell of row Q1, click the Table Tools tab, click the Fast Calculation drop-down button, and select Sum to calculate the Sum of the data in this row.

Select the data cells in the remaining rows to quickly figure out the total sales for each quarter for all regions to the left.

For example, find the total sales of small businesses in Asia. Using the same op data-imgw=720 data-imgh=405 data-src="//res-academy.cache.wpscdn.com/images/90561ba75c02b12f1f5b790163424a32_0.46_1872.gif" data-test="skks" style="max-width: 100%; width: 720px; max-height: 405px; height: calc(100vw *(405/720)); text-align:center;" >

In addition, we can also use the Fast Calculation function to find the Average value of the table data, Max value,and Min value.

Have you learned this simple and practical function?

WPS Office Spreadsheet is helpful for various fields of studies: mathematics, statistics, data science, engineering, finance, and such. Rich in functions paired with teaching procedures, WPS Office Spreadsheet definitely is a professional and reliable toolkit.