DATABASE FUNDAMENTALS
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Accounting
|
|
|
Currency
|
|
|
Accounting and Currency
|
|
|
None of the above
|
Detailed explanation-1: -On the Home tab, click the Dialog Box Launcher next to Number. 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-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: -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-4: -Difference between Currency and Accounting Format The Currency format aligns the currency sign at the left edge of the value in the cell. The Accounting format aligns the currency sign at the left edge of the cell, nearest to the border. We can choose to align values in left, right, or center.