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.
5. 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?
We need at least 10 more requests to produce the solution.
0 / 10 have requested this problem solution
The more requests, the faster the answer.