DATABASE FUNDAMENTALS
USING THE UPPER AND LOWER FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Converts decimals to commas within a cell
|
|
|
Converts decimals to commas within merged cells
|
|
|
Displays cell contents with two decimal places and commas as thousands separators
|
|
|
Allows for substitution of selected characters
|
Detailed explanation-1: -Like the “Accounting” position, the comma arrangement embeds commas in bigger numbers to isolate thousands, hundred thousand, millions, and all values considered. 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.
Detailed explanation-2: -What effect does the Comma Style format have on the selected text? The Comma Style format causes the class to be displayed with two decimal places and commas as thousands separators.
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: -Select the cells that you want to format. On the Home tab, click the Dialog Box Launcher next to Number. On the Number tab, in the Category list, click Number. To display or hide the thousands separator, select or clear the Use 1000 Separator (, ) check box.
Detailed explanation-5: -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.