DATABASE FUNDAMENTALS
MODIFYING PAGE SETUP PROPERTIES IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
=A1+B1
|
|
|
=C1+C2
|
|
|
=A2+B2
|
|
|
=B2+B3
|
Detailed explanation-1: -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-2: -Explanation: If A1 contains value 20 and B1 contains value 3 then the value of “=A1+B1*2^3” in spreadsheet gives 44 because–Firstly value is put on the expression and the expression form ( ). Firstly power is performed because it has higher precedence and the value is (20+3*8).
Detailed explanation-3: -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. =SUM(A2:A10, C2:C10) Adds the values in cells A2:10, as well as cells C2:C10.
Detailed explanation-4: -For example, if cell A1 had a first name and cell B1 had a last name, you could enter =A1&” “&B1, which combines A1 with B1, with a space between each value. You can also use a concatenate formula to combine cell values.