DATABASE FUNDAMENTALS
HOW TO INSERT DELETE COLUMNS ROWS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
^
|
|
|
/
|
|
|
-
|
|
|
=
|
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: -For simple formulas, simply type the equal sign followed by the numeric values that you want to calculate and the math operators that you want to use-the plus sign (+) to add, the minus sign (-) to subtract, the asterisk (*) to multiply, and the forward slash (/) to divide.
Detailed explanation-3: -Excel uses standard operators for formulas, such as a plus sign for addition (+), a minus sign for subtraction (-), an asterisk for multiplication (*), a forward slash for division (/), and a caret (^) for exponents. All formulas in Excel must begin with an equals sign (=).
Detailed explanation-4: -Calculate the difference between two numbers by inputting a formula in a new, blank cell. If A1 and B1 are both numeric values, you can use the “=A1-B1” formula. Your cells don’t have to be in the same order as your formula. For example, you can also use the “=B1-A1” formula to calculate a different value.