Microsoft Office Tutorials and References

In Depth Information

**Answers**

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

column D.

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.

ANSWERS

1.
See the results and the formulas: