Introducing Microsoft Excel 2010
For those of you who are upgrading to Microsoft Excel 2010 from an earlier version
of the program, this introduction summarizes the new features in Excel 2010. One of
the first things you’ll notice about Excel 2010 is that the program incorporates the
ribbon, which was introduced in Excel 2007. If you used Excel 2003 or an earlier version
of Excel, you’ll need to spend only a little bit of time working with the new user
interface to bring yourself back up to your usual proficiency.
Managing Excel Files and Settings
in the Backstage View
If you used Excel 2007, you’ll immediately notice one significant change: the Microsoft
Office button, located at the top left corner of the program window in Excel 2007, has
been replaced by the File tab. After releasing the 2007 Microsoft Office System, the Office
User Experience team re-examined the programs’ user interfaces to determine how they
could be improved. During this process, they discovered that it was possible to divide user
tasks into two categories: “in” tasks, such as formatting and formula creation, which affect
the contents of the workbook directly, and “out” tasks, such as saving and printing, which
could be considered workbook management tasks.
When the User Experience and Excel teams focused on the Excel 2007 user interface, they
discovered that several workbook management tasks were sprinkled among the ribbon
tabs that contained content-related tasks. The Excel team moved all of the workbook
management tasks to the File tab, which users can click to display these commands in
the new Backstage view.
Previewing Data by Using Paste Preview
One of the most common tasks undertaken by Excel users involves cutting or copying
a worksheet’s contents, such as text or numbers, and pasting that data into either the
same workbook or a separate Office document. Users have always been able to paste
data from the Microsoft Office Clipboard and control which formatting elements were
pasted into the destination; however, in versions prior to Excel 2010, you had to select
a paste option, observe the results, and (often) undo the paste and try another option
until you found the option that produced the desired result.
In Excel 2010, you can take advantage of the new Paste Preview capability to see how
your data will appear in the worksheet before you commit to the paste. By pointing to
any of the icons in the Paste Options palette, you can switch between options to discover
the one that makes your pasted data appear the way you want it to.
Troubleshooting The appearance of buttons and groups on the ribbon changes depending
on the width of the program window. For information about changing the appearance of
the ribbon to match our screen images, see “Modifying the Display of the Ribbon” at the
beginning of this book.
Customizing the Excel 2010 User Interface
When the Office User Experience team designed the ribbon interface for Excel 2007, they
allowed users to modify the program window by adding and removing commands on the
Quick Access Toolbar. In Excel 2010, you can still modify the Quick Access Toolbar, but you
also have many more options for changing the ribbon interface. You can hide or display
built-in ribbon tabs, change the order of built-in ribbon tabs, add custom groups to a
ribbon tab, and create custom ribbon tabs which, in turn, can contain custom groups.
These custom groups provide easy access to existing ribbon commands as well as
custom commands that run macros stored in the workbook
Summarizing Data by Using More Accurate
Functions
In earlier versions of Excel, the program contained statistical, scientific, engineering,
and financial functions that would return inaccurate results in some relatively rare
circumstances. For Excel 2010, the Excel programming team identified the functions
that returned inaccurate results and collaborated with academic and industry analysts
to improve the functions’ accuracy.
The Excel team also changed the naming conventions used to identify the program’s
functions. This change is most noticeable with regard to the program’s statistical functions.
The table below lists the statistical distribution functions that have been improved
in Excel 2010.
Distribution Functions
Beta BETA.DIST, BETA.INV
Binomial BINOM.DIST, BINOM.INV
Chi squared CHISQ.DIST, CHISQ.DIST.RT, CHISQ.INV, CHISQ.INV.RT
Exponential EXPON.DIST
F F.DIST, F.DIST.RT, F.INV, F.INV.RT
Gamma GAMMA.DIST, GAMMA.INV
Hypergeometric HYPGEOM.DIST
Lognormal LOGNORM.DIST, LOGNORM.INV
Negative Binomial NEGBINOM.DIST
Normal NORM.DIST, NORM.INV
Standard Normal NORM.S.DIST, NORMS.INV
Poisson POISSON.DIST
Student’s t T.DIST, T.DIST.RT, T.DIST.2T, T.INV, T.INV.2T
Weibull WEIBULL.DIST
Excel 2010 also contains more accurate statistical summary and test functions. The following
table lists those functions, as well as the new naming convention that distinguishes between
new and old functions. The Excel programming team chose to retain the older functions to
ensure that workbooks created in Excel 2010 would be compatible with workbooks created
in previous versions of the program.
Function name Description
CEILING.PRECISE Consistent with mathematical definition; rounds up towards positive
infinity regardless of sign of number being rounded
FLOOR.PRECISE Consistent with mathematical definition; rounds down towards
negative infinity regardless of sign of number being rounded
CONFIDENCE.NORM Name for existing CONFIDENCE function that is internally consistent
with naming of other confidence function
CONFIDENCE.T Consistent definition with industry best practice;. confidence function
assuming a Student’s t distribution
COVARIANCE.P Name for existing COVAR function that is internally consistent with
naming of other covariance function
COVARIANCE.S Internally consistent name with other functions that act on a
population or a sample
MODE.MULT Consistent with user expectations; returns multiple modes for a range
MODE.SNGL Name for existing MODE function that is internally consistent with
naming of other mode function
PERCENTILE.EXC Consistent with industry best practices, assuming percentile is a
value between 0 and 1, exclusive
PERCENTILE.INC Name for existing PERCENTILE function that is internally consistent
with naming of other percentile function
Function name Description
PERCENTRANK.EXC Consistent with industry best practices; assuming percentile is a
value between 0 and 1, exclusive
PERCENTRANK.INC Name for existing PERCENTRANK function that is internally consistent
with naming of other PERCENTRANK function
QUARTILE.EXC Consistent with industry best practices, assuming percentile is a
value between 0 and 1, exclusive
QUARTILE.INC Name for existing QUARTILE function that is internally consistent
with naming of other quartile function
RANK.AVG Consistent with industry best practices, returning the average rank
when there is a tie
RANK.EQ Name for existing RANK function that is internally consistent with
naming of other rank function
STDEV.P Name for existing STDEVP function that is internally consistent with
naming of other standard deviation function
STDEV.S Name for existing STDEV function that is internally consistent with
naming of other standard deviation function
VAR.P Name for existing VARP function that is internally consistent with
naming of other variance function
VAR.S Name for existing VAR function that is internally consistent with
naming of other variance function
CHISQ.TEST Name for existing CHITEST function that is internally consistent with
naming of other hypothesis test functions
F.TEST Name for existing FTEST function that is internally consistent with
naming of other hypothesis functions
T.TEST Name for existing TTEST function that is internally consistent with
naming of other hypothesis functions
Z.TEST Name for existing ZTEST function that is internally consistent with
naming of other hypothesis functions
It is possible in Excel 2010 to create formulas by using the older functions. The Excel
team assigned these functions to a new group called Compatibility Functions. These
older functions appear at the bottom of the Formula AutoComplete list, but they are
marked with a different icon than the newer functions. Additionally, the tooltip that
appears when you point to the older function’s name indicates that the function is
included for backward compatibility only
المادة المعروضة اعلاه هي مدخل الى المحاضرة المرفوعة بواسطة استاذ(ة) المادة . وقد تبدو لك غير متكاملة . حيث يضع استاذ المادة في بعض الاحيان فقط الجزء الاول من المحاضرة من اجل الاطلاع على ما ستقوم بتحميله لاحقا . في نظام التعليم الالكتروني نوفر هذه الخدمة لكي نبقيك على اطلاع حول محتوى الملف الذي ستقوم بتحميله .
|