FUNDAMENTALS OF COMPUTER

USING MICROSOFT EXCEL

ADJUSTING COLUMN WIDTH ROW HEIGHT IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
You can change the amount of decimal places in which formats in Excel?
A
general
B
text
C
currency and accounting
D
none of these
Explanation: 

Detailed explanation-1: -When you apply the Currency format to a number, the currency symbol appears right next to the first digit in the cell. You can specify the number of decimal places that you want to use, whether you want to use a thousands separator, and how you want to display negative numbers.

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: -Excel’s standard Accounting number format contains two decimal points and a thousand separators and locks the dollar sign to the extreme left half of the cell.

Detailed explanation-4: -By default, cells formatted as currency display two decimal places. You can change this setting so cells display as many decimal places as you type in them, or so all cells display the same number of decimal places.

There is 1 question to complete.