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.
You can activate a cell in Excel by ...
What is the best way to create another copy of a slide in PowerPoint? ...
A word processor would most likely be used to ...
Which key should be pressed to start a new paragraph in MS-Word? ...
In MS Access, ________ are used to store the data? ...
How can we create a query in Microsoft Access? ...
To Redo an Undo in MS Word, press ________ ...
Which programming language is used to write a Macro in MS Excel? ...