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 want to set up a button to automatically send an email you've received on to your manager, r...
Your boss sent you an important account code by mail two months ago. Unfortunately, you haven't ...
Which of the following database objects holds data in MS Access? ...
There is a ________ underline on the text of any grammar mistakes in a Microsoft Word document. ...
Title Bar is present at the _________ of the Quick Access Toolbar. ...
____________ is not a valid data type in MS Access? ...
Which of the following option is provided by Office Button in MS Word? ...
The slide that is used to introduce a topic and set the tone for the presentation is called the ...
How many users can open an Excel file at the same time? ...
How can you tell the email that you have read from the email that you have not read? ...