Excel 2010重命名和功能的改善
Renamed and Improved Functions in Excel 2010
Business Analysis with Microsoft Excel has never been intended as a version book—that is, it has never been issued as a new edition every time Microsoft issues a new version of Excel.
You are reading the book’s fourth edition, yet Excel has had seven separate releases (not counting service releases) since this book was first published.
The third edition took the Excel 2007 user interface, most recognizable by the Ribbon, into account in describing how to carry out various analyses in Excel. The current edition does the same, but it describes your actions first using the Ribbon, and then describes them assuming that you’re using the menu structure from Excel 1997–2003.
The most recent version, Excel 2010, has a variety of functions with new names, which are mainly existing functions whose capabilities have been divided among new functions. Most are statistical functions pertaining to the unit normal distribution, the t distribution, the F distribution and so on .
For example, the existing TDIST function returns a one- or a two-tailed test, depending on how the user sets one of its arguments. Which tail of the distribution can be specified by subtraction, because the distribution is symmetric.
The new functions divide the capabilities among three different functions: T.DIST (onetail, left), T.DIST.RT (one-tail, right), and T.DIST.2T (two-tail). The capabilities were always there, but Excel 2010 assigns them specifically instead of relying on arguments and arithmetic manipulation such as 1 – TDIST(2.07, 15, 2) .
This book takes account of the new functions and uses them where appropriate. There are three issues to bear in mind, discussed next.