USING MICROSOFT EXCEL
HOW TO INSERT DELETE COLUMNS ROWS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
A1+B2
|
|
|
=A1+B2
|
|
|
SUM(A1:B2)
|
|
|
=$A1, $B2
|
Detailed explanation-1: -The SUM function adds values. You can add individual values, cell references or ranges or a mix of all three. For example: =SUM(A2:A10) Adds the values in cells A2:10.
Detailed explanation-2: -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-3: -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.
Detailed explanation-4: -=A1+A2 adds the values in cells A1 and A2. =A1-A2 subtracts the value in A2 from A1. =A1*A2 multiplies the values in A1 and A2.