Natasha
Natasha Exam
1. (TCOs 2, 3, 7, and 9) You currently work for a home improvement store. Your company continues to grow, and is considering expansion scenarios. The company currently has three locations (East, West, and Central) in one state, and wants to consider expanding within the same state. Your boss has presented you with the sales figures for the last three years for each of the locations. Based on this information, you have been tasked with analyzing current sales and providing recommendations.
You have reviewed the initial data and decided to compare the performance of the three stores to get a better idea of where expansion might be most beneficial. Respond fully to the following questions regarding this task.
• A - (TCO 9) The data has been provided to you in one .csv file showing weekly sales for all three stores for the last three years. Explain the tasks you must complete in preparing the data for your analysis.
• B - (TCO 2) Explain, based on material covered in this class, your approach to setting up your worksheet and organizing the data. Remember that you have only weekly sales totals for each store in the data.
• C - (TCO 3) Explain how you will visually represent the comparison of the total annual sales at the individual stores for each of the three years. Describe methods to make your strongest performing store stand out.
• D - (TCO 7) Once you have finished the above tasks, your Excel workbook will be placed on your company server so that all of the managers can view it. You know that they may have questions regarding your work, and want them to know that you created the workbook so that they can contact you. Describe how you will convey the information regarding worksheet creation
2. (TCOs 4, 6, 7 and 8) You own your own computer repair business. You maintain an Excel list of clients who have contacted you for repairs in the past two years and a referral list for potential customers. The list includes both physical mailing
1. (TCOs 2, 3, 7, and 9) You currently work for a home improvement store. Your company continues to grow, and is considering expansion scenarios. The company currently has three locations (East, West, and Central) in one state, and wants to consider expanding within the same state. Your boss has presented you with the sales figures for the last three years for each of the locations. Based on this information, you have been tasked with analyzing current sales and providing recommendations.
You have reviewed the initial data and decided to compare the performance of the three stores to get a better idea of where expansion might be most beneficial. Respond fully to the following questions regarding this task.
• A - (TCO 9) The data has been provided to you in one .csv file showing weekly sales for all three stores for the last three years. Explain the tasks you must complete in preparing the data for your analysis.
• B - (TCO 2) Explain, based on material covered in this class, your approach to setting up your worksheet and organizing the data. Remember that you have only weekly sales totals for each store in the data.
• C - (TCO 3) Explain how you will visually represent the comparison of the total annual sales at the individual stores for each of the three years. Describe methods to make your strongest performing store stand out.
• D - (TCO 7) Once you have finished the above tasks, your Excel workbook will be placed on your company server so that all of the managers can view it. You know that they may have questions regarding your work, and want them to know that you created the workbook so that they can contact you. Describe how you will convey the information regarding worksheet creation
2. (TCOs 4, 6, 7 and 8) You own your own computer repair business. You maintain an Excel list of clients who have contacted you for repairs in the past two years and a referral list for potential customers. The list includes both physical mailing