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.
Concatenation of text can be done in Excel using ...
To open a new database in MS Access, press ...
In an Excel worksheet, you can select ...
Quick Access Toolbar is present at the ______ of the Office Button in Microsoft Word. ...
In Microsoft Excel, shortcut key CTRL + D is used to ____ ...
How can you quickly reinstate a deleted footer placeholder in PowerPoint master view? ...
Under which tab can chart options be found in MS Excel? ...
What are the steps for protecting an Excel Sheet by password? ...
Which of the cell pointer indicates that you can fill series? ...
Which chart type is used to visually compare values across a few categories in Excel? ...