Excel

READING ASSIGNMENT Each component of your design must be suggestted in the chasten finish format. The Microsoft Word duty must be uploaded as a .docx or .doc; the Microsoft Excel duty must be uploaded as a .xlsx or .xls; and, the Microsoft Powerpoint duty must be uploaded as a .pptx or .ppt finish. Your design accomplish be partially actiond by your educationist and accordingly may use up to five to seven days to action. Be abiding that each of your finishs contains the subjoined information: Your call Your learner ID sum The exam sum Your email address Note: If you feel over than 10 attachments, you’ll neglect to amass all of your finishs into a contracted folder. To do this, supervene these instructions grounded on your unreserved system: Windows: Chosen the finishs you neglect to contract, right-click and chosen Send to. . .and then Compressed (zipped) folder Mac: Chosen the finishs you neglect to contract, control-click and chosen Compress To suggest your actiond design, supervene these steps: Log in to your learner gateway. Click on Use Exam next to the precept you’re compositioning on. Find the exam sum for your design at the top of the Design Upload page. Follow the instructions granted to unimpaired your exam. Be abiding to adhere-to a backup portraiture of any finishs you suggest to the school! Instructions Memo Start Word and cause a new unmitigated muniment. Create a memo for the sales contravention as demonstrationn in the likeness underneath, using the subjoined formats: The assemblage call should be in Arial 20-point, forward, purple font. The memo headings and quotation should be in Times New Roman, 12-point font, after a while left-aligned tab stops set to 1 inch. Replace Your Call Here after a while your call. The association quotation should be in Times New Roman, 12-point font, after a while forward quotation where indicated. Save the muniment as Contravention Memo. Spreadsheet and Chart Start Excel and cause a new unmitigated compositionbook. Enter facts as demonstrationn in the likeness, using the subjoined formats: The assemblage call should be in Arial, 20-point, forward, purple font. The Summer sales distinction should be in 16-point font. The assemblage call and Summer sales distinctions should be merged and dispositioned. Column headings should be forward, and month headings right-aligned. The sales likenesss should be in Currency cell mode after a while no decimal places. Formulas that use functions should be used for adapted totals. Cells B8 through E8 should be formatted in the Total cell mode. Save the compositionsheet as Summer Sales. Create a post chart grounded on cells A4 through D7 that beholds harmonious to the likeness underneath. Select the 2-D Post Stacked Post mode. After the chart is caused, add facts labels as demonstrationn in the likeness. Edit the chart distinction as demonstrationn in the likeness. Save the qualified compositionbook. Your last spreadsheet should behold harmonious to the likeness underneath. Presentation Start PowerPoint and cause a new unmitigated offer. Change the Nursing essay of the offer to Crop or another embezzle mode if you don’t feel Crop. Verify that slide 1 uses Distinction Slide layout and then invade quotation so that your slide beholds harmonious to the likeness underneath. Add a new slide 2 after a while a Unmitigated layout, extort a consultation, and then add the sales facts from the Summer Sales compositionbook. Size the consultation so that slide 2 beholds harmonious to the likeness underneath. Add a new slide 3 after a while a Unmitigated layout and then extort a Stacked Post chart. Add the Summer sales facts, format the distinction, and add the facts labels to each post. Size the chart so that slide 3 beholds harmonious to the likeness underneath. Add a new slide 4 after a while a Paint after a while Caption layout and add resigned so that the slide beholds harmonious to the likeness underneath. Extort the Glow in the Dark Widget.jpg, a facts finish for this actiond design. Add three over Paint after a while Caption layout slides to conduct-in the Lime Doodad, Buttercup Gizmo, and Black Widget products. Their selfsame metaphor finishs are facts finishs for this actiond design. Your slides should behold harmonious to the subjoined likenesss. Add a new slide after a while a Distinction and Resigned layout and add quotation so that the slide beholds harmonious to the likeness underneath. Add a new slide after a while a Distinction Solely layout. Extort quotation and a abridge art paint that thankfulness employees for their obdurate composture (use “thank you” as the inquiry quotation when inquirying for the metaphor). Size and posture the paint to behold harmonious to the likeness underneath. Apply the Page Curl transition to all the slides. Apply the Grow & Turn promptitude to each of the bullet individuals on slide 8. Save the offer as Fall Meeting, and then embody the slide demonstration from the opening to hinder your offer. Scoring Guidelines Rubric Skill/Grading CriteriaExemplary (4)Proficient (3)Fair (2)Poor (1)Not Evident (0)Create a memoA memo after a while all embezzle formatting, including tab stops, and accurate quotation, has been caused.A memo after a while most of the chasten resigned and formatting has been caused.A memo after a while most of the chasten resigned and some of the chasten formatting has been caused.A memo after a while dirty or no formatting and inexact resigned has been caused.No violate has been made to cause a memo.Create a spreadsheetAll cell facts is chastenly formatted and the anticipations use formulas after a while functions.Cell facts is chastenly formatted and some anticipations use formulas after a while functions.Some cell facts is chastenly formatted and some anticipations use formulas after a while functions.Some cell facts is give after a while dirty or no formatting or use of formulas for anticipation.No violate to cause a spreadsheet has been made.Create a chartA post chart grounded on the chasten facts, the definitive mode, and the chasten labels has been caused.A post chart grounded on the chasten facts, the definitive mode, but after a whileout the chasten labels has been caused.A post chart grounded on the chasten facts, after a while an undefinitive mode, and the chasten labels has been caused.A chart has been caused after a whileout the chasten facts, definitive mode, or labels.No violate to cause a chart has been made.Create a offerA offer in the definitive Nursing essay after a while 9 slides in the chasten layouts has been caused.A offer in the definitive Nursing essay after a while most of the slides in the chasten layouts has been caused.A offer in the definitive Nursing essay after a while some of the slides in the chasten layouts has been caused.A offer after a while fewer than 9 slides in varying layouts has been caused.No violate has been made to cause a offer or fewer than 9 slides after a whileout some required resigned feel been caused.Insert Excel facts as a linked end into slide 2The definitive cell facts has been pasted as a linked Excel Worksheet end into slide 2 and embezzlely sized.The definitive cell facts has been pasted as an Excel Worksheet end after a whileout stringing.The definitive cell facts has been copied and pasted as a PowerPoint consultation or embedded.An violate has been made to paste some cell facts into the offer.No violate has been made to add Excel spreadsheet facts to the offer.Paste an Excel chart into slide 3The definitive Excel chart has been pasted into slide 3 and embezzlely sized and postureed.The definitive Excel chart has been pasted into slide 3 but not sized or postureed.The definitive Excel chart has been recreated in the offer by using the Extort Chart enjoin.The chart has been extorted as an Excel Worksheet End and displays the unimpaired compositionsheet.No violate has been made to add a chart to the offer.Insert facts finish metaphorsImages feel been extorted as definitive.Most of the definitive metaphors feel been extorted.Some of the definitive metaphors feel been extorted.Few of the definitive metaphors feel been extorted on any slide.No violate has been made to add definitive metaphors to the offer.Insert a abridge art metaphor into slide 9An embezzle abridge art metaphor has been extorted on slide 9 and embezzlely sized and postureed.An embezzle abridge art metaphor has been extorted on slide 9 but may not be sized or postureed embezzlely.N/AN/ANo violate has been made to add an embezzle abridge art metaphor.Apply a transitionThe Page Curl transition has been applied to all slides.The Page Curl transition has been applied to two or over slides.The Page Curl transition has been applied to one slide solely.The wickedness transition has been applied.No violate has been made to apportion a transition to any of the slides.Apply promptitudesThe Grow & Turn promptitude has been applied to each bullet individual individually.The Grow & Turn promptitude has been applied to all the bullet individuals simultaneously.A incongruous promptitude has been applied to each bullet individual individually.A incongruous promptitude has been applied to all the bullet individuals simultaneously.No violate has been made to apportion an promptitude. Submission Checklist Before suggestting your design, construct abiding you’ve chastenly unimpairedd the subjoined: Enter quotation in Word. Set tab stops. Apply formatting to quotation in Word. Enter and format facts in Excel. Merge and cinvade cells in Excel. Change the decimals displayed by sums in Excel. Create a 2-D Post chart in the Stacked Post mode. Modify the facts labels of the chart. Change the layout of the definitive slides. Apply a Nursing essay to the offer. Add nine slides of incongruous layouts to the offer. Insert and format a consultation in a slide. Create and format a chart in a slide. Insert stout paint finishs into slides. Insert a abridge art metaphor from the Internet into a slide. Apply a transition to all slides. Apply an promptitude to bullet points individually. View a slide demonstration from the opening. What to Submit You accomplish suggest three finishs for this design: Meeting Memo.docx Summer Sales.xlsx Fall Meeting.ppt Be abiding to adhere-to a backup portraiture of any finishs you suggest to the school!