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 starts with an equal sign (=), which can be followed by numbers, math operators (such as a plus or minus sign), and functions, which can really expand the power of a formula. For example, the following formula multiplies 2 by 3 and then adds 5 to that result to come up with the answer, 11.
Detailed explanation-2: -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-3: -The parts of a function: All functions begin with the = sign. After the = sign, define the function name (e.g., Sum). Then there will be an argument.
Detailed explanation-4: -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].