0
=MODE(B2:B10) will give you the most commonly occurring number in that range of cells, if one number occurs more than any other number. If no number occurs more than once, it gives an error. If several numbers occur more than once and the same amount of times as each other, then it will return the first one that occurs most often.
Wiki User
∙ 9y ago
Add your answer:
Earn +20 pts
What would the function MODE in Excel tell us?
The MODE function finds the most commonly occurring number in a range of numbers.
How can you tell if your converted csv to Excel file is useable?
You would have to open it in Excel and see what happens.
How do you find what version of Microsoft Excel you have?
Go to the Help menu and look at the About option which will tell you. The version of Excel you have is linked to the version of Office you have. If you know what version of Office you have, then you know what version of Excel you have.
How do you program an Excel spreadsheet to update when changes are made?
This is the default behavior in most (all?) versions of Excel. You have to go out of your way to tell a spreadsheet NOT to do this.
How do Microsoft Word Excel and PowerPoint support the work force?
AS computer is very important for us .like the same way Excel AND PowerPoint helps us a lot Excel help us for calculations like taking out averages , percentage,addition subtraction e.t.c , and PowerPoint helps us to make presentation on multifarious topics
Where can I find affordable Excel Training?
You can get a free Excel course at http://www.ozgrid.com/Excel/free-training/basic-index.htm or you can choose the Microsoft course at http://office.microsoft.com/en-us/training/CR061831141033.aspx. Microsoft offers Excel training for free at http://office.microsoft.com/en-us/training/CR100479681033.aspx. You can also find many Excel training videos on Youtube.com.
Is gano excel growing in US?
Absolutely! It is growing everyday.
What is a Tool tip in Excel?
If you place the mouse over an icon, it will tell you what it is. This is a tool tip.
How many excel users in the US?
More than 50 millions.
What format does us bank statement display in?
excel spread sheet
Where could I find an amortization calculator for excel?
You may find an amortization calculator for excel at http://office.microsoft.com/en-us/excel-help/using-the-loan-amortization-and-loan-analysis-templates-HA001034640.aspx.
Where can I sign up for excel training online?
Here's a great site to sign up for online excel training: office.microsoft.com/en-us/training/cr061831141033.aspx
