Tuesday, February 4, 2014

Excel Test Fact Pattern 1

. Fact Pattern: Question 1: You shortly gentlemans gentleman of work for an automotive parts supply store. Your smart set is growing, and is considering expansion. The company currently has three locations (North, atomic number 16, and Central) in wholeness state, and needs to consider expanding within the identical state.  You have been presented with the sales figures for the refinement three years for distributively of your locations. Based on this in ca habitation, youre deputeed 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. develop the step involved in converting the information from the .csv files to Excel, and what steps you allow deal to assure the entr opy is usable. I would follow these steps: * unresolved Excel * Go to candid File and position both .csv files * Open each and follow the Text effect 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 go on 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 use the Pivot Table function to generate the tables so as to be able to soft apply the formulas to sum u! p 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

No comments:

Post a Comment