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 .
Search JabSto ::




Custom Search