DATABASE FUNDAMENTALS
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: -The easiest way to apply the function is to simply select a cell next to the numbers that we wish to add and click on AutoSum on the Home tab. We can then press the Enter key and the SUM formula is automatically inserted.
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: -The AutoSum button includes a menu that appears when you click the arrow next to the button. You can enter the Average, Count, Max, or Min function almost as easily as you can enter the Sum functionall it takes is an extra click to select the function you want from the menu.