DATABASE FUNDAMENTALS
HOW TO USE THE CONCATENATE FUNCTION IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
arithmetic
|
|
|
comparison
|
|
|
text concatenation
|
|
|
reference
|
Detailed explanation-1: -Arithmetic operators are used in arithmetic computations.
Detailed explanation-2: -Arithmetic Operators are used to perform mathematical calculations. Assignment Operators are used to assign a value to a property or variable. Assignment Operators can be numeric, date, system, time, or text. Comparison Operators are used to perform comparisons.
Detailed explanation-3: -These operators are + (addition), -(subtraction), * (multiplication), / (division), and % (modulo).
Detailed explanation-4: -Addition and subtraction are two of the ways we work with numbers. We call them arithmetical operations. The word operation comes from the Latin ‘operari’, meaning to work or toil. Of the four arithmetical operations on numbers, addition is the most natural.