Microsoft Office Tutorials and References
In Depth Information
1. Calculate the Total Sales in cell D2.
2. Double-click on the drag handle in D2 to calculate the rest of the values in
3. Calculate the Sales Tax in column E, using I1 as an absolute address.
4. Calculate the lowest, highest, and average for each of the columns.
1. See the results and the formulas: