Excel gives you the ability to apply number formats to your values. Please describe the Accounting Number Format, Percent Style, and Comma Style formats and give an example of how a number would appear in each case.

Question

What will be an ideal response?

Answer 1

- The Accounting Number Format button displays cell contents in your local currency format. For example, if your copy of Windows is configured for use in the U.S., the currency button displays cell contents as dollars and cents with a leading dollar sign ($) and two digits to the right of the decimal point. An example would be: $1,234.67.
- The Percent Style button displays cell contents as a percentage, which means .35 is displayed as 35%.
- The Comma Style button adds a comma to the values displayed in the cell. If your computer is configured for use in the U.S., the Comma Style button adds a comma every three digits to the left of the decimal point and displays two digits to the right of the decimal point. An example would be: 12,345.67.