DATABASE FUNDAMENTALS
ADJUSTING COLUMN WIDTH ROW HEIGHT IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Accounting
|
|
|
General
|
|
|
Number
|
|
|
Currency
|
Detailed explanation-1: -Excel’s standard Accounting number format contains two decimal points and a thousand separators and locks the dollar sign to the extreme left half of the cell. Negative numbers are shown in enclosures.
Detailed explanation-2: -Tip: To quickly apply the Currency format, select the cell or range of cells that you want to format, and then press Ctrl+Shift+$. Like the Currency format, the Accounting format is used for monetary values. But, this format aligns the currency symbols and decimal points of numbers in a column.
Detailed explanation-3: -Method 2: Use the Accounting Number Format Press Ctrl + 1 to open the Format Cells dialog box, select Accounting in the Category list box, and click OK. In the Home tab, in the Number group, select Accounting from the Number Format drop-down list. The dollar sign is aligned to the left of the currency values.
Detailed explanation-4: -By default, cells formatted as currency display two decimal places. You can change this setting so cells display as many decimal places as you type in them, or so all cells display the same number of decimal places.