USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Normal
|
|
|
Date
|
|
|
Accounting
|
|
|
Time
|
Detailed explanation-1: -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-2: -Tip: You can also press Ctrl+1 to open the Format Cells dialog box. In the Format Cells dialog box, in the Category list, click Currency or Accounting. In the Symbol box, click the currency symbol that you want.
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: -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-5: -The Accounting format aligns dollar signs and decimal points, displays a dash for zero values and displays negative numbers in parentheses. You can use the Currency format to display negative numbers with a minus sign, in red, with parentheses, or in red with parentheses.