USING MICROSOFT EXCEL
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: -Formatting Applied Accounting Number Format Adds a dollar sign to the left, separates thousands with a comma, and displays the value with two digits to the right of the decimal point. This is a drop-down control, so that you can select other common currency symbols.