Your company is planning a party for employees, and you have been asked to set up a spreadsheet to track the attendees and to calculate 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 varies depending on the total number of attendees. The cost is $50 per person for 1 though 50 attendees. Cost drops to $45 per person if more than 50 attend. When the employees respond, you want to add their names to the list, indicate whether they will attend, and indicate whether they will bring a guest. Respond fully to the following questions regarding this task:
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.
2)Congratulations on your new position as loan officer at the Commercial Bank and Trust Company. You are dedicated to building long-term relationships with your clients, and you want to be able to answer their questions quickly if they call after obtaining a loan. The bank's system is a little slow, so you have started your own list of information frequently needed by your client. You are aware that it is extremely important that the customer's information be protected.
You process automobile loans for the bank's customers. The interest rate varies depending on the customer's credit score. Once you know the credit score, you use the associated rate to calculate the loan payment. You then store the customer's information including the payment date and the payment amount in your list for quick reference. Respond fully to the following questions regarding this task:
A - (TCO 2) You have set up an Excel worksheet to determine the loan payment. It is set up so that you enter the credit score, and it finds and returns the correct interest rate. Then, you enter the interest rate and other required information to get the actual payment. Describe the Excel tools used for these tasks, and the information required to obtain the payment.
B - (TCO 10) You know that your list of information on the loans will quickly become very long. Also, you want to be sure that you are not repeating information, and that you can't easily give out wrong information. You would like to be able to view one single record at a time to keep this from happening. A friend has suggested that you build your list in Access. What would be the benefit of doing this, particularly in the banking environment?
C - (TCO 10) You want to use the Access form wizard to create an input form for your list. Describe the process of creating the form, and the special tools you might use to make it easier to use and less prone to errors.
D - (TCO 10) You have decided that you would like to contact your customers by phone at least once a year to maintain the relationship. Explain how you would obtain a list of loans with anniversary dates in a particular month, and then print the information for your use in making these calls. Be specific!