answersLogoWhite

0


Best Answer

The easiest way to find the top ten values in a list is to sort the list from highest to lowest and select the top ten cells.

User Avatar

Wiki User

14y ago
This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: How do you calculate top 10 using excel?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

What is 1050 to the tenth power?

The calculator built-in to Windows, states the answer to be... 162,889,4626,777,441,406,250,000,000,000


What is 20 to the power of 20?

That means that you multiply 20 by itself, using it 20 times as a factor:20 x 20 x 20 x ... x 20 (a total of 20 factors). You can calculate this in Excel, writing the following formula: = 20^20


How do you calculate log 1.616?

It is: 10 0.2084413564 = 1.616 by using a scientific calculator


Do 10 squared on Microsoft Excel?

There are a few ways to calculate this:=10*10=10^2=POWER(10,2)If you want the actual symbol, you can insert the small 2 by going to Insert and Symol and then you can find it under Normal Text.


How do you put a formula in Excel to calculate the 10 percent of any number?

If we say the numbers you want to get 10 percent of are always in cell A2, then you could use any of the following formulas: =A2*0.1 =A2*10% =A2/100*10


How would you calculate 10 percent of something in excel?

There are a few ways. Assuming the value you want 10% of is in cell A1, then in another cell you could use any of the following formulas: =A1*10% =A1/10 =A1*0.1 =A1/100*10


What is answer of antilog of -4.1?

Both for logs and antilogs, the base must be specified. Once you decide on your base, you can calculate that on any scientific calculator. Use the antilog function (base 10, or base e, if that's what you need), or calculate 10 to the power -4.1 (if you want a base-10 antilog), or e to the power -4.1 (if you want a base-e antilog), or some other base to this power. In Excel, you can use the power operator. For example, for 10 to the power -4.1 (that is, the antilog, base 10), type the following in an Excel cell: =10^-4.1


How do you put 10 to the 5 power in excel?

=10^5. You must put an equal sign before a mathematical expression, otherwise the cell will treat it as text and not actually calculate it. ^ (shift 6) is the symbol for exponents.


How can find top 10 performers in MS-Excel?

Quick and dirty I will do in two steps first rank based on the criteria then sort based on the ranking or lookup to the first 10 position L


How to make answer in Excel same as in my notes?

Second part of question :) in my notes : (4.6*10^12)=4.6*10^6 in excel : (4.6*10^12)=678196,411232349?


Is the difference between -20 and -10 equal to 10 or to -10 and why?

You can get the difference on your calculator, or in Excel. In Excel, the expression would be: = -10 - (-20) As to the "why", look at the numbers on a number line. That should help you visualize the situation.


What is the mass of a piece of metal that has a mass of 10 grams and volume of 2.5 mL?

Using those exact quantities, we can calculate that the mass is precisely 10 grams.