USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
The formula to add up a range of cells is
|
|
=TOTAL
|
|
|
=IF
|
|
|
=SUM
|
|
|
=ADD
|
Explanation:
Detailed explanation-1: -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 (.
Detailed explanation-2: -Excel SUM is a math and trig function that adds values. The syntax of the SUM function is as follows: SUM(number1, [number2], …) The first argument is required, other numbers are optional, and you can supply up to 255 numbers in a single formula.
There is 1 question to complete.