USING MICROSOFT EXCEL
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
=SUM
|
|
|
=AUTOSUM()
|
|
|
=SUM()
|
|
|
=AUTOSUM
|
Detailed explanation-1: -When you click AutoSum, Excel automatically enters a formula (that uses the SUM function) to sum the numbers.
Detailed explanation-2: -The Autosum Excel Function[1] can be accessed by typing ALT + the = sign in a spreadsheet, and it will automatically create a formula to sum all the numbers in a continuous range.
Detailed explanation-3: -Autosum adds up a range of numbers automatically and places the result in a nearby cell. To perform Autosum, click a nearby cell and click Autosum on the Home tab and press Enter. In this tutorial, you will learn how to use autosum in Excel.
Detailed explanation-4: -Click on the AutoSum button from the Editing group of the ribbon. Excel will highlight the cells that it is adding up and will apply the SUM formula. Hit Enter to accept the highlighted cells and see the total value of your data.
Detailed explanation-5: -To use the SUM function, type =sum() into a cell. The cell references of the cells you want to add go within the parentheses. The AutoSUM button, which looks like the Greek letter sigma, will automatically put the SUM function into a cell. There are several ways to reference cells within the SUM function.