Excel
2003 is a spreadsheet application that allows you to enter, calculate, and
analyze data. Anything related to crunching numbers can be handled easily using
Excel. You can use Excel for a variety of tasks such as managing a budget,
creating a loan analysis, keeping track of inventory, or totaling annual sales.
You can even create charts to illustrate compiled data.
Section
Objectives
In this section, you
will learn about Excel's basic elements, including workbooks, worksheets,
menus, and toolbars. You will enter and edit text and numbers, create formulas
and functions, and move and copy data. You will also use a variety of
formatting tools and techniques to change the appearance of your work, create a
chart, and prepare to print your work. Here
is a summary of the skills you will learn:
- Navigating
Workbooks
- Entering
And Editing Data
- Using
Formulas And Functions
- Using
Relative And Absolute References
- Moving
And Copying Data
- Formatting
Numbers And Text
- Applying
Borders And Shading
- Creating
And Modifying Charts
- Printing
Worksheets
Understanding Formulas
Formulas
are mathematical equations that calculate new values from existing values. They
allow you to use symbols called operators to add (+), subtract (-), multiply
(*), and divide (I) numbers.
Each
formula should begin with an equal (=) sign. The equal sign tells Excel that
everything in the cell is part of a formula. For example, if you select a cell
in a worksheet and type =18+4, Excel will add 18 and 4 to equal a sum of 22.
Formulas
can contain more than just numbers. They can also contain cell references. For
example, if you type =B7/C7, Excel will divide the value in cell B7 by the
value in cell C7. Using cell references instead of numbers is a good idea
because Excel automatically recalculates formulas if the value in a cell
changes.
You
should also remember that when you enter a formula into a cell or select a cell
that contains a formula, Excel displays the formula in the Formula Bar and the
result of the formula in the cell.
Formulas can also start with an addition (+) or
subtraction (-) sign. The addition sign tells Excel that the following number
or cell reference is positive. The subtraction sign tells Excel that the
following number or cell reference is negative.
|
Formula
|
A formula is a sequence of values, cell
references, and operators that produces a new value from existing values. A
formula should start with an equal sign.
|
|
Value
|
A value is a number, usually resulting
from a formula.
|
|
Operators
|
Operators are symbols used to perform
calculations in formulas. The standard operators used in Excel are +
(addition), - (subtraction), * (multiplication), and / (division).
|
|
Cell Reference
|
A cell reference, or cell address,
identifies a particular cell, such as cell D12. Cell references are used in
formulas to indicate where a value is stored.
|
|
Order Of Precedence
|
The order of precedence is the order in
which Excel calculates a formula.
|
