The athletic director at the local high school has been given a worksheet to track revenue and expenses on a trial basis for the next six months. He is not computer literate and is hesitant to use the workbook on a regular basis, so he has asked you to help modify the workbook so he knows exactly what to enter and the chances of deleting important formulas is minimized as much as possible. You will create validation rules, and macros to make data entry as simple as possible. Then you will protect the worksheet, as well as hide all the formulas, so the chance of deleting critical cells is minimized. Finally, you will mark the workbook as final so when you send it to the athletic director, he knows it is the version he should be using.
Looking for a Similar Assignment? Order now and Get 20% Discount! Use Code GET20