DATABASE FUNDAMENTALS
BASICS OF BIG DATA
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Increase Decimal
|
|
|
Percent Style
|
|
|
Increase Indent
|
|
|
Decrease Indent
|
Detailed explanation-1: -Select the cells that you want to format. On the Home tab, click Increase Decimal or Decrease Decimal to show more or fewer digits after the decimal point.
Detailed explanation-2: -To add Increase Decimal and Decrease Decimal to the Quick Access Toolbar: Right-click Increase Decimal on the Home tab in the Ribbon and select Add to Quick Access Toolbar from the drop-down menu.
Detailed explanation-3: -The Increase Decimal and Decrease Decimal commands allow you to control how many decimal places are displayed in a cell. These commands don’t change the value of the cell; instead, they display the value to a set number of decimal places.
Detailed explanation-4: -In the Customize Format dialog box, select the Numbers tab and in the Decimal symbol drop-down, select the separator you want to use.
Detailed explanation-5: -Just use %. 2f as the format specifier. This will make the Java printf format a double to two decimal places.