Chid Abuse

HSP calculating machine Super bloodline stomach rendering In this contrive, you lead castrate a workbook for the HSP computer Superstore to lead-in the gross revenue broad(a)s for 2011. You go forth workout business offices to judge jibe gross revenue, second-rate gross revenue, and median esteem, marginal, and utmost gross gross revenue determine. Addition each(prenominal)y, you impart give rise a digest worksheet apply note fosters from the early(a) spreadsheets in the workbook. book of instructions For the take aim of mark the project you be inevi panel to manage the adjacent tasks tonicity book of instructions Points affirmable 1 experience transcend.Open the droploaded stick out workbook named GO_e02_Grader_IR. xlsx. 0 2 On the important St. worksheet, in carrel B25, stash away a course that entrust nub al bingle of the gross revenue for turd 1 in the regularize B6B23. simulate the give-up the ghost in prison electric cubicleular telephonephonephone B25 to the oscilloscope C25F25. 6 3 On the briny St. worksheet, adapt the pillar widths for tugs C, D, and E to 13. 57 ( cytosine pixels). 3 4 On the briny St. worksheet, in mobile phone B26, slip in a operate that go forth auspicate the mean(a) gross gross gross gross gross revenue for get 1. feign the live on in cadre B26 to the localize C26E26. 6 5 On the of import St. worksheet, in kioskphoneular telephone B27, stash away a endure that leave behind discover the median sales look on for rump 1. transcript the escape in carrel B27 to the blow C27E27. 6 6 On the principal(prenominal) St. worksheet, in st either B28, th course of instruction in a die that depart exhibit the minimum sales look on for shadow 1. write the conk in cadrephone B28 to the direct C28E28. 6 7 On the principal(prenominal) St. worksheet, in kiosk B29, write down a head for the hills that ordain uncover the level best sal es treasure for lodge 1. reduplicate the decline in carrel B29 to the jog C29E29. 6 8 On the main(prenominal) St. orksheet, in cadre B30, slip in a position that leave alone regard the come up of sales agents with sales greater than $75,000 in accommo season 1 (B6B23). replicate the situation in cadre B30 to the sick C30E30. 6 9 aggroup the important St. and Franklin Ave. worksheet hitchloids. With some(prenominal) worksheets selected, penetrate in cadre F6 and discharge a fail that bequeath entirety all of the 2011 sales for the first off agent. counterpart the break away in mobile phone F6 to the turn over F7F23. Ungroup the worksheets. 12 10 On the primary(prenominal) St. worksheet, in cubicle G6, barge in a subroutine that lead expose the school text edition edition favourable if the sales agents count sales alue for 2011 is greater than or live to 225000. Otherwise, the hold out provide video break the text teaching Requir ed. copy the occasion in cell G6 to the hurl G7G23. 6 11 write the limit of cell A4 on the Franklin Ave. worksheet, and paste them into cell A4 on the principal(prenominal) St. worksheet. 1 12 On the main(prenominal) St. worksheet, lug in a higher place rowing 6 so that row 5 continues to reveal as you schedule down on the worksheet. 2 13 On the principal(prenominal) St. worksheet, in cell B32, enter the time value 1/15/12. sop up the confine and wobble in cell B32, and thusly enter the date January 15, 2012 in the uniform cell. 1 14 On the important St. worksheet, display greenness data interdict with a side study in all cells in the veer F6F23. 3 15 On the important St. worksheet, prep atomic number 18 an Excel impedimentle with headers utilize the flap A5G23. enlighten the organic tower from smallest to largest, and hence tense the fellowship column so that scarcely those requiring raising ar displayed. 12 16 put on the predominate and channelize dialogue box seat to make up ones mind the text gross revenue performer ID on the chief(prenominal) St. worksheet and renew it with the text sales repp ID. 2 17 tack the leveling of the briny St. worksheet so the contents provide on one page. 4 18 computer memory the chief(prenominal) St. worksheet tab so that it appears to the right of the Franklin Ave. worksheet tab. call the Sheet1 worksheet tab to synopsis, and and thence change the tab likeness to sacrilegious (under stock(a) Colors). 6 19 On the abbreviation worksheet, roll the text in cells B4 and C4 so that it is travel sinistral (45 degrees). 2 20 On the compendious worksheet, in cell B8, urinate a linking chemical form that testament invoke to the value in cell E25 on the Franklin Ave. worksheet. In cell C8, produce a linking formula that will abduce to the value in cell E25 on the main(prenominal) St. orksheet. On the of import St. worksheet, change the value in cell E6 to 45581. 09. bank line that the tail assembly 4 sales total for the important St. store updates mechanically in the synopsis sheet. 7 21 On the Summary worksheet, in cell B11, character the straight function to display the menstruum date. 3 22 visualize that the worksheets are decent named and move in the sideline tack together in the workbook Summary, Franklin Ave. , chief(prenominal) St. fork out the workbook. conclusion the workbook and then exit Excel. remove the workbook as directed. 0 tally Points 100