Create a pie chart for data

Assignment Help Other Subject
Reference no: EM131776268

Question 1 - Pie Chart

Requirements:

1. Create a pie chart for data in the sheet named "Question 1". The chart should be on the same sheet as the data.
2. Give the chart an appropriate title.
3. The legend should be on the right hand side of the chart.
4. The pie chart should have data labels which should be in precentages.
5. Move the pie chart segment with the highest percentage so that it is separated from the rest of the pie chart.

Question 2 - Formulas& Projections

Requirements: Extend the table in the sheet named "Question 2" and use appropriate formulas to show the following:
1. Total for each quarter, total for each city and overall total
2. Average per quarter for each city and average per city for each quarter
3. Create another table in the same sheet, showing projections for next year, using the following assumptions:
a. Quarter 1 - increase by 5% compared to current quarter 1
b. Quarter 2 - increase by 7% compared to current quarter 2
c. Quarter 3 - increase by 9% compared to current quarter 3
d. Quarter 4 - increase by 10% compared to current quarter 4

Question 3 - Using the IF function

Requirement: use the IF function to enable automatic Grading in the "Grade" column for data in the sheet called "Question 3"

Question 4 - Pivot Tables

Requirements: Using data on sheet called "Question 4",
1. Use Vlookup to automatically fill in the unit price of the products, which is included in the Table 2.
2. Use appropriate formula for total column in Table 1
3. Create a pivot table that looks like the table below (the order of region and product does not matter). Your pivot table should have the appropriate numbers instead of zero's as in the table below:

Salesperson  (All)


Units sold  Region East West  Grand Total
Product 



Binder 0 0 0 0
Desk 0
0 0
Pen 0 0 0 0
Pen Set 0 0
0
Pencil 0 0 0 0
Grand Total 0 0 0 0

Attachment:- Sales data.xlsx

Verified Expert

In the particular excel work, the analyst has worked out the solution of a different task assigned to him. This consisted of the excel sheet which has 4 different problems. These problems namely pie chart where the analyst has prepared and worked out on the excel data in chart format. next, to that, there are certain projections wherein data analysis of the available data is been worked out. The complete 4 parts of the work incorporated formulae based problems, pivot table etc.

Reference no: EM131776268

Questions Cloud

Find site that sells directly to consumers : Find a site that sells directly to consumers that you feel doesn’t generate sufficient interest in its products.
Discuss companys processes might have permitted the fraud : What weaknesses in the company's processes might have permitted the fraud
What is the effective daily capacity of the process : A law firm handles two types of insurance policies. Policy 1 requires 4 hours of Resource 1. What is the effective daily capacity of the process?
How companies implement change management procedures : How other companies implement change management procedures into their workplace. You might be surprised by what you find.
Create a pie chart for data : BIS 101 - Business Information Systems - Create a pivot table that looks like the table below (the order of region and product does not matter).
Knowledge of punctuation rules : knowledge of punctuation rules. As she mentioned last week we will not be meeting again until September.
Franklin delano roosevelt : Among the two or three best presidents in American history, Franklin Delano Roosevelt (1882-1945) lived a charmed life through the summer of 1921.
Prepare a budget for carmen cookies for june : Management expects the number of cookies sold to be 15 percent greater in June than in April, Prepare a budget for Carmen's Cookies for June
Share the defining humanistic values developed by the greeks : 1. Share the defining Humanistic values developed by the Greeks 2. The significance of Greek Humanistic contributions

Reviews

inf1776268

6/30/2018 5:59:30 AM

Was good I got it what i have needed but could be more better. I'm very satisfied about my assignment. For sure I will use it for a long time in future, I have almost acquired my degree.

len1776268

12/21/2017 4:23:01 AM

Instructions to Candidates: 1. Students have been e-mailed an excel workbook with 4 excel sheets. There are a number of versions that were e-mailed to individual students and students must use the version e-mailed to them. If the excel workbook with answers that are uploaded are different from that e-mailed to the individual student, that student will not be awarded any marks. 2. The worksheet will be sent to your Stotts e-mail address. If you did not receive it, please let your lecturer know. 3. Please answer all questions on the excel workbook itself. 4. Marks will not be awarded if formula is not used where appropriate/required, even if correct answers are manually entered.

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!

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