USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Equals button
|
|
|
Plus symbol button
|
|
|
Auto-sum button
|
|
|
None of the above
|
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.
Detailed explanation-2: -The correct answer is option 1, i.e. The AutoSum button.
Detailed explanation-3: -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. It is also available in the ‘Formulas’ tab on the excel ribbon.
Detailed explanation-4: -Here’s a formula that uses two cell ranges: =SUM(A2:A4, C2:C3) sums the numbers in ranges A2:A4 and C2:C3. You’d press Enter to get the total of 39787. To create the formula: Type =SUM in a cell, followed by an opening parenthesis (.