# Excel Test Fact Pattern 1 Essay

646 Words3 Pages
. Fact Pattern: Question 1: 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 assure the data is usable. I would follow these steps: * Open Excel * Go to “Open File” and locate both .csv files * Open each and follow the “Text Import Wizard” so that columns are tab delimited * I would then look at the converted files and assure that the data is manageable, eliminating empty columns and also re-naming columns so that they’re more explicit. B - (TCO 2) Explain, based on material covered in this class, your approach to setting up your worksheet and organizing the data. * I would determine which location generated the largest revenue, by compiling the columns so that I may apply math formulas (i.e. SUM). I would compile the data for all three locations into a single spreadsheet, with the columns clearly labeled. I could have the data in different sheets, but would consume more time analyzing the data, since I would have to apply LOOK UP functions. * I would use the Pivot Table function to generate the tables so as to be able to easily apply the