DATABASE FUNDAMENTALS
HOW TO INSERT DELETE COLUMNS ROWS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
=
|
|
|
+
|
|
|
-
|
|
|
/
|
Detailed explanation-1: -A formula always begins with an equal sign (=). Excel for the web interprets the characters that follow the equal sign as a formula. Following the equal sign are the elements to be calculated (the operands), such as constants or cell references. These are separated by calculation operators.
Detailed explanation-2: -All Excel formulas begin with an equal sign (=). After the equal symbol, you enter either a calculation or function. For example, to add up values in cells B1 through B5, you can either: Type the entire equation: =B1+B2+B3+B4+B5.
Detailed explanation-3: -Why the symbol? The symbol is already used in table references to indicate implicit intersection. Consider the following formula in a table =[Column1]. Here the indicates that the formula should use implicit intersection to retrieve the value on the same row from [Column1].
Detailed explanation-4: -Mathematical operators All formulas must begin with an equals sign (=). This is because the cell contains-or is equal to-the formula and the value it calculates.