Concatenation of text can be done in Excel using
...Concatenation of text can be done in Excel using
Apostrophe ( ‘ )
Exclamation ( ! )
Hash ( # )
Ampersand ( & )
Correct answer is D
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.
In MS Access, AutoNumber data type__? ...
Which key do you press to check spelling? ...
Which key stroke is used to move the active cell to the right, in an Access table ? ...
Which of the following is automatically counted in Microsoft Word? ...
When you link data maintained in an excel workbook to a word document ...
___________ can be created to help easy data entry in MS Access tables ? ...
What is the default font used in Microsoft Word 2016 document? ...