Correct Answer - Option 3 : CONCATENATE
The correct answer is CONCATENATE .
CONCATENATE:
- This function joins two or more text strings into one text string.
its syntax is :
- CONCATENATE (text1, text2,...).
- The text items can be text strings, numbers, or single-cell references.
Some important mathematical functions used in MS Excel are:
- SUM
- AVERAGE
- AVERAGEIF
- COUNTA
- COUNTIF
- MOD
- ROUND