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.
Which of the following option is NOT present in Office Button? ...
Microsoft Office 2007 introduced the Ribbon as a ____________ element. ...
Show/Hide Gridlines option is available in the ____ menu of Excel. ...
What are the correct steps to protect a PowerPoint presentation with a password? ...
When all the numbers between 0 and 100 in a range should be displayed in red color, apply ...
In Excel, how can you remove borders applied in cells? ...
Which of the following is not valid version of Microsoft Office? ...