Excel | Education homework help


Each atom of your purpose must be suggestted in the chasten refine format. The Microsoft Word lot must be uploaded as a .docx or .doc; the Microsoft Excel lot must be uploaded as a .xlsx or .xls; and, the Microsoft Powerpoint lot must be uploaded as a .pptx or .ppt refine. Your purpose accomplish be individually triced by your professor and accordingly may prosper up to five to seven days to trice.

Be permanent that each of your refines contains the forthcoming information:

  • Your spectry
  • Your learner ID number
  • The exam number
  • Your email address

Note: If you bear past than 10 attachments, you’ll omission to muster all of your refines into a sheltered folder. To do this, prosper these instructions installed on your detached system:

  • Windows: Selected the refines you omission to compact, right-click and excellenteded Send to. . .and then Compressed (zipped) folder
  • Mac: Selected the refines you omission to compact, control-click and excellenteded Compress

To suggest your triced purpose, prosper these steps:

  • Log in to your learner entrance.
  • Click on Take Exam proximate to the information you’re instituted on.
  • Find the exam number for your purpose at the top of the Purpose Upload page.
  • Follow the instructions granted to full your exam.

Be permanent to retain a backup vision of any refines you suggest to the school!

Instructions

Memo

  1. Start Word and compose a new utter muniment.
  2. Create a memo for the sales discussion as professionn in the type underneath, using the forthcoming formats:
    1. The gang spectry should be in Arial 20-point, brave, purple font.
    2. The memo headings and quotation should be in Times New Roman, 12-point font, delay left-aligned tab stops set to 1 inch.
    3. Replace Your Spectry Here delay your spectry.
    4. The whole quotation should be in Times New Roman, 12-point font, delay brave quotation where involved.
  1. Save the muniment as Meeting Memo.

Spreadsheet and Chart

  1. Start Excel and compose a new utter fruitbook.An reexhibition of a formatted summer sales fruitsheet.
  2. Enter grounds as professionn in the type, using the forthcoming formats:
    1. The gang spectry should be in Arial, 20-point, brave, purple font.
    2. The Summer sales inscription should be in 16-point font.
    3. The gang spectry and Summer sales inscriptions should be merged and centered.
    4. Column headings should be brave, and month headings right-aligned.
    5. The sales types should be in Currency cell phraseology delay no decimal places.
    6. Formulas that use functions should be used for fitted totals.
    7. Cells B8 through E8 should be formatted in the Total cell phraseology.
  3. Save the fruitsheet as Summer Sales.
  4. Create a shaft chart installed on cells A4 through D7 that contemplates concordant to the type underneath.
    1. Select the 2-D Shaft Stacked Shaft phraseology.
    2. After the chart is composed, add grounds labels as professionn in the type.
    3. Edit the chart inscription as professionn in the type.
  1. Save the mitigated fruitbook. Your developed spreadsheet should contemplate concordant to the type underneath.

Presentation

  1. Start PowerPoint and compose a new utter exhibition.
  2. Change the topic of the exhibition to Crop or another alienate phraseology if you don’t bear Crop.
  3. Verify that slide 1 uses Inscription Slide layout and then penetrate quotation so that your slide contemplates concordant to the type underneath.
  1. Add a new slide 2 delay a Utter layout, insinuate a board, and then add the sales grounds from the Summer Sales fruitbook. Size the board so that slide 2 contemplates concordant to the type underneath.
  1. Add a new slide 3 delay a Utter layout and then insinuate a Stacked Shaft chart. Add the Summer sales grounds, format the inscription, and add the grounds labels to each shaft. Size the chart so that slide 3 contemplates concordant to the type underneath.
  1. Add a new slide 4 delay a Represent delay Caption layout and add gratified so that the slide contemplates concordant to the type underneath. Insinuate the Glow in the Dark Widget.jpg, a grounds refine for this triced purpose.
  1. Add three past Represent delay Caption layout slides to make-known the Lime Doodad, Buttercup Gizmo, and Black Widget products. Their selfsame reexhibition refines are grounds refines for this triced purpose. Your slides should contemplate concordant to the forthcoming types.
  1. Add a new slide delay a Inscription and Gratified layout and add quotation so that the slide contemplates concordant to the type underneath.
  1. Add a new slide delay a Inscription Only layout. Insinuate quotation and a prune art represent that benediction employees for their rigorous fruit (use “thank you” as the pursuit quotation when pursuiting for the representation). Size and comcomposition the represent to contemplate concordant to the type underneath.
  1. Apply the Page Curl transition to all the slides.
  2. Apply the Grow & Turn life to each of the bullet items on slide 8.
  3. Save the exhibition as Fall Meeting, and then embody the slide profession from the start to impede your exhibition.