excel

  

Project Description:

You have just started working in the ticket office for a local theater. The theater has five different employees who take ticket orders over the phone. Until now, they have been taking the orders on paper and then retyping the information on an invoice. Jill, one of the employees, started an Excel workbook to enter the ticket orders in, but the other employees kept making mistakes and deleting the formulas, so they ended up retyping the invoices anyway. You will help Jill modify her workbook so data validation makes data entry easier, macros help clear all the data except the formulas, and various types of workbook protection prevent formulas from being deleted by mistake.