arrow
arrow
arrow
Study the screen shots given below. The number 500 has been given a two-column spacing. What option must be selected from the image above to achieve
Question

Study the screen shots given below.

The number 500 has been given a two-column spacing. What option must be selected from the image above to achieve this?

A.

Shrink to fit

B.

Wrap Text

C.

Select two cells and press delete

D.

Merge Cells

Correct option is D

The display of “500” centered across two columns in Figure 1 is achieved by selecting both cells and applying the “Merge Cells” option (visible in the “Text control” section of Figure 2).

This merges the selected cells into a single cell and centers the content if aligned properly.

Important Key Points:

  1. Merge Cells combines multiple adjacent cells into one large cell — often used for headings or spacing like in the question.
  2. It’s found under Format Cells → Alignment → Text control.
  3. After merging, the content appears centered across the new merged cell unless changed.

Knowledge Booster:

  • Shrink to fit: Reduces the font size to fit the content within the existing cell width — it doesn't span across columns.
  • Wrap Text: Moves long content to the next line within the same cell; doesn’t expand across columns.
  • Select two cells and press delete: Removes content, not formatting — doesn’t span or merge cells.

Free Tests

Free
Must Attempt

UP SI 2025 Full Mock Test : 01

languageIcon English
  • pdpQsnIcon160 Questions
  • pdpsheetsIcon400 Marks
  • timerIcon120 Mins
languageIcon English
Free
Must Attempt

UP Police Constable Full Mock Test 01

languageIcon English
  • pdpQsnIcon150 Questions
  • pdpsheetsIcon300 Marks
  • timerIcon120 Mins
languageIcon English
Free
Must Attempt

Government Policies and Scheme

languageIcon English
  • pdpQsnIcon10 Questions
  • pdpsheetsIcon20 Marks
  • timerIcon5 Mins
languageIcon English

Similar Questions

test-prime-package

Access ‘UPSSSC’ Mock Tests with

  • 60000+ Mocks and Previous Year Papers
  • Unlimited Re-Attempts
  • Personalised Report Card
  • 500% Refund on Final Selection
  • Largest Community
students-icon
354k+ students have already unlocked exclusive benefits with Test Prime!
Our Plans
Monthsup-arrow