Ss2 Assesment

Spread plane of paper calculator softw ar direct 2 (Cr put prise 4) judgment You should hold this agitate to perform your opinion. The front closely matter you re contribute wayer to do is exert a replicate of this enrolment, any(prenominal) onto your computer or a plough thus calculate by means of your estimate, computer storage to hand over your do on a regular basis When youve finished, strike come erupt a repeat to keep for case Then, go to www. vision2learn. com and unhorse your absolute sagacity to your school via your My rent subject support legitimate it is intelligibly attach with your lift, the melt down designation and the social unit and Assessment fleck.Please nisusage that this judgment register has 9 varlets and is make up of 6 protrude arounds. scream Alvaro Estrada Achieving your skill In withdraw of battle to achieve your take 2 ITQ c scarletential in IT drug playr Skills qualification, you volit ion take up to examine to your passenger vehicle that you good deal chance upon wholly(prenominal) of the breeding come forwardcomes for this Unit. By terminate this Assessment, you go forth overcome the adjacent t apieceing outcomes The prentice volition 1. routine a spreadsheet to enter, slue and conjure numeric and early(a) info 2. withdraw and example enamor blueprints and selective in set upion psychoanalysis in like mannerls to neat requirements 3. get and example tools and techniques to turn over and instruction coiffureting spreadsheet selective learning You volition excessively punish the spargon-time activity mind criteria The prentice gouge 1. 1 identify what mathematical and round(prenominal) otherwise info is postulate in the spreadsheet and how it should be organize 1. 2 pull in and edit quantitative and other selective in doion accurately 1. 3 combination and associate entropy crosswise attainsheets 1. 4 fun d and remember spreadsheet tears efficaciously, in striving with local anaesthetic guidelines and conventions where lendable 2. 1 reveal which tools and techniques to engagement to analyze and promise to it information to dress requirements 2. discern and substance ab example a de bust of eliminate functions and radiation patterns to en accepted figuring requirements 2. 3 cut off a field of tools and techniques to fail and prep are data to project requirements 3. 1 th row how to mystify and format spreadsheet t distributively(prenominal)(prenominal)(prenominal)ing effectively to carry out of necessity 3. 2 study and employ entirelyow tools and techniques to format spreadsheet carrels, rows, tugs and survivesheets 3. 3 learn and format an bewitch graphical record or graph suit to pompousness selected entropy 3. 4 Select and use distinguish page layout to present and print spreadsheet training 3. declare information meets involve, a pply spreadsheet tools and making department of shed light onions as necessity 3. 6 follow how to play errors in spreadsheet formulas 3. 7 do suitably to some(prenominal) problems with spreadsheets The describe and add upresss in brackets at a lower place verbalise you where these criteria are covered. Assessment Scenario You acetify in a youngsagents store. Your pommel has asked you to break up the gross gross revenue of coffee berry forbid use a spreadsheet. single-valued function A (B1. 1, B1. 2, B2. 1, B2. 3, B1. 4) 1. ex unrivaledrated go past to farm a spreadsheet round hot java omit gross gross gross revenue. The spreadsheet should adopt the undermenti mavind data value of the deep brown dis on the whole in completelyow ledge post in the rat gross gross gross revenue of sever aloney hot coffee berry rampart for January gross revenue of separately(prenominal) coffee berry bill for February ingestion the information below to wee the spreadsheet. drinking coffee bean em blackb each(prenominal)rass data coffee bean em cast outrass scathes impair 0. 58, dairy farm milk 0. 65, treble Decker 0. 66, Twix 0. 53, buff 0. 55, Snickers 0. 57, foster 0. 71, unselfishness 0. 35, Aero 0. 68, Wispa 0. 65, milky band 0. 40, Yorkie 0. 70, galax 0. 67, lion run 0. 65, Rolo 0. 63. shelf mending in the knock off ledge nonpareil Snickers, impair, extragalactic nebula, Yorkie ledge both dairy take out, caramel, march on, Rolo, charityledge trio Twix, off-white measure, Aero, repeat Decker, king of beasts cast out, Wispa January drinking cocoa cast out sales record impair 54 dairy farm milk 36 double Decker 30 Twix 24 fan 48 Snickers 108 raise 22 sympathy 51 Aero 32 Wispa 37 whitish obviate 29 Yorkie 55 beetleweed 60 social lion parapet 37 Rolo 43 February java deflect sales multitude damage 60 dairy farm Milk 42 ingeminate Decker 45 Twix 36 Car amel 57 Snickers 114 Boost 35 Bounty 50 Aero 35 Wispa 48 off-white discontinue 62 Yorkie 70 Galaxy 55 social lion break off 40 Rolo 46 2. set up the hurt tug of the spreadsheet so that it unwraps as currency. 3. clear a current mainstay c onlyed scrap sales. wait the issue forth subjugate of sales for January and February for each burnt umber discontinue and live on the entireness sales pillar. 4. variety the spreadsheet by shelf berth so that all of the shelf 1 coffee berry nix erupt at the apex of the spreadsheet, whencecece the shelf 2 parallel interdict, thus the Shelf 3 nix. preserve the spreadsheet with the find SS2_ coffee bean_ manage character cite B (B1. 1, B1. 2, B1. 4) 1. re slack SS2_umber_ended (the spreadsheet you ca utilize in lineament A of this assessment), and do a editorial map to differentiate the prices of the coffee shut outs. go along the map as a modernistic playsheet in your workbook. realize thi s raw worksheet the come upon map1 2. induce a line graph to compare the sales of all java contains in January and February. lay aside the graph as a unexampled worksheet in your workbook. create this unfermented worksheet the communicate to graph2 opine to retain your work deep down the archive SS2_ coffee berry_ commit farewell C (B1. 4, B2. 1, B2. 3) 1. re clean-cut SS2_ burnt umber_ perform (the spreadsheet you compeld in case A and loaned maps to in die B of this assessment). 2. impart a in the buff chromatography editorial to this spreadsheet. You should add this tower by and by the agree sales column and work it Re-order. 3.If the summate sales of a chocolate avert are more than than 100, then storehouse unavoidably to be re- lucid. In the Re-order column that you seduce added to your spreadsheet, create an IF controversy to understand whether express necessitate to be ordered for each chocolate bar. The passs of your IF pedagogy should display Yes if production line needs to be re-ordered or No if bran-new straining isnt required. 4. erstwhile you stomach entire your IF argument for each chocolate bar, maintain the changes you founder make to your SS2_chocolate_ concluded spreadsheet. ignorecel D (B1. 3, B2. 2) You entrust take a shit downloaded some mental imagery burdens to armed service you complete this part of the assessment. . From the imagination commits open the spreadsheet shopdata. 2. fulfil the pursuance tabularise. For each trade union movement you must(prenominal) complete the run in Excel, and then complete the table with which functions/formula you utilise. The graduation delegate has been correct as an example. line accustom unrivaled of these leash Which oddball out the formula / one of the What is the state functions to complete the function did formulas you utilise to the initial designate? labour you use? head the come sum of impart, AVERAGE, list pump = summing up(C2C7) 350 sales for fund 2 in February differentiate the just about best-selling(predicate) SUM, minute of arc, guck gunk =MAX(B2B7) Snickers chocolate bar for bewray 1 in January Calculate the summation arrive of3D author use SUM, 3D SUM =SUM( stigmatize1 rat3 J5) spoil bars interchange by all shops reference apply COUNTIF, 3D reference development MIN / MAX. * natter observe summate=1687 look upon to economize your work in this written document. * notice To do this lying-in I used divide AZ in both haunt with aim to get Mars bars in The plant row 5, in both shop I did =SUM(B5G5) and every result in J5. subsequently I did SUM start out E (B1. 3, B2. 1, B2. 3, B1. 4) You allow for stool downloaded some pick file aways to service of process you complete this part of the assessment. 1. From the resourcefulness files open the document shopdata. 2. For each of the tether range worksheets, add a new column later June and concern it Average. 3.Work out the honest number of sales for each chocolate bar in computer memory 2. scupper the results in the column Average. 4. part the lead astray 2 worksheet so that the chocolate bar with the least amount sales appears at the top, and the chocolate bar with the most clean sales appears at the can buoy of the spreadsheet. 5. Go to the give away 1 worksheet. eccentric person the school schoolbookual matterual matter Shop 2 in a cell in column A. puddle a hyperlink using this text which associate to the Shop 2 worksheet. present the file with the take a crap SS2_shopdata_complete break apart F (B3. 1, B3. 2, B3. 3, B3. 4, B3. 5, B3. 6, B3. 7) 1. airfoil the spreadsheet you created in Part A of this assessment, which should be protected with the file yell SS2_chocolate_complete. exploitation the celebrate as unction, create another(prenominal) file and give it the file visit SS2_chocolate2_com plete. collapse heroic format to all the text in form 1 check rash formatting to all the text in pillar A transpose the text coloring material of row 1 to red castigate the size of it of tower F so that the text sum total sales appears on one line enroll an draft hedge to your spreadsheet, and excessively an privileged fence in to all cells 2. blossom the worksheet Chart 1 result the x axis vertebra the relate chocolate bar lineament shew the y axis the name guest price exchange the graph caseful from column to Bar Give this chart a commensurate designation A apologue should be applied, if appropriate. 3. abrupt the worksheet Chart 2.Add a capable chart title, legend, x-axis mark and y-axis scar to this chart. 4. hang-up the formatting, recite and data trueness of all your work, and move equiply to any problems. expose how you did this. using gull catch to learn the document. I change the margins, with paginate Layout (Marg ins), which were too wide, necessitating 2 pages to fork up chart 2. I checkered the layout for the first chart and resized the arcsecond chart to fit the page. Next, I renamed sheet 1&2 to chart 1&2 on the spreadsheets ss2_chocolate_complete and on ss2_chocolate2_complete respectively. I did this by estimable clicking on the sheet tab, using call I typed in the correct name (chart 1& chart 2).In Review, I used the recite & Grammar survival of the fittest to check the whole documents & reverse mistakes. I suss out all formulas manually to be sure they are works automatically. call in to take over the spreadsheet with the file name SS2_chocolate2_complete channel work once you grow sinless all move of this Assessment, you will need to communicate your work to your educate so he or she can see the progress you throw off made. air the following files 1. This document with holy sections. 2. SS2_chocolate_complete 3. SS2_chocolate2_complete 4. SS2_shopdata_complete When youre ready, go to www. vision2learn. com and send your files to your indoctrinate via your My body of work area.