Excel | Education homework help

Each element of your project must be submitted in the correct file format. The Microsoft Word portion must be uploaded as a .docx or .doc; the Microsoft Excel portion must be uploaded as a .xlsx or .xls; and, the Microsoft Powerpoint portion must be uploaded as a .pptx or .ppt file. Your project will be individually graded by your instructor and therefore may take up to five to seven days to grade.

Be sure that each of your files contains the following information:

  • Your name
  • Your student ID number
  • The exam number
  • Your email address

Note: If you have more than 10 attachments, you’ll need to collect all of your files into a compressed folder. To do this, follow these instructions based on your operating system:

  • Windows: Select the files you want to compress, right-click and select Send to. . .and then Compressed (zipped) folder
  • Mac: Select the files you want to compress, control-click and select Compress

To submit your graded project, follow these steps:

  • Log in to your student portal.
  • Click on Take Exam next to the lesson you’re working on.
  • Find the exam number for your project at the top of the Project Upload page.
  • Follow the instructions provided to complete your exam.

Be sure to keep a backup copy of any files you submit to the school!

Instructions

Memo

  1. Start Word and create a new blank document.
  2. Create a memo for the sales meeting as shown in the figure below, using the following formats:
    1. The company name should be in Arial 20-point, bold, purple font.
    2. The memo headings and text should be in Times New Roman, 12-point font, with left-aligned tab stops set to 1 inch.
    3. Replace Your Name Here with your name.
    4. The body text should be in Times New Roman, 12-point font, with bold text where indicated.
  1. Save the document as Meeting Memo.

Spreadsheet and Chart

  1. Start Excel and create a new blank workbook.An image of a formatted summer sales worksheet.
  2. Enter data as shown in the figure, using the following formats:
    1. The company name should be in Arial, 20-point, bold, purple font.
    2. The Summer sales title should be in 16-point font.
    3. The company name and Summer sales titles should be merged and centered.
    4. Column headings should be bold, and month headings right-aligned.
    5. The sales figures should be in Currency cell style with no decimal places.
    6. Formulas that use functions should be used for calculated totals.
    7. Cells B8 through E8 should be formatted in the Total cell style.
  3. Save the worksheet as Summer Sales.
  4. Create a column chart based on cells A4 through D7 that looks similar to the figure below.
    1. Select the 2-D Column Stacked Column style.
    2. After the chart is created, add data labels as shown in the figure.
    3. Edit the chart title as shown in the figure.
  1. Save the modified workbook. Your final spreadsheet should look similar to the figure below.

Presentation

  1. Start PowerPoint and create a new blank presentation.
  2. Change the theme of the presentation to Crop or another appropriate style if you don’t have Crop.
  3. Verify that slide 1 uses Title Slide layout and then enter text so that your slide looks similar to the figure below.
  1. Add a new slide 2 with a Blank layout, insert a table, and then add the sales data from the Summer Sales workbook. Size the table so that slide 2 looks similar to the figure below.
  1. Add a new slide 3 with a Blank layout and then insert a Stacked Column chart. Add the Summer sales data, format the title, and add the data labels to each column. Size the chart so that slide 3 looks similar to the figure below.
  1. Add a new slide 4 with a Picture with Caption layout and add content so that the slide looks similar to the figure below. Insert the Glow in the Dark Widget.jpg, a data file for this graded project.
  1. Add three more Picture with Caption layout slides to introduce the Lime Doodad, Buttercup Gizmo, and Black Widget products. Their corresponding image files are data files for this graded project. Your slides should look similar to the following figures.
  1. Add a new slide with a Title and Content layout and add text so that the slide looks similar to the figure below.
  1. Add a new slide with a Title Only layout. Insert text and a clip art picture that thanks employees for their hard work (use “thank you” as the search text when searching for the image). Size and position the picture to look similar to the figure below.
  1. Apply the Page Curl transition to all the slides.
  2. Apply the Grow & Turn animation to each of the bullet items on slide 8.
  3. Save the presentation as Fall Meeting, and then play the slide show from the beginning to check your presentation.
Get 20% Discount on This Paper
Pages (550 words)
Approximate price: -

Try it now!

Get 20% Discount on This Paper

We'll send you the first draft for approval by at
Total price:
$0.00

How it works?

Follow these simple steps to get your paper done

Place your order

Fill in the order form and provide all details of your assignment.

Proceed with the payment

Choose the payment system that suits you most.

Receive the final file

Once your paper is ready, we will email it to you.

Our Services

Do My Homework has assembled a team of highly skilled writers with diverse experience in the online writing circles. Our aim is to become a one stop shop for all your Academic/ online writing. Check out below our amazing service!

Essays

Essay Writing Services

At Do My Homework, we prioritize on all aspects that creates a good grade such as impeccable grammar, proper structure, zero-plagiarism, and conformance to guidelines. The principal purpose of essay writing is to present the author's evaluation concerning a singular subject about which they have made. Since Professionalism is the mother of every success, try our team of experienced writers in helping you complete your essays and other assignments.

Admissions

Admission Papers

You have been trying to join that prestigious institution you long yearned for, but the hurdle of an admission essay has become a stumbling block. We have your back, with our proven team that has gained invaluable experience over time, your chance of joining that institution is now! Just let us work on that essay.How do you write an admission essay? How do you begin the essay? For answers, try Quality Custom Writers Now!

Editing

Editing and Proofreading

Regardless of whether you're pleased with your composing abilities, it's never an impractical notion to have a second eye go through your work. The best editing services leaves no mistake untouched. We recognize the stuff needed to polish up a writing; as a component of our editing and proofreading, we'll change and refine your write up to guarantee it's amazing, and blunder free. Our group of expert editors will examine your work, giving an impeccable touch of English while ensuring your punctuation and sentence structures are top-notch.

Coursework

Technical papers

We pride ourselves in having a team of clinical writers. The stringent and rigorous vetting process ensures that only the best persons for job. We hire qualified PhD and MA writers only. We equally offer our team of writers bonuses and incentives to motivate their working spirit in terms of delivering original, unique, and informative content. They are our resources drawn from diverse fields. Therefore your technical paper is in the right hands. Every paper is assessed and only the writers with the technical know-how in that field get to work on it.

Coursework

College Essay Writing

If all along you have been looking for a trustworthy college essay service provider that provides superb academic papers at reasonable prices, then be glad that you search has ended with us. We are your best choice! Get high-quality college essay writing from our magnificent team of knowledgeable and dedicated writers right now!

Coursework

Quality Assignment/Homework Help

We give the students premium quality assignments, without alarming them with plagiarism and referencing issues. We ensure that the assignments stick to the rules given by the tutors. We are specific about the deadlines you give us. We assure you that you will get your papers well in advance, knowing that you will review and return it if there are any changes, which should be incorporated.