DATABASE FUNDAMENTALS
HOW TO USE THE CONCATENATE FUNCTION IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
$
|
|
|
&
|
|
|
.
|
|
|
*
|
Detailed explanation-1: -These symbols have the same meaning; commonly × is used to mean multiplication when handwritten or used on a calculator 2 × 2, for example. The symbol * is used in spreadsheets and other computer applications to indicate a multiplication, although * does have other more complex meanings in mathematics.
Detailed explanation-2: -Arithmetic. the symbol (⋅), (×), or (∗) between two mathematical expressions, denoting multiplication of the second expression by the first. In certain algebraic notations the sign is suppressed and multiplication is indicated by immediate juxtaposition or contiguity, as in ab.
Detailed explanation-3: -Presumably, the asterisk was chosen-presumably because it was the non-alphanumeric symbol that most-closely resembled the customary symbol that denoted multiplication, whereas the letter X could not be used, since FORTRAN used letters of the alphabet for symbolic variable names of variables and unknowns.
Detailed explanation-4: -In mathematics, the asterisk symbol * refers to multiplication. For example, consider the following expression: 7 * 6.