A - (TCO 1) Explain how you will structure your worksheet, including the titles, column headings, the formulas to calculate the cost for each employee (which may include the cost for a guest, and to calculate the total cost for the party). The company wants to record the names of the guests so that name tags can be made.
B - TCO 2) The facility where the party is to be held will provide one free parking pass to each employee. They will provide each attendee (employee or guest) a complimentary beverage if the total number of attendees exceeds 75. Describe how you will set up your worksheet to automatically provide the numbers for parking passes and for drinks as the responses are entered. 
C - (TCO 4) You want the employees who are not going to attend to show on the list with a blue background. Explain the method you would use to have this automatically occur when you indicate the employee’s response. 
D - (TCO 4) The party is by invitation only, and the hotel is going to provide a doorperson to check those who reserved a spot as they come through the entrance. You need to generate the list of attendees from your worksheet. Explain how you will do this.