USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
The autosum button
|
|
|
The Formula button
|
|
|
The quicktotal button
|
|
|
The total button
|
Detailed explanation-1: -If you need to sum a column or row of numbers, let Excel do the math for you. Select a cell next to the numbers you want to sum, click AutoSum on the Home tab, press Enter, and you’re done. When you click AutoSum, Excel automatically enters a formula (that uses the SUM function) to sum the numbers.
Detailed explanation-2: -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.
Detailed explanation-3: -Click the AutoSum button on either the Home or Formulas tab. A Sum formula appears in the selected cell, and a range of cells you’re adding gets highlighted (B2:B6 in this example): In most cases, Excel selects the correct range to total.
Detailed explanation-4: -The symbol “Ʃ” indicates the auto sum in MS Excel. Excel automatically enters a formula to sum the numbers while using the Auto sum. The AutoSum button is available in the ‘Home’ tab on the excel ribbon.
Detailed explanation-5: -One quick and easy way to add values in Excel is to use AutoSum. Just select an empty cell directly below a column of data. Then on the Formula tab, click AutoSum > Sum.