Acopy the sales data provided on the vle into a separate, Ask an Expert

Management Studies

a) Copy the sales data provided on the VLE into a separate worksheet within your Garden workbook and call it Sales Database. Sort this data into sales for each month in 2010 and show a subtotal of the sales for each month. Use these subtotals to produce a bar chart for total monthly sales during 2010.

b) Sort the data into Sales by Product and create a sub total for quantity of each sold. Produce a pie chart to represent the sales of each garden extra.

c) Add a filter to show the sales for a particular product selected by the user.

d) You should be able to see which product has sold the most and which the least, Use the MIN and Max functions to confirm your view, and to display which product has sold the most and which the least. (VLOOKUP will be required)

View complete question

Business Management, Management Studies

Category:- Business Management
Reference No.:- M9531778

Have any Question?Write your Review or question?

Related Questions in Business Management

Prepare a business case for the global treps project assume

Prepare a business case for the Global Treps project. Assume that the project will take six months to complete, use many volunteer hours, and cost about $120,000 for hardware, software, travel, and labor.

Qualitative analysis for managerscan either influence

Qualitative Analysis for Managers Can either Influence Diagrams, Influence Tables, and Decision Trees or all of these techniques better structure the decision making process? Why or why not? Cite examples when this might ...

What is norways global health issues and how can they be

What is Norway's global health issues and how can they be combated?

- can identify and explain diverse cultural perspectives on

- Can identify and explain diverse cultural perspectives on death and dying - Can analyze representations of death and mortality in art and popular culture Overview Aging and death are not subjects most people enjoy talk ...

Resource allocation problemfor product a a 10 increase in

Resource Allocation problem: For product A, a 10% increase in investment increases the quantity sold by 5% whereas for product B, a 10% increase in investment increase quantity sold by 20%. The current unit sales level o ...

Suppose that many big corporations decide not to

Suppose that many big corporations decide not to issue? bonds, since it is now too costly to comply with new financial market regulations. Can you describe the expected effect on interest? rates? A. The impact will trans ...

What value to your future career in business is supported

What value to your future career in business is supported by research, analysis and communication (writing and speaking)?

In fostering understanding of utilizing big-oh notation in

In fostering understanding of utilizing Big-Oh notation in an application, please provide a simple java code segment that illustrates how Big-Oh can be utilized to pinpoint performance problems.

Please read the fact situation carefully and using your

Please read the fact situation carefully, and using your knowledge of contract law, decide whether there is a contract between Jack and Cliff and between Jack and Cynthia and explain why. On Thursday, May 14, Jack receiv ...

What goals seem to dominate early management principles why

What goals seem to dominate early management principles? Why do you think this is the case?

4,153,160 Questions Asked
13,132 Experts
2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Recent Questions

Ask Business Management Expert