USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
What would be a correct formula for sum in excel?
|
=SUM(B3:B9)
|
|
=SUMB3+B9
|
|
SUM(B3:B9)
|
|
=ADD(B3:B9)
|
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.
Detailed explanation-2: -For example, cells B1, B2, and B3 contain 20, 44, and 67 respectively. The formula “=SUM(B1:B3)” adds the numbers of the cells B1 to B3. It returns 131. The SUM formula automatically updates with the insertion or deletion of a value.
There is 1 question to complete.