USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
currency
|
|
percent
|
|
number
|
|
scientific
|
Detailed explanation-1: -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-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: -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.
Detailed explanation-4: -To do this, simply select the cells that you want to format and then click on the “Format Cells” option from the ribbon. In the “Number” tab, select the “Currency” option from the list and then choose your desired options such as the number of decimal places, the currency symbol, etc.