Your company is planning a party for employees and you have been asked to set up a spreadsheet to track the attendees and to find out the associated cost. Each employee is allowed to bring one guest to the party. There are 50 employees in your company. The spreadsheet needs to be set up when the invitations are distributed so that you can begin recording the reservations as soon as they come in.

The cost of the party is not the same for the employee and the guest. The charge for an employee is $50, and the charge for a guest is $45. When the employee responds that he or she plans to attend, you want to add his or her name to the list. If the employee is not coming, then his or her name is not recorded. Respond fully to the following problems regarding this task: