DATABASE FUNDAMENTALS
ADJUSTING COLUMN WIDTH ROW HEIGHT IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
If you want to subtract two numbers in a formula, which formula would be correct?
|
|
=1.2*3
|
|
|
=e3+e7
|
|
|
=A2-30
|
|
|
-E7=A3
|
Explanation:
Detailed explanation-1: -To do simple subtraction, use the-(minus sign) arithmetic operator. For example, if you enter the formula =10-5 into a cell, the cell will display 5 as the result.
Detailed explanation-2: -Subtraction formula in Excel (minus formula) In a cell where you want the result to appear, type the equality sign (=). Type the first number followed by the minus sign followed by the second number. Complete the formula by pressing the Enter key.
Detailed explanation-3: -The FORMULATEXT function returns a text string that shows the formula in a worksheet cell.
Detailed explanation-4: -=SUM(A2:A10) Adds the values in cells A2:10.
There is 1 question to complete.