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

Prior to beginning work on this discussion forum, read Topic 6 International Accounting Standards in Appendix A in the course textbook, Using Financial

Prior to beginning work on this discussion forum, read Topic 6 International Accounting Standards in Appendix A in the course textbook, Using Financial Accounting. Next, review the Walmart Case Study. Compare and contrast the differences in the Walmart financial statements if the company were to use International Financial Reporting

Article 1: Ethical and Legal Challenges of Artificial Intelligence in Nuclear Medicine Authors:

Article 1: Ethical and Legal Challenges of Artificial Intelligence in Nuclear Medicine Authors: Geoffrey Currie, BPharm, MMedRadSc, MAppMngt, MBA, PhD,* and K Elizabeth Hawk, MS, MD, PhD† I need a 8 page essay apa format on the above article

https://eric.ed.gov/?id=EJ976654. Parsonson, B. S. (2012). Evidence-Based Classroom Behaviour Management Strategies. Kairaranga, 13(1), 16-23 Ms. Johnson is a

Parsonson, B. S. (2012). Evidence-Based Classroom Behaviour Management Strategies. Kairaranga, 13(1), 16-23 Ms. Johnson is a seventh-grade teacher in a local multicul

Rasmussen University – NUR2063: Essentials of Pathophysiology Title of Assignment: Module 08 Written Assignment –

Rasmussen University – NUR2063: Essentials of Pathophysiology Title of Assignment: Module 08 Written Assignment – Asthma Case Study Purpose of Assignment: This assignment will help the student evaluate of a respiratory disorder, which, if untreated, can be a serious condition. Students need to understand respiratory complications and how it can

PSYC 700 Discussion Assignment Instructions The student will complete 7 Discussions in this course. For 6 of the Discussions,

PSYC 700 Discussion Assignment Instructions The student will complete 7 Discussions in this course. For 6 of the Discussions, the student will post one thread of at least 300 words by 11:59 p.m. (ET) on Thursday of the assigned Module: Week. The student must then post 2 replies of at

Post and discuss the critical review of one scholarly literature article related to executing or monitoring and controlling projects and best practices

Post and discuss the critical review of one scholarly literature article related to executing or monitoring and controlling projects and best practices or a scholarly study that addresses complex stakeholder interfaces, change management, or ambiguity of project goals.

1. Typically, the idea is to have that traditional two parent home to provide the structure and all around support to their children. The children need

1. Typically, the idea is to have that traditional two parent home to provide the structure and all around support to their children. The children need that loving, caring, nurturing side from the mother and the authoritativeness,and structured side from their father. Both parents contribute to the comprehensive development of

ZOOMSYSTEMS ANALYSIS AND DESIGN [2242-INSY-3305] Fall 2024 | Instructor: Atieno A. Amadi Assignment-2 Process Model Instructions: Draw a Level 0 Data Flow

ZOOMSYSTEMS ANALYSIS AND DESIGN [2242-INSY-3305] Fall 2024 | Instructor: Atieno A. Amadi Assignment-2 Process Model Instructions: Draw a Level 0 Data Flow Diagram (DFD) for the Picnics R US case [See

HLTH 330 HLTH 330 Journal Analysis: Exercise and Activity Assignment Instructions Overview The purpose of this

HLTH 330 HLTH 330 Journal Analysis: Exercise and Activity Assignment Instructions Overview The purpose of this assignment is to examine and analyze activity, exercise and calorie balance as they relate to adequacy, deficiency and health benefits. This fulfills Learning Outcomes 1 and 4. Instructions Details: For this assessment, you are

Hi this is esteban Tankou. I’ll pay you 15$ for this work so please don’t USE AI and no Plagiarism. The assignment in the file NO AI please

HELP ASAP PLEASE PSYC338 WEEK 3 LEARNING RESOURCES

Topic: IMPACT OF DATA-DRIVEN DECISIONS IN HEALTHCARE: PHENOMENOLOGICAL STUDY OF HEALTHCARE DATA ANALYTICS

Topic: IMPACT OF DATA-DRIVEN DECISIONS IN HEALTHCARE: PHENOMENOLOGICAL STUDY OF HEALTHCARE DATA ANALYTICS Getting started with your literature review Activity 1: Module 1 Discussion Board This is the second foundational course for your dissertation project. Much of your success is contingent on working closely with your chair. Thus, communication is

Please see attachment Q1 Describe your experience with Self Directed Learning. Compare and contrast this to your online classwork. Explain some

Please see attachment Q1 Describe your experience with Self Directed Learning. Compare and contrast this to your online classwork. Explain some challenges Q2 Compare and contrast the t hree basic types of evaluation in Family Life Education, and explain how you would use each of the three (not just one)

Comment about this post: When kids grow into teenagers, they often start hanging out with their friends more and spending less time with their families. What’s

Comment about this post: When kids grow into teenagers, they often start hanging out with their friends more and spending less time with their families. What’s more, these peer relationships are getting more and more unregulated by adults. Adolescents’ ideas of friendship are increasingly centered on private exchanges of ideas

BCIT Department of Physics MGO-03 – Worksheet Version: Jan-23 – 1 – © Dr. M. Harder MGO-03: Graphical Analysis – Worksheet Maximum Score: 18 1. [4]

BCIT Department of Physics MGO-03 – Worksheet Version: Jan-23 – 1 – © Dr. M. Harder MGO-03: Graphical Analysis – Worksheet Maximum Score: 18 1. [4] Include the following four GraphIt outputs (plot and fit results) with your submission: (1) Data Set 1 fit with Model 1.1 (2) Data Set

See attached instructions. Instructions Pick any three (3) differential diagnoses that can be associated with chest pain and

See attached instructions. Instructions Pick any three (3) differential diagnoses that can be associated with chest pain and their approach in various clinical settings. Include the following components in the paper: 1. Introduction (general) 2. Mention research studies (at least three articles) that validate the information presented in your paper.

1) Describe your first impression of the location. 2) Describe your immediate reaction to the people and how you were able to communicate with them. 3)

1) Describe your first impression of the location. 2) Describe your immediate reaction to the people and how you were able to communicate with them. 3) If you had a chance to do it over, what would you do differently? 4) How has this experience and what you have learned

Our Services

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

Share This Post

Related Questions

Use Our 6 Free Tools