USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
=SUM(A2+A5)
|
|
|
=SUM(A1:A5)
|
|
|
=A1+A2+A3
|
|
|
=SUM(A1:A4)
|
Detailed explanation-1: -Formula for adding values of cells A1 to A5 would be =SUMA1 : A5.
Detailed explanation-2: -The sum formula is simply “=SUM(cell1:cell2)". So, if you want to sum cells A1 to A5, you would enter “=SUM(A1:A5)".
Detailed explanation-3: -You can use a simple formula to sum numbers in a range (a group of cells), but the SUM function is easier to use when you’re working with more than a few numbers. For example =SUM(A2:A6) is less likely to have typing errors than =A2+A3+A4+A5+A6.
Detailed explanation-4: -In Excel, a formula is an expression that operates on values in a range of cells or a cell. For example, =A1+A2+A3, which finds the sum of the range of values from cell A1 to cell A3.
Detailed explanation-5: -For example, to add together cells A1 and B1, move to C1 (or wherever you want the result of the calculation to appear) and type the =. Then use the mouse to click in A1, type the +, click in B1, and hit the enter key.