DATABASE FUNDAMENTALS
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: -=A1+A2+A3 Adds the values in cells A1, A2, and A3. =SQRT(A1) Uses the SQRT function to return the square root of the value in A1.
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. Excel inserts a cell name into the formula each time you click on one.
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.