InterviewSolution
Saved Bookmarks
| 1. |
What is the different between scientific number format and percentage number format in the computer |
|
Answer» entific format displays a number in exponential notation, replacing part of the number with E+n, in which E (EXPONENT) multiplies the preceding number by 10 to the nth POWER. For example, a 2-decimal scientific format displays 12345678901 as 1.23E+10, which is 1.23 TIMES 10 to the 10TH power.but Percentages are calculated by using the equation amount / total = percentage. For example, if a cell contains the formula =10/100, the RESULT of that calculation is 0.1. If you then format 0.1 as a percentage, the number will be correctly displayed as 10%. |
|