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.
In Microsoft Word, you can move the insertion point in a table ...
What does the Clean Up button do? ...
Which of the following formulas will Excel not be able to calculate? ...
Which key stroke is used to move the active cell towards left, in an Access table ? ...
Which program do you use to edit code for data access pages? ...
The total number of columns in an Excel worksheet is _________ ...
Which of the following is not a type of Microsoft access database object? ...
How many users can open an Excel file at the same time? ...
Which of the following formulas is not entered correctly? ...