Excel

READING ASSIGNMENT Each component of your scheme must be resignted in the rectify rasp format. The Microsoft Word member must be uploaded as a .docx or .doc; the Microsoft Excel member must be uploaded as a .xlsx or .xls; and, the Microsoft Powerpoint member must be uploaded as a .pptx or .ppt rasp. Your scheme conciliate be individually proceedingd by your tutor and hence may admit up to five to seven days to proceeding. Be secure that each of your rasps contains the forthcoming information: Your call Your tyro ID calculate The exam calculate Your email address Note: If you invadetain past than 10 attachments, you’ll scantiness to convene all of your rasps into a compact folder. To do this, prosper these instructions grounded on your uncounted system: Windows: Excellent the rasps you scantiness to compact, right-click and excellent Send to. . .and then Compact (zipped) folder Mac: Excellent the rasps you scantiness to compact, control-click and excellent Compress To resign your proceedingd scheme, prosper these steps: Log in to your tyro gateway. Click on Admit Exam give to the lecture you’re inaugurated on. Find the exam calculate for your scheme at the top of the Scheme Upload page. Follow the instructions granted to exhaustive your exam. Be secure to protect a backup observation of any rasps you resign to the school! Instructions Memo Start Word and educe a new utter muniment. Create a memo for the sales discussion as paraden in the emblem underneath, using the forthcoming formats: The audience call should be in Arial 20-point, courageous, purple font. The memo headings and citation should be in Times New Roman, 12-point font, delay left-aligned tab stops set to 1 inch. Replace Your Call Here delay your call. The organization citation should be in Times New Roman, 12-point font, delay courageous citation where indicated. Save the muniment as Discussion Memo. Spreadsheet and Chart Start Excel and educe a new utter employmentbook. Enter axioms as paraden in the emblem, using the forthcoming formats: The audience call should be in Arial, 20-point, courageous, purple font. The Summer sales distinction should be in 16-point font. The audience call and Summer sales distinctions should be merged and lifeed. Column headings should be courageous, and month headings right-aligned. The sales emblems should be in Currency cell mode delay no decimal places. Formulas that use functions should be used for conducive totals. Cells B8 through E8 should be formatted in the Total cell mode. Save the employmentsheet as Summer Sales. Create a support chart grounded on cells A4 through D7 that faces common to the emblem underneath. Select the 2-D Support Stacked Support mode. After the chart is educed, add axioms labels as paraden in the emblem. Edit the chart distinction as paraden in the emblem. Save the mitigated employmentbook. Your conclusive spreadsheet should face common to the emblem underneath. Presentation Start PowerPoint and educe a new utter donation. Change the discourse of the donation to Crop or another divert mode if you don’t invadetain Crop. Verify that slide 1 uses Distinction Slide layout and then invade citation so that your slide faces common to the emblem underneath. Add a new slide 2 delay a Utter layout, begin a consideration, and then add the sales axioms from the Summer Sales employmentbook. Size the consideration so that slide 2 faces common to the emblem underneath. Add a new slide 3 delay a Utter layout and then begin a Stacked Support chart. Add the Summer sales axioms, format the distinction, and add the axioms labels to each support. Size the chart so that slide 3 faces common to the emblem underneath. Add a new slide 4 delay a Regive delay Caption layout and add satisfied so that the slide faces common to the emblem underneath. Begin the Glow in the Dark Widget.jpg, a axioms rasp for this proceedingd scheme. Add three past Regive delay Caption layout slides to begin the Lime Doodad, Buttercup Gizmo, and Black Widget products. Their harmonious shadow rasps are axioms rasps for this proceedingd scheme. Your slides should face common to the forthcoming emblems. Add a new slide delay a Distinction and Satisfied layout and add citation so that the slide faces common to the emblem underneath. Add a new slide delay a Distinction Singly layout. Begin citation and a curtail art regive that thankfulness employees for their exacting employment (use “thank you” as the quest citation when questing for the shadow). Size and standing the regive to face common to the emblem 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 donation as Fall Meeting, and then play the slide parade from the opening to control your donation. Scoring Guidelines Rubric Skill/Grading CriteriaExemplary (4)Proficient (3)Fair (2)Poor (1)Not Evident (0)Create a memoA memo delay all divert formatting, including tab stops, and servile citation, has been educed.A memo delay most of the rectify satisfied and formatting has been educed.A memo delay most of the rectify satisfied and some of the rectify formatting has been educed.A memo delay dirty or no formatting and inservile satisfied has been educed.No attack has been made to educe a memo.Create a spreadsheetAll cell axioms is rectifyly formatted and the forethoughts use formulas delay functions.Cell axioms is rectifyly formatted and some forethoughts use formulas delay functions.Some cell axioms is rectifyly formatted and some forethoughts use formulas delay functions.Some cell axioms is give delay dirty or no formatting or use of formulas for forethought.No attack to educe a spreadsheet has been made.Create a chartA support chart grounded on the rectify axioms, the clear mode, and the rectify labels has been educed.A support chart grounded on the rectify axioms, the clear mode, but delayout the rectify labels has been educed.A support chart grounded on the rectify axioms, delay an unclear mode, and the rectify labels has been educed.A chart has been educed delayout the rectify axioms, clear mode, or labels.No attack to educe a chart has been made.Create a donationA donation in the clear discourse delay 9 slides in the rectify layouts has been educed.A donation in the clear discourse delay most of the slides in the rectify layouts has been educed.A donation in the clear discourse delay some of the slides in the rectify layouts has been educed.A donation delay fewer than 9 slides in varying layouts has been educed.No attack has been made to educe a donation or fewer than 9 slides delayout some required satisfied invadetain been educed.Insert Excel axioms as a linked aim into slide 2The clear cell axioms has been pasted as a linked Excel Worksheet aim into slide 2 and divertly sized.The clear cell axioms has been pasted as an Excel Worksheet aim delayout stringing.The clear cell axioms has been copied and pasted as a PowerPoint consideration or embedded.An attack has been made to paste some cell axioms into the donation.No attack has been made to add Excel spreadsheet axioms to the donation.Paste an Excel chart into slide 3The clear Excel chart has been pasted into slide 3 and divertly sized and standinged.The clear Excel chart has been pasted into slide 3 but not sized or standinged.The clear Excel chart has been recreated in the donation by using the Begin Chart instruct.The chart has been begined as an Excel Worksheet Aim and displays the unimpaired employmentsheet.No attack has been made to add a chart to the donation.Insert axioms rasp shadowsImages invadetain been begined as clear.Most of the clear shadows invadetain been begined.Some of the clear shadows invadetain been begined.Few of the clear shadows invadetain been begined on any slide.No attack has been made to add clear shadows to the donation.Insert a curtail art shadow into slide 9An divert curtail art shadow has been begined on slide 9 and divertly sized and standinged.An divert curtail art shadow has been begined on slide 9 but may not be sized or standinged divertly.N/AN/ANo attack has been made to add an divert curtail art shadow.Apply a transitionThe Page Curl transition has been applied to all slides.The Page Curl transition has been applied to two or past slides.The Page Curl transition has been applied to one slide singly.The injustice transition has been applied.No attack has been made to exercise 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 unitedly.A irrelative promptitude has been applied to each bullet individual individually.A irrelative promptitude has been applied to all the bullet individuals unitedly.No attack has been made to exercise an promptitude. Submission Checklist Before resignting your scheme, perform secure you’ve rectifyly exhaustived the forthcoming: Enter citation in Word. Set tab stops. Apply formatting to citation in Word. Enter and format axioms in Excel. Merge and cinvade cells in Excel. Change the decimals displayed by calculates in Excel. Create a 2-D Support chart in the Stacked Support mode. Modify the axioms labels of the chart. Change the layout of the clear slides. Apply a discourse to the donation. Add nine slides of irrelative layouts to the donation. Insert and format a consideration in a slide. Create and format a chart in a slide. Insert corporeal regive rasps into slides. Insert a curtail art shadow from the Internet into a slide. Apply a transition to all slides. Apply an promptitude to bullet points individually. View a slide parade from the opening. What to Submit You conciliate resign three rasps for this scheme: Meeting Memo.docx Summer Sales.xlsx Fall Meeting.ppt Be secure to protect a backup observation of any rasps you resign to the school!