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. Merges cells without centering

B. Splits merged cells

C. Merges selected cells into one and centers the content

D. Centers text without merging

Answer: Option C

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

In Excel, which function returns the largest value from a range that meets multiple criteria?

A. LARGEIFS()

B. MAXIF()

C. DMAX()

D. MAXIFS()

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
MAXIFS available in Excel 2019/365.

This question belongs to: Computer Microsoft Office

Question #2

In Excel, the formula =$A1 is an example of:

A. Mixed reference (column absolute, row relative)

B. Circular reference

C. Absolute reference

D. Relative reference

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
$A locks column A, row remains relative.

This question belongs to: Computer Microsoft Office

Question #3

What is the shortcut to print a document in MS Word?

A. Both A and B

B. Alt + P

C. Ctrl + F2

D. Ctrl + P

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Ctrl+P and Ctrl+F2 both open Print.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs