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

  Select any neighborhoodarea in indianapolis describe why

pick any neighborhoodarea in indianapolis. explain why you picked this particular neighborhoodarea. describe the

  Discuss how relationships work in the simpsons

Discuss the similarities and differences between the "universes" found in The Simpsons, Family Guy, Futurama and South Park

  Actionless action

Identify any aspects of wu wei that would be practical in the busy lives of city dwellers, especially those living in the West. Explain whether or not you think that wu wei would be a reasonable way for a person to live his or her life. Explain why o..

  Work opportunity reconciliation act

Temporary Assistance for Needy Families Program such as the origin of the program, what is the program, what federal agency oversees the program, what other programs does the federal agency oversee, how does an individual apply for benefits, what is ..

  Describe the role grants play in human services field

explainnbspthe role grants play in the human services field. explain how and when grants are important to a human

  Assess the key element of richard bransons leadership style

Assess the key elements of Richard Branson's leadership style and the impact that those elements have had on his business success. Provide support for your rationale.

  Despite some warnings that the trend will never take off

Google Glass has so appealed to consumers that they have competed to pay around $1,500, just to be able to among the first to try out the new technological.

  Evaluate the options for solving the problem

Define the problem in the scenario that you have chosen. Evaluate the options for solving the problem. Generate options for solving the problem in the scenario.

  Explain the aspects of a description of bacterial growth

Three critical aspects of a description of bacterial growth are colony, size, color, and shape. At least three other important factors--not physical descriptions--typically are included when describing bacterial growth.

  Physicians is allied health personnel

A broad term commonly used for medical professionals who are not nurses and not physicians is allied health personnel. Select any one of the allied health professions presented in your textbook. Describe the field, and be sure to include training, pr..

  Explanation for the collapse of the rapa nui society

The most likely explanation for the collapse of the Rapa Nui society of Easter Island is:

  Workplace or social context

In a five to six sentence paragraph provide an example of how to effectively deal with a difficult person in either a workplace or social context.

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