USING MICROSOFT WORD
NEW DOCUMENTS TEMPLATES IN MICROSOFT WORD
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
2 + 3 =
|
|
|
= A + B
|
|
|
=A2+B3
|
|
|
A2+B3
|
Detailed explanation-1: -Using a formula like: =SUM(A1, A2, A3, B1, B2, B3)
Detailed explanation-2: -For example, cells B1, B2, and B3 contain 20, 44, and 67 respectively. 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.
Detailed explanation-3: -A formula in Excel is used to do mathematical calculations. Formulas always start with the equal sign ( = ) typed in the cell, followed by your calculation. Formulas can be used for calculations such as: =1+1. =2*2.
Detailed explanation-4: -Excel 2016 =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. =A1/A2 divides the value in A1 by A2.