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

Microsoft Excel - Quiz(MCQ)

From Format Cells dialog box click on Merge Cells check box

Click on Merge and Center tool on formatting toolbar

From Format Cells dialog box select the Centered alignment

From Format Cells dialog box choose Merge and Center check box

Correct Answer : From Format Cells dialog box click on Merge Cells check box

Explanation :

* In 2003 and earlier versions - From Format Cells dialog box click on Merge Cells check box

* In 2007 and subsequent versions - Merge & Center icon on the Home ribbon.

Recently Updated in Microsoft Excel Questions

What is the keyboard shortcut to switch between open Excel windows?

ALT + TAB

CTRL + TAB

CTRL + ALT + TAB

None of the above

Correct Answer : CTRL + TAB

What is the keyboard shortcut to copy the value from the cell above the active cell into the cell or the Formula Bar in MS Excel?

ALT + SHIFT + "

CTRL + ALT + "

CTRL + SHIFT + C

CTRL + SHIFT + "

Correct Answer : CTRL + SHIFT + "

Explanation : The keyboard shortcut to copy the value from the cell above the active cell into the cell or the Formula Bar is "CTRL + SHIFT + "".

What is the keyboard shortcut to display the Format Cells dialog box in MS Excel?

CTRL + 1

ALT + 1

CTRL + F

CTRL + SHIFT + F

Correct Answer : CTRL + 1

Explanation : The keyboard shortcut to display the Format Cells dialog box is "CTRL + 1".

New Technologies MCQ's

Machine Learning

Artificial Intelligence