Q55
Concatenation of text can be done using
A.
Apostrophe ( ‘ )
B.
Exclamation ( ! )
C.
Hash ( # )
D.
Ampersand ( & )
AnswerAnswer: Option D
Solution
Answer: Option D
Solution:
The ampersand (&) calculation operator allow us join text items without using a function. For example, =A1 & B1 will return the same value as =CONCATENATE(A1,B1). In many cases, using the ampersand operator is quicker and simpler than using CONCATENATE to create strings.