FUNDAMENTALS OF COMPUTER

Previous
Next

USING MICROSOFT EXCEL

WORKBOOK THEMES

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
The ____ inserts a comma every three positions to the left of the decimal point and causes numbers to be displayed to the nearest hundredths.
A
Floating dollar sign
B
Ribbon
C
Summary
D
Comma style format
Explanation: 

Detailed explanation-1: -The comma style in Excel is also known as the thousand separator format that converts the large number values with the commas inserted as separators to distinguish the number value length into thousands, hundred thousand, millions, and so on.

Detailed explanation-2: -Use 1000 separator-The 1000 separator will insert a comma every 3 digits, i.e. hundred, thousand etc.

Detailed explanation-3: -The standard comma style format contains up to two decimal points and a thousand separators and locks the dollar sign to the extreme left half of the cell. Negative numbers are shown in enclosures.

Detailed explanation-4: -To display numbers with comma style format in Excel: Select the cells containing numeric sales values for which I want to display numbers with comma style number format. On the Home tab, you can select the comma symbol & click on the Comma Style command in the Number group.

There is 1 question to complete.
Previous
Next