DATABASE FUNDAMENTALS
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.