How to use autosum in excel of WPS Office

July 26, 2022
859 Views
0

A free Office suite fully compatible with Microsoft Office

Free Download

Excel's AutoSum function, in its most basic version, computes total in your spreadsheet by automatically entering a formula. This fantastic function not only provide accuracy but also save your time. This brief lesson provides an explanation of how to use AutoSum in excel and demonstrates the most effective methods for using AutoSum in Excel.

You will learn how to automatically sum columns or rows by using the shortcut called Sum, how to sum only the cells that are visible, how to quickly total a selected range both vertically and horizontally,

If you are wondering how to use AutoSum in Excel? then you are now going to know the solution to that question:)

How To Use Autosum in Excel to sum the data?

Instead of calculating each piece of information one at a time using a calculator, which would be a waste of time, we can use the AutoSum option that is included in the WPS Spreadsheet to sum the data correctly and quickly.

1. After choosing the data area you want to sum, click the drop-down arrow next to the AutoSum button in the Formulas tab.

2. Locate the button labelled Sum and click it to obtain the total value result quickly.

How To Use Autosum in Excel to get the averages of sales?

AutoSum in the WPS Spreadsheet allows us to rapidly and accurately calculate the averages of sales data, rather than calculating each piece of information one at a time using a calculator.

1. After choosing the data area you want to sum, click the drop-down arrow next to the AutoSum button in the Formulas tab.

2. Now just go down to select the average option and click on it to rapidly acquire the result for the averages of all the selected values.


How To Use Autosum in Excel to calculate maximum and minimum sales?

Instead of investing a lot of time trying to find out what the maximum and minimum sales are, we can quickly and reliably compute them using the AutoSum function found in the WPS Spreadsheet.

1. After choosing the sales as you want to get maximum of, click the drop-down arrow next to the AutoSum button in the Formulas tab.

2. Now just go down to select the maximum or minimum option and click on it to rapidly acquire the result for the maximum or minimum of all the selected sales.

You have been led through the necessary steps to illustrate how to use autosum in Excel to calculate the sum of values, the average of values, the lowest and largest sales, and a variety of other calculations.

If you are interested in learning more about the WPS office, please check out the webpage for the WPS Academy where you can learn various other functions of WPS office excel, word and other. You can also download WPS Office for free from this link if you want to edit files in Word, Excel, or PowerPoint. PDF files are not supported.