DATABASE FUNDAMENTALS
HOW TO INSERT DELETE COLUMNS ROWS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
True
|
|
|
False
|
|
|
Either A or B
|
|
|
None of the above
|
Detailed explanation-1: -The easiest option to include a comma is simply to click on the Comma Style button in the Number group. When clicking the comma style button, the comma style default is to display numbers with a comma in the thousands place and include two decimal places (Ex: “1200” becomes “1, 200.00).
Detailed explanation-2: -We can use accounting Excel format in the Number format ribbon, select the amount cell, click on ribbon home, and select the Comma Style from the Number format column. Once we click on the Comma Style, it will provide the comma-separated format value.
Detailed explanation-3: -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-4: -Comma style is a type of number format where it adds commas to large numbers, adds two decimal places (i.e. 1000 becomes 1, 000.00), displays negative values in closed parentheses & represents zeros with a dash (–). The shortcut key for comma style is ALT + HK.