DATABASE FUNDAMENTALS
HOW TO INSERT DELETE COLUMNS ROWS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
left
|
|
|
right
|
|
|
Either A or B
|
|
|
None of the above
|
Detailed explanation-1: -Conventional wisdom had it when spreadsheets were first invented that text should align to the left of a cell and numbers should align to the right. This is the default setup for Excel.
Detailed explanation-2: -By default, Microsoft Excel aligns numbers to the bottom-right of cells and text to the bottom-left. However, you can easily change the default alignment by using the ribbon, keyboard shortcuts, Format Cells dialog or by setting your own custom number format.
Detailed explanation-3: -You can change the direction of Excel to left-to-right with steps below: 1. Click File > Options > Advanced > Display, select Left-to-right for Default direction.
Detailed explanation-4: -The General format is the default number format that Excel applies when you type a number. For the most part, numbers that are formatted with the General format are displayed just the way that you type them.