Examveda

Which tool you will use to join some cells and place the content at the middle of joined cell?

A. From Format Cells dialog box click on Merge Cells check box

B. From Format Cells dialog box select the Centered alignment

C. From Format Cells dialog box choose Merge and Center check box

D. Click on Merge and Center tool on formatting toolbar

Answer: Option C

Solution (By Examveda Team)

To join some cells and place the content at the middle of the joined cell in MS Excel, you need to use the "Merge and Center" feature. This can be done by selecting the cells you want to merge, then going to the Format Cells dialog box. Within this dialog box, you'll find the option to Merge and Center. By choosing this option, the selected cells will be merged into one and the content will be placed at the middle of the merged cell. This ensures a visually appealing layout for your data.

This Question Belongs to Computer Fundamentals >> MS Excel

Join The Discussion

Comments (13)

  1. DEBASIS ROUT
    DEBASIS ROUT:
    1 year ago

    Change the answer to option (D)

  2. Rajan Singh
    Rajan Singh:
    2 years ago

    What is the

  3. Zee Khan
    Zee Khan:
    4 years ago

    option D is correct..

  4. Hussain Badar
    Hussain Badar:
    5 years ago

    Answer is D plz change it

  5. RaKS
    RaKS :
    5 years ago

    In 2003 the merge and center option is available in the formatting toolbar. option D is the right answer.

  6. Soustabh Paul
    Soustabh Paul:
    5 years ago

    In the alignment section of toolbar, there is center button + merge and center options to be click

  7. Imran Rana
    Imran Rana:
    5 years ago

    It's answer is D

  8. Ammar Yasir
    Ammar Yasir:
    5 years ago

    Answer must be c merge and center

  9. Jayoda Punsada
    Jayoda Punsada:
    5 years ago

    This answer is wrong? correct answer is D?

  10. Vikky Vikky
    Vikky Vikky:
    5 years ago

    answer is wrong

  11. Om Prakash
    Om Prakash:
    5 years ago

    not satisfy due to question is content at the middle of joined cell? without merge and center check box select it not happen . so answer will c

  12. Shivam Kumar
    Shivam Kumar:
    5 years ago

    Given Answer is wrong it should be d

  13. Vishvjeet G
    Vishvjeet G:
    5 years ago

    Answer must Be (D)

Related Questions on MS Excel