Microsoft Office Tutorials and References

In Depth Information

In this exercise, you’ll create a formula manually, revise it to include additional cells,

create a formula that contains an Excel table reference, create a formula with relative

references, and change the formula so it contains absolute references.

SET UP
You need the ITExpenses_start workbook located in your Chapter03 practice

file folder to complete this exercise. Open the ITExpenses_start workbook, and save it

as
ITExpenses
. Then follow the steps.

1.
If necessary, display the
Summary
worksheet. Then, in cell
F9
, type
=C4
, and

press Enter.

The value
$385,671.00
appears in cell F9.

2.
Select cell
F9
and type
=SU
.

Excel erases the existing formula, and Formula AutoComplete displays a list of

possible functions to use in the formula.

3.
In the
Formula AutoComplete
list, click
SUM
, and then press Tab.

Excel changes the contents of the formula bar to
=SUM(
.

4.
Select the cell range
C3:C8
, type a right parenthesis (
)
) to make the formula

bar’s contents
=SUM(C3:C8)
, and then press Enter.

The value
$2,562,966.00
appears in cell F9.

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

6.
Select cell
F10
, and then in the formula box, select the cell reference
C4
, and

press F4.

Excel changes the cell reference to
$C$4
.

7.
In the formula box, select the cell reference
C5
, press F4, and then press Enter.

Excel changes the cell reference to
$C$5
.

8.
On the tab bar, click the
JuneLabor
sheet tab.

The JuneLabor worksheet opens.

9.
In cell
F13
, type
=SUM(J
.

Excel displays JuneSummary, the name of the table in the JuneLabor worksheet.

10.
Press Tab.

Excel extends the formula to read
=SUM(JuneSummary
.