USING MICROSOFT EXCEL
HOW TO INSERT DELETE COLUMNS ROWS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Currency
|
|
|
Date
|
|
|
Number
|
|
|
Text for option 4 (optional)
|
Detailed explanation-1: -Choose the cell or range of cells you want to format. Right-click to open the context menu and select the “Format Cells” option to open the dialog box. Choose the “Number” tab in the dialog box and select “Accounting” under the “Categories” menu.
Detailed explanation-2: -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-3: -Tip: To quickly apply the Currency format, select the cell or range of cells that you want to format, and then press Ctrl+Shift+$. Like the Currency format, the Accounting format is used for monetary values. But, this format aligns the currency symbols and decimal points of numbers in a column.
Detailed explanation-4: -Apply an International Currency Format Select the range you want to format. Click the Number Format list arrow in the Number group of the Home tab. In the menu, you’ll see any number formatting containing a currency symbol matches your selection in the Windows regional settings. Select Currency or Accounting.