Excel Test Fact Pattern 1

. Fact Pattern: Question 1: You shortly composition of work for an automotive parts supply store. Your come with is growing, and is considering expansion. The company currently has three locations (North, atomic number 16, and Central) in maven state, and fates to consider expanding within the identical state.  You have been presented with the sales figures for the sound three years for distributively of your locations. Based on this in clayation, youre assigned with analyzing current sales.   You have decided to investigate the trend in sales over the past(a) three years. Respond unspoilty to the following questions regarding this task:   A - (TCO 9) The entropy 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. formulate the steps involved in converting the information from the .csv files to Excel, and what steps you go forth deal to assure the selective information is usable. I would follow these steps: * unresolved Excel * Go to candid File and come on both .csv files * Open each and follow the Text issue 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 theyre more explicit.

B -  (TCO 2) Explain, based on corporeal covered in this class, your flack 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 mathematics 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 engross more time analyzing the data, since I would have to apply count UP fails. * I would commit the Pivot Table function to generate the tables so as to be able to soft apply the formulas to sum up the revenue for each location. C - (TCO 3) Explain how you will visually...If you want to get a full essay, order it on our website: OrderCustomPaper.com

If you want to get a full essay, visit our page: write my paper