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