Our Services

Get 15% Discount on your First Order

create an excel spreadsheet using the attached files. Download and review the “Excel Worksheet” found directly below the assignment instructions

April 11, 2024

create an excel spreadsheet using the attached files.

Download and review the “Excel Worksheet” found directly below the assignment instructions under “Attachments” for the data sets required to complete this assignment. Note: You must download this “Excel Worksheet,” not just view it in your browser, in order to see all of the required data sets.

Sheet 1

1. Type your Farid Faraj in cell A1.

2. Type “UNV-504” in cell A2.

3. Type “Topic 3 Excel Assignment” in cell A3.

4. Double click Sheet 1 in the bottom left corner and rename Sheet 1 as “Title Sheet.”

Sheet 2

(Review “Excel Formulas and Functions Tutorial,” located in the topic Resources.)

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

· In cell D1, type “Total Unit Sales.”

· 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.

· Type “Average” in cell A12.

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

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

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

· Change the plastic buckets units sold to 359.

· Type Total Sales in cell F4.

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

· Rename Sheet 2 “Garden Store.”

Sheet 3

(Review “How to Create a Pie Chart in Excel (With Percentages),” located in the topic Resources.)

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

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

· Rename Sheet 3 “Symphony.”

Sheet 4

(Review “How to Make a Line Graph on Excel,” located in the topic Resources.)

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

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

· Rename Sheet 4 “Division Sales.”

Sheet 5

(Review “How to Make a Scatter Graph/Plot in Microsoft Excel (Scatter Graph Tutorial),” located in the topic Resources.)

· Create a scatterplot using the data provided.

· Label the X-Axis “Attendance” and the Y-Axis “Soft Drink Sold.”

· Label Sheet 5 “Drinks.”

Sheet 6

(Review “How to Rename a Worksheet in Microsoft Excel,” located in the topic Resources.)

· Create a new tab.

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

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

· Label Sheet 6 “Last.”

>Business & Finance homework help

Share This Post

Order a Similar Paper and get 15% Discount on your First Order

Related Questions

For this essay assignment, you are tasked with locating a company or business that has experienced an ethical issue within the last 5 years. In your essay,

For this essay assignment, you are tasked with locating a company or business that has experienced an ethical issue within the last 5 years. In your essay, you will include the following information: the name of the company or business and a description of the ethical issue that took place,

How Can eBay Dropshipping Automation Transform Your Selling Strategy?

Chris, an 8-year-old male, is diagnosed with Down Syndrome and Intellectual Disability (ID). Stephanie, a 7-year-old female, is diagnosed with Autism

Chris, an 8-year-old male, is diagnosed with Down Syndrome and Intellectual Disability (ID). Stephanie, a 7-year-old female, is diagnosed with Autism Spectrum Disorder (ASD) and Intellectual Disability (ID). Taylor, an 8-year-old male, is diagnosed with Autism Spectrum Disorder (ASD)a. Consider the three students and their corresponding diagnoses, then answer the

What is social Darwinism? What is scientific racism? How did people place theory into policy? How does scientific racism and social Darwinism still influence

What is social Darwinism? What is scientific racism? How did people place theory into policy? How does scientific racism and social Darwinism still influence social thought and interaction? Provide an

Information Literacy Research Project: Literature Review 100 Points Possible Review the following resources: Sample Literature Review Download Sample Literature

Information Literacy Research Project: Literature Review 100 Points Possible Review the following resources: Sample Literature Review Download Sample Literature Review Writing a Literature Review at h

Collect an Internet article related to Developmental Psychology. You are to summarize the information in the article, care the information to what the text

Collect an Internet article related to Developmental Psychology. You are to summarize the information in the article, care the information to what the text says about the topic covered in the article, and then write a personal reaction. You must include the internet site where you found the article. Followed

Provide a summary of 400 words for Chapters 7 & 8 of the text Emergency Management in Health Care. book Emergency Management in Health Care: An

Provide a summary of 400 words for Chapters 7 & 8 of the text Emergency Management in Health Care. book Emergency Management in Health Care: An All-HazardsApproach, 5th ed (June 15, 2022). Joint C

End of life medical ethics issue: the particular case might be physician-assisted suicide 2 2 Week 2 Term Paper Topic

End of life medical ethics issue: the particular case might be physician-assisted suicide 2 2 Week 2 Term Paper Topic Your Name Here West Coast University PHIL 434: Medical Ethics and Issues Your Instructor’s Name Here The Date Here Week 2 Term Paper: Topic Topic Tell me what your topic

An understanding of one’s own approaches to leadership, motivation, collaboration, and ethical situations is important to the evolution of an effective

An understanding of one’s own approaches to leadership, motivation, collaboration, and ethical situations is important to the evolution of an effective leader. An introspective lens can help emerging leaders better understand and hone these important skills. SCENARIO Imagine that over the past few months you have participated in several organizational projects and

Argument Map: Students will prepare and present an argument map with at least five peer-reviewed sources. An argument map is the framework of a research paper.

Argument Map: Students will prepare and present an argument map with at least five peer-reviewed sources. An argument map is the framework of a research paper. The map is a critical component of the r

See Attachment Psychological Disorders and Therapy Instructions: Read the required materials for this

See Attachment Psychological Disorders and Therapy Instructions: Read the required materials for this module. Then, use the following template to complete the assignment. · Template: Assignment: Psychological Disorders and Therapy Download Assignment: Psychological Disorders and Therapy Be sure to review the academic expectations for your submission. Submission Instructions: · Submit your

Student’s Name Rasmussen NPR Concept Plan Date Diagnostic Data Patient Education Nursing Interventions Possible Nursing Diagnosis Clinical

Student’s Name Rasmussen NPR Concept Plan Date Diagnostic Data Patient Education Nursing Interventions Possible Nursing Diagnosis Clinical Manifestations Subjective: Objective: Medical Diagnosis Patient Data/Risk Factors Possible Medications Pathophysiology Medical Interventions [Type text] 0413 image1.png

Medicine and Islam have a rich and intertwined history. From ancient times to modern advancements, Islamic civilization has contributed significantly to

Medicine and Islam have a rich and intertwined history. From ancient times to modern advancements, Islamic civilization has contributed significantly to medical knowledge and practice. Discover the profound influence of Islamic teachings on health and medicine, which continue to shape the healthcare landscape today. Unlock the power of compassion and

I need some help! Discussion Question · Which assignments were the most thought-provoking for you? Why? · How has your

I need some help! Discussion Question · Which assignments were the most thought-provoking for you? Why? · How has your perspective or understanding of analyzing and visualizing financial and accounting data changed during this course? Explain. · Review the courses you are enrolled in for the upcoming session. How does

Assignment #3: ZipDial: Reaching The Next 3 Billion Customers Answer the following questions in 400 words or less. Be sure to provide supporting

Assignment #3: ZipDial: Reaching The Next 3 Billion Customers Answer the following questions in 400 words or less. Be sure to provide supporting rationale for your answers. ZipDial is attempting to develop a strategy for entering other emerging markets, such as Indonesia and The Philippines. In developing this strategy… How

Good Afternoon, I am currently doing a research paper for my Experimental Psychology class and I need help writing my introduction and my discussion

Good Afternoon, I am currently doing a research paper for my Experimental Psychology class and I need help writing my introduction and my discussion section. This paper has to be in APA format and it has to be in your OWN words, strictly NO PLAGIARISM. For the introduction and discussion,