DATABASE FUNDAMENTALS
BASICS OF BIG DATA
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
one
|
|
|
two
|
|
|
three
|
|
|
zero
|
Detailed explanation-1: -Number Format Menu Select the “Percentage” item on the list. This will automatically format the cell as a percentage with two places after the decimal point. You can adjust the places after the decimal point using the format cell technique explained above.
Detailed explanation-2: -In the Format Cells dialog box, in the Category list, click Percentage. In the Decimal places box, enter the number of decimal places that you want to display. For example, if you want to see 10% instead of 10.00%, enter 0 in the Decimal places box.
Detailed explanation-3: -Right-click on the highlighted cells and select “Format Cells” from the drop-down menu that appears. Click on the “Number” tab in the “Format Cells” dialog box after it opens. Select “Percentage” from the “Category:” list on the left side of the dialog box.
Detailed explanation-4: -By default, Excel does not display leading zeros. To display leading zeros, select the cell(s) whose format you want to change, and then go to Format > Cells. In the Number tab of the Format Cells, select “0", or one of the other Custom formats that begins with a zero ("00", “000", etc.), from the Category list.