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

DescriptionCollege of Health Sciences Department of Public Health PHC374 – PAPER ASSIGNMENT Course name: ORAL HEALTH PROMOTION Course

Description College of Health Sciences Department of Public Health PHC374 – PAPER ASSIGNMENT Course name: ORAL HEALTH PROMOTION Course number: PHC374 CRN Choose only one of the following two topics to explore: Promoting Oral Health: Understanding Diseases and Preventative Measures 1. Explore the various types of diseases and conditions that

Some of the activities of the Arab Spring were unprecedented behaviors. Some observers and participants believed these actions could change the face

Some of the activities of the Arab Spring were unprecedented behaviors. Some observers and participants believed these actions could change the face of the Arab world. After completing this week’s readings, compose an essay that addresses issues relative to the Arab Spring. In your paper, · Describe what took place

DescriptionCollege of Health Sciences Department of Public Health PHC374 – PAPER ASSIGNMENT Course name: ORAL HEALTH PROMOTION Course

Please follow instructions thoroughly.semantic1.txt // Variable Initialization Mismatch function main returns integer; value: integer is

Please follow instructions thoroughly. semantic1.txt // Variable Initialization Mismatch function main returns integer; value: integer is ‘A’; begin 1; end; semantic10.txt // List Subscript is not Integer function main returns integer; aList: list of integer is (1, 2, 3); begin aList(1.5); end; semantic11.txt — Mixing Numeric and Character Types with

I have a essay due for a art class further details to be discussed upon acceptance

1Assessment 01Collaboration and Leadership Reflection Video For this assessment you will use Kaltura to create a 5–10 minute video reflection

1 Assessment 01 Collaboration and Leadership Reflection Video For this assessment you will use Kaltura to create a 5–10 minute video reflection that addresses either an interprofessional collaboration you experienced or the case study on interprofessional collaboration presented below. If you choose to reflect on the interprofessional case study presented

Assignment Instructions:Note: You will need to download medical apps onto an iPhone, iPad, or Android device to

Assignment Instructions: Note: You will need to download medical apps onto an iPhone, iPad, or Android device to complete this assignment. If you do not have any of these devices, you may use the app in a web browser on the host’s website. Assignment Instructions: Review the following tutorial on

Descriptionforat 570 Leadership’s Crucial Role in Optimizing Electronic Health Record Implementation for Healthcare Organizations in

Description forat 570 Leadership’s Crucial Role in Optimizing Electronic Health Record Implementation for Healthcare Organizations in KSA COLLAPSE Leadership plays a pivotal role in successfully implementing electronic health records (EHRs), particularly in ensuring that these systems meet the functional needs of end-users within healthcare organizations. This focus on end-user satisfaction

See attached instructionsInstructions 1-Write a 4 pages Paper (not including references page) following strict APA Format.

See attached instructions Instructions 1-Write a 4 pages Paper (not including references page) following strict APA Format. 2-Develop the following questions on your paper: -How would you, as a health professional, plan policy change in your community to address the realities of millions of older adults living in urban communities?

Submit your final research proposal. Note:You will not actually carry out your research project (i.e. operationalize your research design) in this class.

Submit your final research proposal. Note:You will not actually carry out your research project (i.e. operationalize your research design) in this class. You are writing a proposal for this assignment (which is often used to obtain funding such as a grant to complete the research). It is not a complete research

DescriptionCollege of Health Sciences Department of Public Health PHC374 – PAPER ASSIGNMENT Course name: ORAL HEALTH PROMOTION Course

Conduct a search for information on one of the following aversive procedures: guided (forced) compliance, attention extinction, and escape extinction.

Conduct a search for information on one of the following aversive procedures: guided (forced) compliance, attention extinction, and escape extinction. Cite the source and describe the treatment. Discuss 3–4 pro statements that might be given to support the use of the treatment. Also, discuss 3–4 con statements that might be

DescriptionCollege of Health Sciences Department of Public Health PHC374 – PAPER ASSIGNMENT Course name: ORAL HEALTH PROMOTION Course

how does medicare certs affect healthcare COMPETENCIES7022.1.3 : Licensure, Certification, and Accreditation Standards

how does medicare certs affect healthcare COMPETENCIES 7022.1.3 : Licensure, Certification, and Accreditation Standards The graduate analyzes how licensing, certification, and accreditation agencies for healthcare organizations impact healthcare delivery at federal, state, local, and organizational levels. 7022.1.4 : Quality, Reimbursement, and Patient Access to Healthcare The graduate analyzes how relationships between clinical

Develop a new paragraph of analysis on your primary text for Essay 1. The goal here is to write a paragraph that will can be directly included in Essay 1

Develop a new paragraph of analysis on your primary text for Essay 1. The goal here is to write a paragraph that will can be directly included in Essay 1 Draft 2. For this paragraph, focus on one of the rhetorical elements of the text that you did not analyze in Draft 1: Context: What was

Discussion 3- Alexis Alexis Dea Greetings Classmates, (1) What is the framework for evaluating

Discussion 3- Alexis Alexis Dea Greetings Classmates, (1) What is the framework for evaluating alternative site locations? What are the qualitative and quantitative factors involved in site selection? When considering locations, for a site it’s important to have an approach. This starts with understanding the needs and objectives of

All information in attachments. Please read thoroughly. Program of Study: Doctor of Education in Organizational Leadership K-12.

See AttachmentUse the Following Case: Andrea Yates Instructions:

See Attachment Use the Following Case: Andrea Yates Instructions: · 8 pages in length · APA guidelines · at least three references related to your case · five peer-reviewed academic references (attached) · Documents must have all pages numbered and be double-spaced, with one-inch margins on all sides, and should

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