10.48 Tech Tool: Spreadsheet Software Software Video: Spreadsheet Controls EspressoCoffee has asked for your assistance in using formula auditing to improve spreadsheet controls.

1. Download the data file for this exercise.

2. Watch the software video for spreadsheet controls.

3. Use formula auditing with the spreadsheet data file to trace precedents for the cell labeled.

4. Identify any issues or errors. Print the spreadsheet. Clear precedents.

S. Use formula auditing with the spreadsheet data file to trace dependents for the cell labeled.

6. Identify any issues or errors. Print the spreadsheet. Clear dependents.

7. Use formula auditing to trace the error in the spreadsheet in the cell labeled.

8. Print the spreadsheet. How would you document the error? How would you fix this error?