arrow
arrow
arrow
The default alignment of data in MS Excel is:
Question



The default alignment of data in MS Excel is:

A.

Text is left aligned, and numbers are right aligned

B.

Text is right aligned, and numbers are left aligned

C.

Both text and numbers are left aligned

D.

Both text and numbers are right aligned

Correct option is A

In MS Excel, the default alignment settings are:
· Text: Left-aligned.
· Numbers: Right-aligned.
This distinction helps in differentiating between text and numeric data within a cell. Users can customize alignment as per their needs using the alignment options in the toolbar.
Important Key Points:
1. Left alignment for text and right alignment for numbers are default settings to ensure clear presentation of data.
2. This default behavior can be changed using the Alignment group under the Home tab.
3. Dates and times are also right-aligned by default as they are treated as numeric values.
Knowledge Booster:
· Custom formatting allows you to change text and number alignment, including centering.
· Data alignment can also be adjusted using keyboard shortcuts like Alt + H + A + L for left alignment or Alt + H + A + R for right alignment.
· Proper alignment improves the readability and presentation of data in spreadsheets.

Free Tests

Free
Must Attempt

Government Policies and Scheme

languageIcon English
  • pdpQsnIcon10 Questions
  • pdpsheetsIcon20 Marks
  • timerIcon5 Mins
languageIcon English
Free
Must Attempt

Government Schemes

languageIcon English
  • pdpQsnIcon10 Questions
  • pdpsheetsIcon20 Marks
  • timerIcon5 Mins
languageIcon English
Free
Must Attempt

SSC GD PYP (Held on 4 Feb 2025 S1)

languageIcon English
  • pdpQsnIcon80 Questions
  • pdpsheetsIcon160 Marks
  • timerIcon60 Mins
languageIcon English
test-prime-package

Access ‘UPSSSC JE’ Mock Tests with

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