USING MICROSOFT EXCEL
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Accounting
|
|
|
Percent
|
|
|
Currency
|
|
|
Money
|
Detailed explanation-1: -In Excel, you can format numbers in cells for things like currency, percentages, decimals, dates, phone numbers, or social security numbers.
Detailed explanation-2: -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-3: -Select the cells that you want to format and then, in the Number group on the Home tab, click the down arrow in the Number Format box. Choose either Currency or Accounting.
Detailed explanation-4: -By default, Excel does not display leading zeros. To display leading zeros, select the cell(s) whose format you want to change, and then go to Format > Cells. In the Number tab of the Format Cells, select “0", or one of the other Custom formats that begins with a zero ("00", “000", etc.), from the Category list.