Microsoft Office Tutorials and References
In Depth Information
Creating formulas to calculate values
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 .
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.
In the Formula AutoComplete list, click SUM , and then press Tab to change the
contents of the formula bar to =SUM( .
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 .
In cell F10 , enter =SUM(C4:C5) , and then press Enter .
In cell D4 , enter =SUM($C$3:C4) and press Enter to add the formula to the cell.
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.
On the tab bar, click the JuneLabor sheet tab to display the JuneLabor worksheet.
In cell F13 , enter =SUM(J to display JuneSummary , the name of the table in the
JuneLabor worksheet, in the Formula AutoComplete list.
Press Tab to extend the formula to read =SUM(JuneSummary .
Enter [ , and then in the Formula AutoComplete list, click Labor Expense , and press
Tab to extend the formula to read =SUM(JuneSummary[Labor Expense .