Menu
Home / Computer Fundamentals / MS Excel :: Discussion

Discussion :: MS Excel

  1. Concatenation of text can be done using

    2. A.

     Apostrophe ( ‘ )
    B.

     Exclamation ( ! )
    C.

     Hash ( # )
    D.

     Ampersand ( & )

    View Answer

    Workspace

    View Answer

    Answer : Option D

    Explanation :

    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.

Write your comments here:

Be The First To Comment