Excel Timed Tutorial

1. (TCOs 2, 3, 7, 9) You currently work for an automotive parts supply store. Your company is growing and is considering expansion. The company currently has three locations (North, South, and Central) in one state and wants to consider expanding within the same state. You have been presented with the sales figures for the last three years for each of your locations. Based on this information, you’re tasked with analyzing current sales.
You have decided to investigate the trend in sales over the past three years. Respond fully to the following questions regarding this task:
A – (TCO 9) The data for the North and Central locations has been provided to you in the form of .csv files. The South location information is in an Excel file. Explain the steps involved in converting the information from the .csv files to Excel, and what steps you will take to ensure the data is usable.
B – (TCO 2) Explain, based on material covered in this class, your approach to setting up your worksheet and organizing the data.
C – (TCO 3) Explain how you will visually represent the data for the sales of the individual stores and for the time period shown. You want to show the change in sales for each store over time for the past three years.
D – (TCO 7) Once you have finished the above tasks, you plan to send the Excel workbook to your boss for evaluation. Your boss is not an Excel expert, and you are concerned that your formulas might accidentally be deleted or altered. Describe the methods you will use to ensure that this does not happen. (Points : 40)    

3. (TCOs 1, 2, 4) 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 costs of the party are the same for every attendee. When the employees respond, you want to add their names to the list. If they are not coming, you want this recorded. If they are coming alone, the cost is $45. If they are bringing a guest, the cost is $45 X 2. 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 cost for a guest), and to calculate the total cost of the party.
B – (TCO 2) The facility where the party is to be held will give the company a reduction in price if more than 75 people attend. The price per person will then be $40. Describe how you will set up your worksheet to reflect a change when the total number of attendees hits 75.
C – (TCO 4) You want the employees who are going to attend to show up on the list with a yellow background. Explain the method you would use to have this automatically occur when you indicate the employee’s response.
D – (TCO 4) You know your management team will want to periodically check to see who is attending. They are not concerned with those who have responded but are not attending. Explain how you might generate this list as requested using your knowledge of Excel. (Points : 40)