Unformatted text preview: cells such
selection
as B5:B14 is called a range
range
Microsoft Office 2007Illustrated Introductory, Windows XP Edition Touring the Excel 2007
Window
Window
Name box and
current cell
address Open workbook Cell
pointer
Formula
bar Sheet tabs
Microsoft Office 2007Illustrated Introductory, Windows XP Edition Status bar Understanding Formulas
• Formulas are equations in a
worksheet
worksheet
• Excel formulas allow users at every
Excel
level of mathematical expertise to
make calculations with accuracy
make Microsoft Office 2007Illustrated Introductory, Windows XP Edition Understanding Formulas
• When creating calculations in Excel,
When
it is important to:
it
• Know where the formulas should be
• Know exactly what cells and arithmetic
Know
operations are needed
operations
• Create formulas with care
• Use cell references rather than values
• Determine what calculations will be
Determine
needed
needed
Microsoft Office 2007Illustrated Introductory, Windows XP Edition Understanding Formulas
Viewing a Formula
Formula
appears in
formula bar Result of
formula Microsoft Office 2007Illustrated Introductory, Windows XP Edition Understanding Formulas
Understanding
Excel arithmetic operators
Excel Microsoft Office 2007Illustrated Introductory, Windows XP Edition Entering Labels and Values
and Using AutoSum
• Labels contain text and numerical
information not used in calculations
information
• Labels help you identify data in
Labels
worksheet rows and columns
worksheet
• You should enter all the labels first
You
before entering other content
before • Values are numbers, formulas, and
functions that can be used in
calculations
calculations
Microsoft Office 2007Illustrated Introductory, Windows XP Edition Entering Labels and Values
and Using AutoSum
• A function is a builtin formula
function
• A function includes arguments, the
function
arguments the
information necessary for the
calculation
calculation • Clicking the AutoSum button sums
Clicking
the adjacent range above or to the
left, though you can adjust the range
left,
• The Fill button fills cells based on the
The
first number sequence in the range
first
Microsoft Office 2007Illustrated Introductory, Windows XP Edition Entering Labels and Values
and Using AutoSum
Creating a formula using the AutoSum button
AutoSum
button
Formula
Fill button Cells
included in
formula Microsoft Office 2007Illustrated Introductory, Windows XP Edition Editing Cell Entries
• You can change, or...
View
Full Document
 Fall '11
 Truell
 Windows XP, Windows XP Edition, Office 2007Illustrated Introductory

Click to edit the document details