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
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
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 .