FUNDAMENTALS OF COMPUTER

Detailed explanation-1: -The cell format that displays numerical data preceded by a dollar sign is currency. In order to change a cell’s appearance, you must first select the cell you want to change. You can remove the formats you apply to a cell by choosing Clear on the Tools menu.

Detailed explanation-2: -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-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: -Type “#$” (without the quotes) into the box. This code will automatically place a dollar sign to the right of any number that you type into these cells. Click “OK” to close the window and apply your format to the first column.

Detailed explanation-5: -Generally, you should use the Format Cells dialog (Ctrl+1) or Home > Number > Accounting Number Format option to apply a currency formatting to a cell.