FUNDAMENTALS OF COMPUTER

Previous
Next

DATABASE FUNDAMENTALS

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: -Use 1000 separator-The 1000 separator will insert a comma every 3 digits, i.e. hundred, thousand etc.

Detailed explanation-2: -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-3: -Click File > Options. On the Advanced tab, under Editing options, clear the Use system separators check box. Type new separators in the Decimal separator and Thousands separator boxes. Tip: When you want to use the system separators again, select the Use system separators check box.

Detailed explanation-4: -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.

There is 1 question to complete.
Previous
Next