USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Correct or incorrect formula?=sum(C4:C9)
|
|
Correct
|
|
|
Incorrect
|
|
|
Either A or B
|
|
|
None of the above
|
Explanation:
Detailed explanation-1: -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. It also includes the changes made to an existing cell range.
Detailed explanation-2: -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.
There is 1 question to complete.