Microsoft Office Tutorials and References

In Depth Information

**Creating formulas to calculate values**

1

If necessary, display the
Summary
worksheet. Then, in cell
F9
, enter
=C4
, and press

Enter
to create the formula and display the value
$385,671.00
in cell
F9
.

2

Select cell
F9
and enter
=SU
to erase the existing formula and display the
Formula

AutoComplete
list, which contains possible functions to use in the formula.

3

In the
Formula AutoComplete
list, click
SUM
, and then press
Tab
to change the

contents of the formula bar to
=SUM(
.

4

Click cell
C3
, press
Ctrl+Shift+Down Arrow
to extend the selection to cell
C8
,

enter
)
(a closing parenthesis) to make the formula bar’s contents
=SUM(C3:C8)
,

and then press
Enter
to display the value
$2,562,966.00
in cell
F9
.

3

5

In cell
F10
, enter
=SUM(C4:C5)
, and then press
Enter
.

6

In cell
D4
, enter
=SUM($C$3:C4)
and press
Enter
to add the formula to the cell.

7

Click cell
D4
and then drag the cell’s ill handle until the selection covers cell
D8
. The

formulas keep the cell reference
$C$3
absolute, but change the second cell reference

to reflect the new cells’ positions relative to the original formula.

8

On the tab bar, click the
JuneLabor
sheet tab to display the
JuneLabor
worksheet.

9

In cell
F13
, enter
=SUM(J
to display
JuneSummary
, the name of the table in the

JuneLabor
worksheet, in the
Formula AutoComplete
list.

10

Press
Tab
to extend the formula to read
=SUM(JuneSummary
.

11

Enter
[
, and then in the
Formula AutoComplete
list, click
Labor Expense
, and press

Tab
to extend the formula to read
=SUM(JuneSummary[Labor Expense
.