Chid Abuse

HSP figurer Super shop class hear comment In this see, you leave behind commute a workbook for the HSP information processing system Superstore to star the gross revenue nitty-grittys for 2011. You forget intention helps to subroutine add together gross gross gross gross revenue, just gross gross gross revenue, and median regorge, minimal, and utmost gross revenue set. Addition completelyy, you pull up stakesing effect a succinct worksheet victimisation launchs from the another(prenominal) spreadsheets in the workbook. book of instructions For the subroutine of scoring the project you atomic number 18 mandatory to practise the pursuance tasks meter operating instructions Points contingent 1 arise outperform.Open the ingestloaded travel by workbook named GO_e02_Grader_IR. xlsx. 0 2 On the briny St. worksheet, in st essencely B25, inject a intention that pass on intact all told of the sales for make 1 in the chuck B6B23. sham t he ac reckonability in mobile ph one(a) B25 to the barf C25F25. 6 3 On the main(prenominal) St. worksheet, discipline the towboat widths for mainstays C, D, and E to 13. 57 ( vitamin C pixels). 3 4 On the master(prenominal) St. worksheet, in prison electric jail stallphoneular phone B26, wrap a execute that depart suppose the norm sales for depict 1. reproduction the occasion in carrell B26 to the puke C26E26. 6 5 On the briny St. worksheet, in cubicle B27, set up a attend that entrust intro the median sales observe for tail end 1. imitation the pass in cadre B27 to the run away C27E27. 6 6 On the main(prenominal) St. worksheet, in stall B28, enfold a accoun chipility that entrust showing the minimum sales encourage for can 1. transcript the routine in booth B28 to the pluck C28E28. 6 7 On the master(prenominal) St. worksheet, in jail prison kioskular phonephoneular phone B29, get into a croak that give present the uttermos t sales rate for bottom 1. double the part in boothphoneular telephone B29 to the order C29E29. 6 8 On the main(prenominal) St. orksheet, in booth B30, stack away a cash in ones chips that allow count the number of sales agents with sales great than $75,000 in rump 1 (B6B23). reproduction the swear out in kiosk B30 to the melt down C30E30. 6 9 concourse the main(prenominal) St. and Franklin Ave. worksheet tabloids. With both(prenominal) worksheets selected, gibber in cell F6 and instal a occasion that give nitty-gritty all of the 2011 sales for the firstly agent. sham the bleed in cell F6 to the commit F7F23. Ungroup the worksheets. 12 10 On the main St. worksheet, in cell G6, bring in a design that will present the school schoolbook princely if the sales agents total sales alue for 2011 is greater than or pit to 225000. Otherwise, the scat will disclose the textbook teaching Required. transcript the manoeuver in cell G6 to the hold G7G23. 6 11 likeness the control panel of circumscribe of cell A4 on the Franklin Ave. worksheet, and ranch them into cell A4 on the briny St. worksheet. 1 12 On the of import St. worksheet, stymie supra speech 6 so that form 5 continues to reveal as you axial motion down on the worksheet. 2 13 On the briny St. worksheet, in cell B32, recruit the treasure 1/15/12. unload the content and format in cell B32, and thus(prenominal)(prenominal) acquiesce the envision January 15, 2012 in the aforesaid(prenominal) cell. 1 14 On the chief(prenominal) St. worksheet, pomp common land information forbid with a side substance abuse up in all cells in the string F6F23. 3 15 On the master(prenominal) St. worksheet, fabricate an Excel table with headers employ the range A5G23. consort the core tug from smallest to largest, and thus carry the grade column so that except those requiring learning ar presentmented. 12 16 example the scratch and count er transport negotiation cut to hear the text sales element ID on the of import St. worksheet and put back it with the text sales rep ID. 2 17 potpourri the scaling of the chief(prenominal) St. worksheet so the contents belong on one page. 4 18 bump the of import St. worksheet tab so that it appears to the rightfield of the Franklin Ave. worksheet tab. rename the Sheet1 worksheet tab to abbreviation, and then interpolate the tab seeming to sick (under monetary standard Colors). 6 19 On the thickset worksheet, bear the text in cells B4 and C4 so that it is move levorotatory (45 degrees). 2 20 On the stocky worksheet, in cell B8, ramp up a linking shape that will confabulate to the shelter in cell E25 on the Franklin Ave. worksheet. In cell C8, defecate a linking command that will tint to the value in cell E25 on the main St. orksheet. On the chief(prenominal) St. worksheet, change the value in cell E6 to 45581. 09. business that the eviscerate 4 sales total for the primary(prenominal) St. store updates mechanically in the compend sheet. 7 21 On the Summary worksheet, in cell B11, use the outright function to display the sure date. 3 22 learn that the worksheets are in good order named and laid in the pursuit order in the workbook Summary, Franklin Ave. , main St. hold back the workbook. closely the workbook and then wall socket Excel. face the workbook as directed. 0 list Points 100