DATABASE FUNDAMENTALS
WORKBOOK THEMES
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
accounting format
|
|
|
wrap text
|
|
|
merge and center
|
|
|
date format
|
Detailed explanation-1: -To create an Excel custom number format with a thousands separator, include a comma (, ) in the format code. For example: #, ###-display a thousands separator and no decimal places. #, ##0.00-display a thousands separator and 2 decimal places.
Detailed explanation-2: -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-3: -The cell format that displays numerical data preceded by a dollar sign is currency. In order to change a cell’s appearance, you must first select the cell you want to change. You can remove the formats you apply to a cell by choosing Clear on the Tools menu.
Detailed explanation-4: -This style format is used to instruct Excel to display numbers with commas and no dollar signs. It can be assigned to a range of cells by clicking the Comma Style button. This inserts a comma every three positions to the left of the decimal point and causes number to be displayed to the nearest hundredths.