It gives you the amounts of combinations of numbers from a set of numbers. For example if you wanted to find how many combinations of 2 numbers can you get from 6 numbers you would do this:
=COMBIN(6,2)
It will give the result 15, because there are 15 combinations as follows, where we are getting combinations of 2 numbers from the numbers 1 to 6:
1,2
1,3
1,4
1,5
1,6
2,3
2,4
2,5
2,6
3,4
3,5
3,6
4,5
4,6
5,6
There is no built in function in Excel to create a list of combinations of 39 items taken 5 at a time. However, the combin function will tell you how many combinations there are. For instance, combin(39,5) = 575757.
5,245,786 Using MS excel input this: =COMBIN(42,6)
Nestor Combin was born on 1940-12-29.
ms excel 2010
The differences between them are not extensive so you can work in Excel 2010 easily if you are familiar with Excel 2007. You can save your files so that Excel 2007 will recognise them.
There are no hidden games in Microsoft Excel 2010. The last version that had a hidden game was in Excel 2000. There is a game called Billiards Excel and there are Billiard 2010 games, but these have nothing to do with Microsoft Excel, or any Microsoft software.
There is a lot to learn about Excel 2010. If you have never used any version of Excel, then a good course about it or even a good book will help. If you have used older versions of Excel, then you would not have much problem learning to use Excel 2010.
There are 1,048,576 rows and 16,384 columns in Excel 2010
switzerland
For detailed information on how to connect tabs in Excel 2010 spreadsheet visit keynotesupport.com/excel-basics/excel-linking-worksheets.shtml
Ctrl - C will copy in Excel 2010 and in other versions.
Not necessarily. You can have two versions of Excel on one computer.