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 Chapter10 practice
file folder to complete this exercise. Open the ITExpenses_start workbook, and save it
as ITExpenses. Then follow the steps.- If necessary, display the Summary worksheet. Then, in cell F9, type =C4, and
press Enter.
The value $385,671.00 appears in cell F9. - 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.- In the Formula AutoComplete list, click SUM, and then press Tab.
Excel changes the contents of the formula bar to =SUM(.- 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. - In cell F10, type =SUM(C4:C5), and then press Enter.
- 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. - In the formula box, select the cell reference C5, press F4, and then press Enter.
Excel changes the cell reference to $C$5.- On the tab bar, click the JuneLabor sheet tab.
The JuneLabor worksheet opens.- In cell F13, type =SUM(J.
Excel displays JuneSummary, the name of the table in the JuneLabor worksheet.- Press Tab.
Excel extends the formula to read =SUM(JuneSummary.Creating Formulas to Calculate Values 295