USING MICROSOFT EXCEL
WORKBOOK THEMES
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
comma format
|
|
|
currency format
|
|
|
number format
|
|
|
percent format
|
Detailed explanation-1: -When you apply the Currency format to a number, the currency symbol appears right next to the first digit in the cell. You can specify the number of decimal places that you want to use, whether you want to use a thousands separator, and how you want to display negative numbers.
Detailed explanation-2: -To have the currency symbol appear on the left of the cell rather than just to the left of the number, include for example, $* or â* followed by a space at the beginning of the number format. The example on the left uses the number format: “â* #, ##0; â*-#, ##0” (without the quotes).
Detailed explanation-3: -The accounting number format in Excel is a formatting style that displays numbers as financial values in the program. When users apply this formatting style, it automatically displays numbers with a currency symbol, such as a dollar sign, and displays decimal values.