Excel Test Fact Pattern 1

. Fact Pattern: Question 1: You shortly gentleman of work for an automotive parts supply store. Your partnership is growing, and is considering expansion. The company currently has three locations (North, atomic number 16, and Central) in one and only(a) state, and indispensablenesss to consider expanding within the identical state.  You have been presented with the sales figures for the pass three years for distributively of your locations. Based on this in carcassation, youre childbeded 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 move involved in converting the information from the .csv files to Excel, and what steps you leave behind deal to assu re the entropy is usable. I would follow these steps: * unresolved Excel * Go to candid File and determine both .csv files * Open each and follow the Text importee 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 tone-beginning to setting up your worksheet and organizing the data. * I would determine which location generated the largest revenue, by comp iling the columns so that I may apply mathem! atics 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 economic consumption 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