User Account

All Pages

Create a line graph for Northeast Sales

Assignment Help Other Subject
Reference no: EM132284896

Excel Assignment Instructions -

Sheet 1 -

1. Open the Excel Worksheet found with these instructions in "Excel Assignment" in Topic 3.

2. Type your first and last name in cell A1.

3. Type "UNV-504" in cell A2.

4. Type "Topic 3 Excel Assignment" in cell A3.

5. Double click Sheet 1 in the bottom left corner and rename Sheet 1 as "Title Sheet."

Sheet 2 -

1. Open Sheet 2 by clicking the Sheet 2 tab at the bottom of the Excel Workbook.

2. In cell D1, type "Total Unit Sales."

3. Using the basic calculation functionality of Excel, find the total unit sales (Price per Unit times the Units Sold) for each product. Do not use a separate calculator to find the results. Include the result in column D.

4. Use the "Basic Calculations" video link in cell B10 of the Excel Tutorial Links from the Topic 3 Materials for help with these steps.

5. Type "Average" in cell A12.

6. In cell B12, insert a function to find the average price per unit.

7. For help with this, view the "Basic Functions" video link in cell B11 of the Excel Tutorial Links from the Topic 3 Materials.

8. In cell C12, insert a function to find the average number of units sold.

9. Change the price per unit of weed spray to $26.06.

10. Change the plastic buckets units sold to 359.

11. Type Total Sales in cell F4.

12. Insert a function in cell G4 for the sum of all Total Unit Sales.

13. Rename Sheet 2 "Garden Store."

Sheet 3

1. Create a pie chart using the data in columns D and E.

2. Add data labels so that each slice of the pie shows the corresponding percentage and instrument family.

3. Use the "Pie Chart Labeling Data" video link in cell B15 of the Excel Tutorial Links from the Topic 3 Materials for help with these steps.

4. Rename Sheet 3 "Symphony."

Sheet 4 -

1. Create a line graph for Northeast Sales and Southeast Sales using the data provided.

2. Create a second line graph for Northwest Sales and Southwest Sales using the data provided.

3. Refer to the "Line Graph" video link in cell B16 of the Excel Tutorial Links from the Topic 3 Materials for help with this step.

4. Rename Sheet 4 "Division Sales."

Sheet 5 -

1. Create a scatterplot using the data provided.

2. Refer to the "XY Scatterplot" video link in cell B17 of the Excel Tutorial Links from the Topic 3 Materials for help with this step.

3. Label the X-Axis "Attendance" and the Y-Axis "Soft Drink Sold."

4. Label Sheet 5 "Drinks."

Sheet 6 -

1. Create a new tab.

2. Click the "Use of Tabs" video link in cell B5 of the Excel Tutorial Links from the Topic 3 Materials for help with these steps.

3. In cell A1, type the most challenging part of this assignment.

4. In cell A2, write something new that you learned.

5. Label Sheet 6 "Last."

6. Save the Excel Workbook and upload to your Topic 3 Excel Assignment drop box.

Attachment:- Assignment Files.rar

Verified Expert

Garden Store has average sale units of 2645 with the average price of$44.82 per unit results in total sales revenue of $19,837.50. Symphony has the highest portion of Strings instrument facility which is around 56% whereas the least portion of Percussion around 14%. Attendance and Soft drinks sale revenue has a positive relationship which means an increase in the attendance will increase the sale revenue of soft drinks.

Reference no: EM132284896

Questions Cloud

Identify and assess an intrapreneurial opportunities : Identify and assess an intrapreneurial opportunities within Bank of America and intrapreneurial assessment.
Describe the assessment you used to analyze your skills : Describe the assessment you used to analyze your skills. Describe any additional training you need in specific areas of communication.
Who orders particular part to supply production process : Consider a manufacturer who orders a particular part to supply a production process.
Who were the stakeholders and affected parties : What community standards were relevant to the controversy surrounding the Ford Pinto? Who were the stakeholders and affected parties?
Create a line graph for Northeast Sales : Create a line graph for Northeast Sales and Southeast Sales using the data provided. Create a second line graph for Northwest Sales
Propose at least three control measures that organizations : Propose at least three control measures that organizations ,need to put in place to ensure that they remain complaint.
Relationship between indigenous identity and migration : What do you think about the relationship between indigenous identity and migration?
Explain why the team performed so well or so poorly : Discuss the team dynamics for a highly effective or ineffective team of which you were a member.
Higher utilization ratios than those other systems : Would you say that systems that have higher efficiency ratios than other systems will always have higher utilization ratios than those other systems?

Reviews

Write a Review

Other Subject Questions & Answers

  Cross-cultural opportunities and conflicts in canada

Short Paper on Cross-cultural Opportunities and Conflicts in Canada.

  Sociology theory questions

Sociology are very fundamental in nature. Role strain and role constraint speak about the duties and responsibilities of the roles of people in society or in a group. A short theory about Darwin and Moths is also answered.

  A book review on unfaithful angels

This review will help the reader understand the social work profession through different concepts giving the glimpse of why the social work profession might have drifted away from its original purpose of serving the poor.

  Disorder paper: schizophrenia

Schizophrenia does not really have just one single cause. It is a possibility that this disorder could be inherited but not all doctors are sure.

  Individual assignment: two models handout and rubric

Individual Assignment : Two Models Handout and Rubric,    This paper will allow you to understand and evaluate two vastly different organizational models and to effectively communicate their differences.

  Developing strategic intent for toyota

The following report includes the description about the organization, its strategies, industry analysis in which it operates and its position in the industry.

  Gasoline powered passenger vehicles

In this study, we examine how gasoline price volatility and income of the consumers impacts consumer's demand for gasoline.

  An aspect of poverty in canada

Economics thesis undergrad 4th year paper to write. it should be about 22 pages in length, literature review, economic analysis and then data or cost benefit analysis.

  Ngn customer satisfaction qos indicator for 3g services

The paper aims to highlight the global trends in countries and regions where 3G has already been introduced and propose an implementation plan to the telecom operators of developing countries.

  Prepare a power point presentation

Prepare the power point presentation for the case: Santa Fe Independent School District

  Information literacy is important in this environment

Information literacy is critically important in this contemporary environment

  Associative property of multiplication

Write a definition for associative property of multiplication.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd