In MS Excel, what does the 'Merge & Center' option do? MCQ with Answer and Explanation

Question

Share Report Error

In MS Excel, what does the 'Merge & Center' option do?

A. Splits merged cells

B. Centers text without merging

C. Merges cells without centering

D. Merges selected cells into one and centers the content

Answer: Option D

Solution (By JKSSB Mock Tests)

Merge & Center combines the selected cells into a single cell and centers the text horizontally.

This question belongs to: Computer Microsoft Office

Request complete Subject PDF

Discuss this Question (0)

No comments yet. Be the first to start the discussion!

Practice More Microsoft Office Questions

Question #1

Which shortcut key inserts a page break in MS Word?

A. Ctrl + Shift + Enter

B. Ctrl + Enter

C. Shift + Enter

D. Alt + Enter

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Ctrl + Enter inserts a manual page break. Shift + Enter is a line break, Alt + Enter in Excel starts a new line in a cell.

This question belongs to: Computer Microsoft Office

Question #2

In MS Word, which key is used to extend a selection?

A. F8

B. Shift

C. Alt

D. Ctrl

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
F8 turns on extend selection mode; pressing it repeatedly selects word, sentence, paragraph, etc. Shift+arrow also extends.

This question belongs to: Computer Microsoft Office

Question #3

In Excel, which function returns the serial number of a specific date given year, month, day?

A. DATEVALUE()

B. NOW()

C. DATE()

D. TODAY()

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
DATE(year, month, day) constructs a date.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs