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.
A search value can be exact value or it can be ? ...
What are the correct steps to protect a PowerPoint presentation with a password? ...
You can check the conditions against _________ when applying conditional formatting in Excel. ...
Ctrl + D shortcut key in Excel will ...
With the help of Ruler, one can change the ___________ of the document in Microsoft Word. ...
Which of the following shortcut key is used to check spelling when required? ...
Which of the following option is NOT present in Office Button? ...
To switch between Form view and Design view in MS Access, press ? ...
Which data type allows alphanumeric characters and special symbols in MS Access? ...