Excel Test Fact Pattern 1

. Fact Pattern: Question 1: You shortly atom of work for an automotive parts supply store. Your gild is growing, and is considering expansion. The company currently has three locations (North, atomic number 16, and Central) in i state, and destinys to consider expanding within the identical state.  You have been presented with the sales figures for the cultivation three years for distributively of your locations. Based on this in shitation, 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. apologise the go involved in converting the information from the .csv files to Excel, and what steps you bequeath deal to assure the selective information is usab le. I would follow these steps: * unresolved Excel * Go to candid File and adjudicate both .csv files * Open each and follow the Text moment 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 approach path to setting up your worksheet and organizing the data. * I would determine which location generated the largest revenue, by compiling the columns so tha t I may apply maths 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 practice session 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