A recent issue of Database Trends and Applications magazine quoted a Forrester Research study that found 80% of database installations only use 20% of the features provided. My estimation is that this statistic also applies to other software, especially some of the most "popular" used and required on home, school, and office PCs. And this is a large aspect of why open source software should be used, encouraged, and by no means discriminated against in the public arena.
Let's avoid any anti-Windows or anti-Microsoft propaganda or personal preference. Anyone who knows me, already knows my personal preference for Ubuntu Linux anyhow. I'm going to focus briefly on the MS Office suite of applications, because as we know it is the dominant software in this arena.
My wife does things with MS Office at work that would make most people's head spin. She needs and uses the power, APIs, and scripting that it provides. She justifies the $X for her corporate license for Access, Word, Excel, etc. At home, she uses a word processor, rarely, for basic documents and a spreadsheet for rosters with name, address, etc. There is no justifying the expense of MS Office for home. She will occasionally use the old copy of Office97 from our college days, but our primary productivity software is OpenOffice.org. For me, running a Linux desktop, it's always OpenOffice or other open software.
If a corporation decides to buy a corporate license for MS Office or other proprietary productivity software, that's fine by me. When a government spends tax money on licenses for employees who don't use/need the added functionality, it's misuse of resources.
When a public school requires students to use MS Office to read an assignment downloaded from the Internet or as the only format for submitted assignments, there is a problem and an unfair bias toward students who can afford home computers and more over the MS Office software. This irks me. Of course OpenOffice can read/write to MS Office formats, so those "in the know" are OK (most of the time) but the majority of educators do not know this and if they do it is not taught or explained to students.
Teach students fundamentals, not memorized specifics, so that they can rapidly adapt and learn a variety of tools. I have seen countless times educators and students alike turn aside from alternative software options because it's "not the same," "too different," "too hard." The fundamental differences in MS Office and OpenOffice are negligible, and in my opinion, no more difficult to grasp than when MS Office dropped the menu bar and got all decorated with ribbons and bows. Users adapted to the changes due to necessity. It is no more difficult to adapt to another office suite.
The principle of cost vs features vs needed features vs compatibility, should be looked at in all organizations from small to large corporations, schools, governments, churches, and non-profits.
My point in all this is use the software you need for the job your performing and don't force others into your boat when another (potentially free) option will work equally well.