Microsoft Office Tutorials and References
In Depth Information
Create a Formula
EXCEL
chapter 11
Working with Formulas and Functions
4 Type an operator for the formula.
5 Click the next cell that you want to
reference in the formula.
Excel inserts the cell reference into the
formula.
6 Repeat Steps and until all the 5
necessary cells and operators have
been added.
7 Press
5
4
.
You can also click Enter ( ) on the
Formula bar to accept the formula.
You can click Cancel (
) to cancel the
formula.
The formula results appear in the cell.
To view the formula in the Formula bar,
you can simply click in the cell.
The Formula bar displays any formula
assigned to the active cell.
Note:
If you change a value in a cell referenced in your
formula, the formula results automatically update to reflect
the change.
How do I edit a
formula?
To edit a formula,
click in the cell
containing the
formula and make
any corrections in
the Formula bar.
You can also
double-click in the cell to make edits to
the formula from within the cell itself.
When finished, press
Can I reference cells in other
worksheets?
Yes. To reference a cell in other
worksheet, you specify the
worksheet name followed by an
exclamation mark and then the cell
address (Sheet2!D12). If the
worksheet has been renamed to,
say, Sales, you must use the name
along with an exclamation mark followed by the cell or
range reference (Sales!D12). If the worksheet name
includes spaces, enclose the sheet name in single quote
marks, as in ‘Sales Totals’!D12.
R e g i o n a l S a l e s
R e g i o n a l S a l e s
R e g i o n a l S a l e s
1
2
1
2
3
3
4
4
5
5
6
6
or click
Enter (
) on the Formula bar.
191
 
Search JabSto ::




Custom Search