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: -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.
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: -The DOLLAR function, one of the TEXT functions, converts a number to text using currency format, with the decimals rounded to the number of places you specify. DOLLAR uses the $#, ##0.00 ); ($#, ##0.00) number format, although the currency symbol that is applied depends on your local language settings.
Detailed explanation-4: -The easiest option to include a comma is simply to click on the Comma Style button in the Number group. When clicking the comma style button, the comma style default is to display numbers with a comma in the thousands place and include two decimal places (Ex: “1200” becomes “1, 200.00).